I wanted to clone the schema of my table "aitossne-icode.sshkey" into a new table "kaydir.keytab". Here's what I did :
mysql> use keydir
Database changed
mysql> CREATE table keytab LIKE aitossne_icode.sshkey;
Query OK, 0 rows affected (0.06 sec)
mysql> show tables
-> ;
+------------------+
| Tables_in_keydir |
+------------------+
| keytab |
+------------------+
1 row in set (0.00 sec)
mysql> use keydir
Database changed
mysql> CREATE table keytab LIKE aitossne_icode.sshkey;
Query OK, 0 rows affected (0.06 sec)
mysql> show tables
-> ;
+------------------+
| Tables_in_keydir |
+------------------+
| keytab |
+------------------+
1 row in set (0.00 sec)
Comments
Post a Comment