1
drop table if exists t1;
2
create table t1(a int);
3
insert into t1 values(1);
4
ERROR at line 9: DELIMITER must be followed by a 'delimiter' character or string
6
Test default delimiter ;
10
Test delimiter without arg
32
Test delimiter delimiter
40
Test delimiter : from command line
44
Test delimiter :; from command line
48
Test 'go' command(vertical output) G
49
*************************** 1. row ***************************
56
create table t1(a int);
72
+----------------------+------------+--------+
73
| concat('>',col1,'<') | col2 | col3 |
74
+----------------------+------------+--------+
76
| >a < | 0123456789 | 4 |
78
+----------------------+------------+--------+
79
+------+------+---------------------------+
81
+------+------+---------------------------+
83
| NULL | NULL | <-----------------------> |
84
| NULL | NULL | <----- |
85
| NULL | NULL | Τη γλώσσα |
86
| NULL | NULL | ᛖᚴ ᚷᛖᛏ |
87
+------+------+---------------------------+
93
+-------+---------+------+-----+---------+-------+
94
| Field | Type | Null | Key | Default | Extra |
95
+-------+---------+------+-----+---------+-------+
96
| i | int(11) | YES | | NULL | |
97
| j | int(11) | NO | | | |
98
| k | int(11) | YES | | NULL | |
99
+-------+---------+------+-----+---------+-------+
107
create table t1(a int, b varchar(255), c int);
108
Field Type Null Key Default Extra
110
b varchar(255) YES NULL
112
Field Type Null Key Default Extra
114
b varchar(255) YES NULL
119
ERROR 1064 (42000) at line 3: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
120
ERROR at line 1: USE must be followed by a database name