笔记待整理

来源：互联网发布：大数据 nosql 编辑：程序博客网时间：2024/05/16 17:16

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)

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;

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

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

| pid | varchar(96) | 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;

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

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