To see customers table
mysql>desc customers;
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 phone values (NULL, '444-555-6666', '');
No comments:
Post a Comment