MariaDB [(none)]> use xinet_test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [xinet_test]> show create database xinet_test;
+------------+---------------------------------------------------------------------+
| Database | Create Database |
+------------+---------------------------------------------------------------------+
| xinet_test | CREATE DATABASE `xinet_test` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+------------+---------------------------------------------------------------------+
1 row in set (0.000 sec)
MariaDB [xinet_test]> show create table users;
+-------+---------------------------------------------------------------------------+
| Table | Create Table |
+-------+---------------------------------------------------------------------------+
| users | CREATE TABLE `users` (
`UID` int(11) NOT NULL AUTO_INCREMENT,
`ID` varchar(12) NOT NULL DEFAULT '',
`PWD` varchar(15) NOT NULL DEFAULT '',
`Name` varchar(15) NOT NULL DEFAULT '',
`Address1` varchar(100) NOT NULL DEFAULT '',
PRIMARY KEY (`UID`)
) ENGINE=MyISAM AUTO_INCREMENT=491 DEFAULT CHARSET=utf8 |
+-------+---------------------------------------------------------------------------+
1 row in set (0.000 sec)
MariaDB [xinet_test]> select * from users;
+-----+-----------+-----------------+--------------+----------------------------------+
| UID | ID | PWD | Name | Address1 |
+-----+-----------+-----------------+--------------+----------------------------------+
| 391 | david | sadfn123411234 | ÅõÆ÷ȯ | ¼¿ïµ¿ÀÛ±¸»ç´ç |
| 392 | dgoo134 | tde7871233r8 | ÀÜ´Ù¸£ | ÀüºÏ ÀüÁֽà ¿Ï»êÀ¾ |
| 394 | addm12134 | 12adf3qfasdfwe | ´©±¸³Ä | ±¤Áֽà ±¤»ê±¸ |
| 484 | sososo | rlad124frudxo | ¸Þ½Ã | °æºÏ ¿ïÁø±¸ ¿ïÁøÀ¾ |
| 485 | hihihi | js0dasf10123 | È£³¯µÎ | ºÎ»ê½Ã »çÇϱ¸ »çÇϵ¿ |
| 486 | uplus | rmadd1sd23fhr47 | À±ÅÃ¿Ë | Á¦ÁÖµµ ¼±ÍÆ÷½Ã ³²¿øÀ¾ |
| 487 | sorrent | rkddfa0497 | °íºô±¸ | Ãæ³² õ¾È½Ã À¯¼º¸é |
| 465 | test123 | k1asdfdsd2u1331 | È«±æµ¿ | ¼¿ï½Ã Á¾·Î±¸ À»Áö·Î |
| 488 | sksksk | k134aaadjskhs79 | À¯»ê½½ | ¼¿ï½Ã ÀºÆò±¸ ÀÀ¾Ïµ¿ |
| 489 | ktktkt | enqeasdfadf134n | Áø¹ÝÀå | °æ±â ±¤¸í½Ã ¿À¸®·Î |
| 490 | cshi0000 | kkadfdfdfi97228 | ½Ã°ñû³â | ¼¿ï½Ã ±Ýõ±¸ °¡»êµ¿ |
+-----+-----------+-----------------+--------------+----------------------------------+
11 rows in set (0.001 sec)