Mysql command examples - sinsunsan/archiref_wiki GitHub Wiki

mysql> show tables;

mysql> SELECT * FROM flickrsync_users LIMIT 0,10;

+-----+--------------+-------------------+------------+---------------------+
| uid | nsid         | identifier        | start_date | tags                |
+-----+--------------+-------------------+------------+---------------------+
| 163 | 54549576@N00 | wojtek gurak      | 1335883299 | archiref            |
|  10 | 12997364@N00 | Sébastien Lucas   | 1354495168 | archiref            |
| 202 | 8528031@N02  | Clement Guillaume | 1355702669 | archiref            |
|  96 | 8232448@N05  | Martin ARGYROGLO  | 1353678639 | archiref            |
| 218 | 54686175@N06 | Ken Lee 2010      | 1354199809 | archiref            |
| 257 | 56471098@N07 | carol aplogan     | 1355736361 |                     |
| 265 | 24771023@N05 | PFRunner.         | 1256946263 | portrait, architect |
+-----+--------------+-------------------+------------+---------------------+