RobinWu

创建表[code="sql"]create table t8 ( `id1` timestamp NOT NULL default CURRENT_TIMESTAMP, `id2` datetime default NULL);[/code]查看表结构[code="sql"]desc t8;[/code][img]http://www.iteye.c...

[b]char数据类型尾部去空格[/b][code="sql"]create table db_name(name char(10)) engine=myisam;insert into db_namevalues("abcde"), ("abcde "), (" abcde"), (" abcde ");mysql> select name, length...

[code="sql"]CREATE TABLE `country` ( `country_id` smallint(5) unsigned NOT NULL auto_increment, `country` varchar(50) NOT NULL, `last_update` timestamp NOT NULL default CURRENT_TIMESTAMP on...

Mysql text 空洞问题[code="sql"]create table t (id varchar(100), context text);insert into t values(1, repeat('haha', 100));insert into t values(2, repeat('haha', 100));insert into t values(3, ...

[code="jave"]create table sales ( `year` int not null, `country` varchar(20) not null, `product` varchar(32) not null, `profit` int);insert into sales values(2004, "china", "tnt1",...

查看SQL执行频率[code="jave"]show status like "Com_%";[/code]记录慢语句[code="jave"]vi /etc/mysql/my.cnflog_slow_queries = /var/log/mysql/mysql-slow.log[/code]查看没有使用索引[code="jave"]expla...