drop.result 2.09 KB
Newer Older
1
drop table if exists t1;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2
drop database if exists mysqltest;
3
drop database if exists client_test_db;
4
drop table t1;
5
ERROR 42S02: Unknown table 't1'
6 7 8 9 10
create table t1(n int);
insert into t1 values(1);
create temporary table t1( n int);
insert into t1 values(2);
create table t1(n int);
11
ERROR 42S01: Table 't1' already exists
12 13
drop table t1;
select * from t1;
14 15
n
1
16 17 18 19 20 21
create database mysqltest;
drop database if exists mysqltest;
create database mysqltest;
create table mysqltest.mysqltest (n int);
insert into mysqltest.mysqltest values (4);
select * from mysqltest.mysqltest;
22 23
n
4
24
drop database if exists mysqltest;
25
affected rows: 1
26
create database mysqltest;
27 28 29 30 31 32
use mysqltest;
drop table table1, table2, table3, table4, table5, table6,
table7, table8, table9, table10, table11, table12, table13,
table14, table15, table16, table17, table18, table19, table20,
table21, table22, table23, table24, table25, table26, table27,
table28;
33
ERROR 42S02: Unknown table 'table1,table2,table3,table4,table5,table6,table7,table8,table9,table10,table11,table12,table13,table'
34 35 36 37 38
drop table table1, table2, table3, table4, table5, table6,
table7, table8, table9, table10, table11, table12, table13,
table14, table15, table16, table17, table18, table19, table20,
table21, table22, table23, table24, table25, table26, table27,
table28, table29, table30;
39
ERROR 42S02: Unknown table 'table1,table2,table3,table4,table5,table6,table7,table8,table9,table10,table11,table12,table13,table'
40
use test;
41
drop database mysqltest;
42
flush tables with read lock;
43
create database mysqltest;
44
Got one of the listed errors
45
unlock tables;
46
create database mysqltest;
47
show databases;
48 49
Database
mysql
50
mysqltest
51
test
52
flush tables with read lock;
53
drop database mysqltest;
54
Got one of the listed errors
55
unlock tables;
56
drop database mysqltest;
57
show databases;
58 59 60
Database
mysql
test
61
drop database mysqltest;
62
ERROR HY000: Can't drop database 'mysqltest'; database doesn't exist
63 64 65
drop table t1;
flush tables with read lock;
create table t1(n int);
66
ERROR HY000: Can't execute the query because you have a conflicting read lock
67 68 69 70 71 72
unlock tables;
create table t1(n int);
show tables;
Tables_in_test
t1
drop table t1;