mysql default 无效问题 mysql 的版本是多少?另外 sqlmode 现在是什么? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 1、版本:mysql 5.0 ;2、菜鸟:不清楚什么是sqlmode ! 按如下方式贴出你的结果,不要贴图,直接如下贴文本。mysql> create table t (name char(8) not null default ' ',w varchar(10) not nulldefault ' ');Query OK, 0 rows affected (0.19 sec)mysql> show create table t;+-------+-----------------------------------| Table | Create Table+-------+-----------------------------------| t | CREATE TABLE `t` ( `name` char(8) NOT NULL DEFAULT '', `w` varchar(10) NOT NULL DEFAULT ' ') ENGINE=MyISAM DEFAULT CHARSET=latin1 |+-------+-----------------------------------1 row in set (0.00 sec)mysql>mysql> desc t;+-------+-------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+-------+-------------+------+-----+---------+-------+| name | char(8) | NO | | | || w | varchar(10) | NO | | | |+-------+-------------+------+-----+---------+-------+2 rows in set (0.12 sec)mysql> select version();+------------------+| version() |+------------------+| 5.1.58-community |+------------------+1 row in set (0.00 sec)mysql> show variables like 'sql_mode';+---------------+-------+| Variable_name | Value |+---------------+-------+| sql_mode | |+---------------+-------+1 row in set (0.00 sec)mysql> 迫切想学习MY-SQL 天啊unknown variables master-host 多表查询 mysql 存储过程 的PHP调用 mysql高版本数据库表名在低版本乱码 mysql外连接问题 mysql更新数据库内容 如何用ASP连接POSTGRESQL??? mysql全文检索 新手求助!在线等!昨天刚装上MySql,试了一下可以用,今天打开的时候,输入密码后就闪退了~ mysql 存储过程 通过参数查询的问题 select count(*)中如何使用having?
1、版本:mysql 5.0 ;
2、菜鸟:不清楚什么是sqlmode !
default ' ');
Query OK, 0 rows affected (0.19 sec)mysql> show create table t;
+-------+-----------------------------------
| Table | Create Table
+-------+-----------------------------------
| t | CREATE TABLE `t` (
`name` char(8) NOT NULL DEFAULT '',
`w` varchar(10) NOT NULL DEFAULT ' '
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+-------+-----------------------------------
1 row in set (0.00 sec)mysql>
mysql> desc t;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| name | char(8) | NO | | | |
| w | varchar(10) | NO | | | |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.12 sec)mysql> select version();
+------------------+
| version() |
+------------------+
| 5.1.58-community |
+------------------+
1 row in set (0.00 sec)mysql> show variables like 'sql_mode';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| sql_mode | |
+---------------+-------+
1 row in set (0.00 sec)mysql>