zhu 21
二 创建数据库、创建表user
create database youku; --创建数据库
use youku; -- 选择数据库
DROP TABLE IF EXISTS...user INTO OUTFILE 'F:/user1.txt'
Fields TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"';
-- 表数据导入...(注意,导入的数据的列数要对应表的各列)
-- 先删除数据
use youku;
delete from user where age>10;
select * from user;
LOAD...DATA INFILE 'F:/user.txt' INTO TABLE user;
select * from user;
-- 导入有特殊格式的表user1.txt(去除分隔号','和字串的引号...","admin",18
"root","root",18
"cat","cat",17
"dog","dog",15
"dog1","dog1",15
"zhu","zhu",21
----
结语：数据的具体导入导出格式大家可以自己尝试一下
