Показать сообщение отдельно
Старый 30.08.2012, 20:54   #22
Регистрация: 25.12.2011
Сообщений: 265
Репутация: 33
По умолчанию

20:58:32||/home/kai-> mysql -utest -p12345
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.25 Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select 1 from mysql.user procedure analyse ((select 1 from (select 1)a),1);
ERROR 1142 (42000): SELECT command denied to user 'test'@'localhost' for table 'user'
mysql> show databases;
| Database           |
| information_schema |
| test               |
2 rows in set (0.09 sec)

mysql> use test;
Database changed
mysql> show tables;
Empty set (0.00 sec)

mysql> create table lol;
ERROR 1113 (42000): A table must have at least 1 column
mysql> create table lol(`loltest` int(10));
Query OK, 0 rows affected (0.17 sec)

mysql> select 1 from test.lol procedure analyse ((select 1 from (select 1)a),1);
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> show status like 'Uptime';ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
Can't connect to the server

mysql> show status like 'Uptime';
No connection. Trying to reconnect...
Connection id:    1
Current database: test

| Variable_name | Value |
| Uptime        | 2     |
1 row in set (0.00 sec)

Последний раз редактировалось 12309; 30.08.2012 в 21:04.. Причина: пардон, я лол
12309 вне форума   Ответить с цитированием