Sunday, August 11, 2013

Insert Data

To see customers table
mysql>desc customers;



To insert data

first_name | last_name | state | brith_date | sex | CUST_ID | last_meeting | money_owed

mysql>INSERT INTO customers VALUES ('Paul', 'Jones', 'PA', '1972-10-2', 'M', NULL, NULL, '54.96' );
#NULL is used for CUST_ID because it is set to AUTO_INC 

To insert data in specified columns


mysql>INSERT INTO customers VALUES(last_name,first_name) values ('Paul', 'Jones');

mysql>INSERT INTO customers VALUES(last_name,first_name) values ('Paul', 'Jones');

mysql> insert into phone values (NULL, '444-555-6666', '');


No comments:

Post a Comment