正文
1 mysql> create database test; 2 Query OK, 1 row affected (0.05 sec) 3 4 mysql> use test; 5 Database changed 6 mysql> CREATE TABLE `user_balance` ( 7 -> `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID主键', 8 -> `name` varchar(20) DEFAULT NULL COMMENT '姓名', 9 -> `balance` decimal(10,0) DEFAULT NULL COMMENT '账户余额', 10 -> PRIMARY KEY (`id`) 11 -> ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8; 12 Query OK, 0 rows affected, 1 warning (0.15 sec)
