mysql ignore 1 lines_MYSQL使用笔记（1）

创建用户 用户名 dnsexpuser 密码：dnsexp1347

insert into mysql.user(Host,User,Password) values ('localhost','dnsexpuser',password('dnsexp1347')) ;

创建数据库

分配数据库权限

create database wap_tagdb ;

grant all privileges on wap_tagdb.*to waptag@localhost identified by '123123' ;

增加表字段 alter table 表名 add 字段 类型

alter table wap_host_old add flag int(2) not null default 0 ;

删除表中字段

alter table wap_host_old drop column flag

从文件里导入数据

load data infile '/tmp/tt.txt' into table wap_subtag fields terminated by '/t' enclosed by '' lines terminated by '/n' IGNORE 1 LINES (subtag_id,subtag_name);

查询导出到文件里

select host,sys_toptag,sys_subtag,new_toptag,new_subtag,date_format(FROM_UNIXTIME(modtime),'%Y-%m-%d') into outfile '/tmp/log20110105.txt' fields terminated by '/t' optionally enclosed by '' lines terminated by '/n' from wap_log ;

分享到：

2011-01-05 18:04

浏览 477

评论