笔记待整理

Last login: Wed Mar 15 11:13:39 on ttys003

bogon:~ tinghou$ mysql -uroot -p123456;

Warning: Using a password on the command line interface can be insecure.

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 5556

Server version: 5.6.12 MySQL Community Server (GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use day14;

Database changed

mysql> show create table product;

ERROR 1146 (42S02): Table 'day14.product' doesn't exist

mysql> show tables;

Empty set (0.00 sec)

mysql> create table product(

    -> pid varchar(96),

    -> pname varchar(150),

    -> market_price double,

    -> shop_price double,

    -> pimage date,

    -> pdesc varchar(765)

    -> );

Query OK, 0 rows affected (0.04 sec)

mysql> INSERT INTO product VALUES('1','小米 4c 标准版','1399','1299','products/1/c_0001.jpg','2015-11-02','小米 4c 标准版 全网通 白色 移动联通电信4G手机 双卡双 待');

ERROR 1136 (21S01): Column count doesn't match value count at row 1

mysql> show create table product;

+---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Table   | Create Table                                                                                                                                                                                                                                                                     |

+---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| product | CREATE TABLE `product` (

  `pid` varchar(96) DEFAULT NULL,

  `pname` varchar(150) DEFAULT NULL,

  `market_price` double DEFAULT NULL,

  `shop_price` double DEFAULT NULL,

  `pimage` date DEFAULT NULL,

  `pdesc` varchar(765) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 |

+---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.00 sec)

mysql> alter table product modify column pimage varchar(600);

Query OK, 0 rows affected (0.28 sec)

Records: 0  Duplicates: 0  Warnings: 0

mysql> desc table product;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table product' at line 1

mysql> desc product;

+--------------+--------------+------+-----+---------+-------+

| Field        | Type         | Null | Key | Default | Extra |

+--------------+--------------+------+-----+---------+-------+

| pid          | varchar(96)  | YES  |     | NULL    |       |

| pname        | varchar(150) | YES  |     | NULL    |       |

| market_price | double       | YES  |     | NULL    |       |

| shop_price   | double       | YES  |     | NULL    |       |

| pimage       | varchar(600) | YES  |     | NULL    |       |

| pdesc        | varchar(765) | YES  |     | NULL    |       |

+--------------+--------------+------+-----+---------+-------+

6 rows in set (0.01 sec)

mysql> alter table product add pdate date;

Query OK, 0 rows affected (0.08 sec)

Records: 0  Duplicates: 0  Warnings: 0

mysql> desc product;

+--------------+--------------+------+-----+---------+-------+

| Field        | Type         | Null | Key | Default | Extra |

+--------------+--------------+------+-----+---------+-------+

| pid          | varchar(96)  | YES  |     | NULL    |       |

| pname        | varchar(150) | YES  |     | NULL    |       |

| market_price | double       | YES  |     | NULL    |       |

| shop_price   | double       | YES  |     | NULL    |       |

| pimage       | varchar(600) | YES  |     | NULL    |       |

| pdesc        | varchar(765) | YES  |     | NULL    |       |

| pdate        | date         | YES  |     | NULL    |       |

+--------------+--------------+------+-----+---------+-------+

7 rows in set (0.00 sec)

mysql>