MySQL插入练习2

mysql> create table book_list (
    -> book_name varchar(30),
    -> author varchar(20),
    -> book_price decimal(4, 2),
    -> book_type varchar(30)
    -> );
Query OK, 0 rows affected (0.32 sec)

mysql> insert into book_list values (
    ->      'Java核心技术',
    ->      'Cay S. Horstman',
    ->      56.43,
    ->      '计算机技术'
    ->      );
Query OK, 1 row affected (0.03 sec)

mysql> select * from book_list;
+------------------+-----------------+------------+-----------------+
| book_name        | author          | book_price | book_type       |
+------------------+-----------------+------------+-----------------+
| Java核心技术     | Cay S. Horstman |      56.43 | 计算机技术      |
+------------------+-----------------+------------+-----------------+
1 row in set (0.00 sec)