username userpwd age
admin admin 18
root root 18
cat cat 17
dog dog 15
dog1 dog1 15
zhu zhu 21
二 创建数据库...、创建表user
create database youku; --创建数据库
use youku; -- 选择数据库
DROP TABLE IF EXISTS `user`;
CREATE...18),('root','root',18),('cat','cat',17),('dog','dog',15),('dog1','dog1',15),('zhu','zhu',21);
-- 表数据导出...TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"';
select * from user;
=================
三 txt文件查看
-- 表数据导出...admin",18
"root","root",18
"cat","cat",17
"dog","dog",15
"dog1","dog1",15
"zhu","zhu",21
----
结语:数据的具体导入导出格式大家可以自己尝试一下