Home >Database >Mysql Tutorial >MYSQL比较生僻的几种sql语句小结_MySQL
MYSQL比较生僻的几种sql语句小结_MySQL
- WBOYOriginal
- 2016-06-01 13:41:49854browse
bitsCN.com MYSQL比较生僻的几种sql语句小结 //txt文件入数据库LOAD DATA INFILE 'data.txt' INTO TABLE table2FIELDS TERMINATED BY ','; //导出空的库表结构mysqldump -d -u xxx -p resin_log> /temp/dump.sql //查看MYSQL配置,这些信息一般都是静态的show variables; //查看MYSQL 状态，这些信息一般都是动态的show status//修改字段原有属性ALTER TABLE ind_day_scale MODIFY COLUMN avg_pv double unsigned NOT NULL DEFAULT '0' COMMENT '新增PV/新增UV'//更改一个字段的部分值UPDATE day_resinlog_2012_06_12 SET access_time = REPLACE(access_time,'2012-06-12','2012-06-14') 作者 lovemelovemycode bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySQL心得6--MySQL语言结构--运算符、表达式_MySQLNext article：Mysql学习1―――创建、查看、删除数据库_MySQL