1.啟動數據庫
#啟動mysql(skip-name-resolve參數是必須的)
su - mysql -c "mysqld_safe --skip-name-resolve --open-files-limit=4096&"
2.清空表
TRUNCATE TABLE TABLENAME;
3.復制表結構
create table 新表 LIKE 舊表;
4.復制表數據
insert into 新表 select * from 舊表;
5.往表中插入一行數據
insert into LOGIN (LOGINID,PASSWORD) VALUES('test001', '123456');
6.導入指定列
load data infile '/tmp/data.txt' into table LOGIN (LOGINID,PASSWORD);
7.導入指定列
load data infile '/tmp/data.txt' into table LOGIN (LOGINID,PASSWORD);
load data infile 'MallPrice.txt' into table MALL (ID,ITEMID,NAME,KIND,STARTSALEDATE,ENDSALEDATE,CURPRICE,PREPRICE,DISCOUNT,PAYTYPE,PAGE,POS,CANSALE,HOTSALE,MAXCOUNT,CURNUM,OPCODE);
(注:文件必須放在mysql數據目錄下,mysql數據目錄在my.cnf中datadir字段設置)