mysql学习记录（十四）--模式(三)
-----------------+
1 row in set (0.00 sec)
mysql> select 'bw123'||'2008';
+-------------------+
| 'bw123'||'2008' |
+-------------------+
| bw1232008 |
+-------------------+
1 row in set (0.00 sec)
mysql> show create table emp \G;
*************************** 1. row ***************************
Table: emp
Create Table: CREATE TABLE "emp" (
"ename" varchar(10) DEFAULT NULL,
"hiredate" date DEFAULT NULL,
"sal" decimal(10,2) DEFAULT NULL,
"deptno" int(2) DEFAULT NULL
)
1 row in set (0.00 sec)
ERROR:
No query specified
mysql>
set setssion sql_mode = 'NO_TABLE_OPTIONS';
ERROR 1193 (HY000): Unknown system variable 'setssion'
mysql> set session sql_mode = 'NO_TABLE_OPTIONS';
Query OK, 0 rows affected (0.00 sec)
mysql> show create table emp \G;
*************************** 1. row ***************************
Table: emp
Create Table: CREATE TABLE `emp` (
`ename` varchar(10) DEFAULT NULL,
`hiredate` date DEFAULT NULL,
`sal` decimal(10,2) DEFAULT NULL,
`deptno` int(2) DEFAULT NULL
)
1 row in set (0.00 sec)
ERROR:
No query specified