drop table if exists t1; create table t1(a int); insert into t1 values(1); ERROR at line 9: DELIMITER must be followed by a 'delimiter' character or string Test default delimiter ; a 1 Test delimiter without arg Test delimiter : a 1 Test delimiter : a 1 Test delimiter :; a 1 Test delimiter // a 1 Test delimiter MySQL a 1 Test delimiter delimiter a 1 Tables_in_test t1 t2 t3 _ Test delimiter : from command line a 1 _ Test delimiter :; from command line a 1 _ Test 'go' command(vertical output) G *************************** 1. row *************************** a: 1 _ Test 'go' command g a 1 drop table t1; create table t1(a int); lock tables t1 write; database() test unlock tables; drop table t1; ソ ソ c_cp932 ソ ソ ソ ソ ソ ソ ソ +----------------------+------------+--------+ | concat('>',col1,'<') | col2 | col3 | +----------------------+------------+--------+ | >a < | b | 123421 | | >a < | 0123456789 | 4 | | >abcd< | | 4 | +----------------------+------------+--------+ +------+------+---------------------------+ | i | j | k | +------+------+---------------------------+ | 1 | NULL | NULL | | NULL | NULL | <-----------------------> | | NULL | NULL | <----- | | NULL | NULL | Τη γλώσσα | | NULL | NULL | ᛖᚴ ᚷᛖᛏ | +------+------+---------------------------+ +------+---+------+ | i | j | k | +------+---+------+ | NULL | 1 | NULL | +------+---+------+ +-------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+-------+ | i | int(11) | YES | | NULL | | | j | int(11) | NO | | | | | k | int(11) | YES | | NULL | | +-------+---------+------+-----+---------+-------+ +------+------+ | i | s1 | +------+------+ | 1 | x | | 2 | NULL | | 3 | | +------+------+ create table t1(a int, b varchar(255), c int); Field Type Null Key Default Extra a int(11) YES NULL b varchar(255) YES NULL c int(11) YES NULL Field Type Null Key Default Extra a int(11) YES NULL b varchar(255) YES NULL c int(11) YES NULL drop table t1; 1 1 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 ERROR at line 1: USE must be followed by a database name \ \\ '; '; End of 5.0 tests