我的文章一般浅显易懂，不会搞那么深入让大家很难理解。（其实我水平也不咋样)不过有几个问题一定要注意 1、编码。 2、灵活导入导出。 一、关于编码 "我爱你","20","相貌平常，经常耍流氓！哈哈" "李奎","21","相貌平常，经常耍流氓！哈哈" "王二米","20","相貌平常，经常耍流氓！哈哈" "老三","24","很强" "老四","34","XXXXX" "老五","52","***%*￥*￥*￥*￥" "小猫","45","中间省略。。。" "小狗","12","就会叫" "×××","21","PP的很" "小坏蛋","52","表里不一" "上帝他爷","96","非常英俊" "MM来了","10","。。。" "歌颂党","20","社会主义好" "人民好","20","的确是好" "老高","10","学习很好" "斜三","60","眼睛斜了" "中华之子","100","威武的不行了" "大米","63","我爱吃" "苹果","15","好吃" +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ |Table | CreateTable | +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | t0 | CREATE TABLE `t0` ( `id` bigint(20) unsigned NOT NULL auto_increment, `name` char(20) NOT NULL, `age` tinyint(3) unsigned NOT NULL, `description` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `idx_name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 | +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql>load data infile '/tmp/t0.txt' ignore into table t0 character set gbkfields terminated by ',' enclosed by '"' lines terminated by '\n'(`name`,`age`,`description`); mysql> select * from t0; 我来说明一下相关的参数 character set gbk; ignore into table replace into table mysql>load data infile '/tmp/t0.txt' replace into table t0 character set gbkfields terminated by ',' enclosed by '"' lines terminated by '\n'(`name`,`age`,`description`); mysql> select * from t0; (`name`,`age`,`description`); 2、关于灵活性，其实也就是一个记录功能 mysql> alter table t0 add update_time timestamp not null; mysql> alter table t0 drop index idx_name; mysql>load data infile '/tmp/t0.txt' into table t0 character set gbk fieldsterminated by ',' enclosed by '"' lines terminated by '\n'(`name`,`age`,`description`) set update_time=current_timestamp; mysql> select * from t0; mysql> alter table t0 order by id desc; mysql> alter ignore table t0 add unique index idx_name (`name`); mysql> alter table t0 order by id asc; mysql> select * from t0;
免责声明：
1. 本站所有资源来自网络搜集或用户上传，仅作为参考不担保其准确性！
2. 本站内容仅供学习和交流使用，版权归原作者所有！© 查看更多
3. 如有内容侵害到您，请联系我们尽快删除，邮箱：kf@codeae.com
数据库
发布于：2021-07-05 09:25
|
阅读数：557
|
评论：0
QQ好友和群
QQ空间
