Skip to content

Instantly share code, notes, and snippets.

@smtlaissezfaire
Created October 20, 2009 15:47
Show Gist options
  • Save smtlaissezfaire/214362 to your computer and use it in GitHub Desktop.
Save smtlaissezfaire/214362 to your computer and use it in GitHub Desktop.
scott$ mysql --version
mysql Ver 14.14 Distrib 5.1.32, for apple-darwin9.5.0 (i386) using readline 5.1
...
mysql> show full tables;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 12
Current database: designcause_dev
+---------------------------+------------+
| Tables_in_designcause_dev | Table_type |
+---------------------------+------------+
| addresses | BASE TABLE |
| causes_index | VIEW |
| competitions_index | VIEW |
...
| votes | BASE TABLE |
+---------------------------+------------+
46 rows in set (0.01 sec)
mysql> show create table causes_index;
+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
| View | Create View | character_set_client | collation_connection |
+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
| causes_index | CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `causes_index`.... | utf8 | utf8_general_ci |
+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
1 row in set (0.00 sec)
mysql> show create table competitions_index;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> show create view competitions_index;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 2
Current database: designcause_dev
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> show create view competitions_index;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 1
Current database: designcause_dev
ERROR 2013 (HY000): Lost connection to MySQL server during query
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment