Mysql 记录复制导入和导出
来源:互联网 发布:网络招聘的劣势是 编辑:程序博客网 时间:2024/06/05 02:46
Mysql 记录复制导入和导出
复制记录
lower 不区分大小写函数
password 加密函数
> create table employee (id int,name char(10),agi int,sex enum('M','F'),department char(10));
> insert into employee values (23,'john',27,'M','Engi'),(31,'Sue',31,'F','Fiance'),(113,'David',26,'M','Admin');
> select * from employee;
+------+-------+------+------+------------+
| id | name | agi | sex | department |
+------+-------+------+------+------------+
| 23 | john | 27 | M | Engi |
| 31 | Sue | 31 | F | Fiance |
| 113 | David | 26 | M | Admin |
+------+-------+------+------+------------+
创建表user
> create table user (uid int primary key auto_increment,uname char(10),upass char(10));
复制记录
> insert into user (uname,upass) select lower(name),password(lower(name)) from employee;
> select * from user;
+-----+-------+------------+
| uid | uname | upass |
+-----+-------+------------+
| 1 | john | *DACDE7F57 |
| 2 | sue | *934B89788 |
| 3 | david | *8201E0C1B |
+-----+-------+------------+
复制记录时,可以添加where条件
> insert into user (uname,upass) select (name),password(name) from employee where department='Fiance';
> select * from user;
+-----+-------+------------+
| uid | uname | upass |
+-----+-------+------------+
| 1 | john | *DACDE7F57 |
| 2 | sue | *934B89788 |
| 3 | david | *8201E0C1B |
| 4 | Sue | *287E48EAA |
+-----+-------+------------+
--------------------------------------------------------------------------------------------------------------------------------------------------------
导入数据
load data infile...
语法:
load data infile '文件绝对路径' into table 表名 fields terminated by '字段分割符' lines terminated by '记录分割符';
样例:
导出数据
select...into outfile...
语法:
select 字段 from 表名 into outfile '文件绝对路径' fields terminated by '字段分割服' lines terminated by '记录分割符';
样例:
- Mysql 记录复制导入和导出
- mysql导出导入记录
- mysql 导出和导入
- mysql导出,导入csv文件 多出空记录
- MySQL数据库导出和导入
- mysql数据导入和导出
- mysql的导入和导出
- MYSQL数据导出和导入
- mysql导出和导入命令
- mysql数据导出和导入
- mysql的导出和导入
- mysql导入和导出数据库
- centos mysql 导出和导入
- mysql导入和导出数据库
- MySQL 导入和导出文件
- centos mysql 导出和导入
- mysql的导入和导出
- MySQL的导入和导出
- 华中电子科技大学 oj hust1605 Gene recombination 数字代表字符串的状态解决MLE
- 在SQL Server中查询Excel数据(sp_OpenExcel)
- Spring 框架的设计理念与设计模式分析
- Android 4.2 Feature Highlight: So, What Is This Miracast Thing And How Does It Work, Anyway?
- 线程调用带参数的方法
- Mysql 记录复制导入和导出
- android开发点滴
- 数据库51年来十八件大事年表
- Hibernate事物管理
- linux自检和systemtap
- linux 定时任务: at & crontab
- SCROLLBAR
- 【1.1】系统漫游——信息就是位+上下文
- 成员变量方法_继承有别