MySQL Forums

Re: creating a table is there another way to do this?
Posted by: Mark Roberge
Date: September 22, 2022 09:31AM

I was able to create a table. I started inserting data into the table. Just one row. I am trying to insert a second row and have a problem.

mysql> INSERT INTO `cars`.`inventory` (`VIN`, `YEAR`, `Make`, `Model`, `TRIM`, `EXT_COLOR`, `INT_COLOR`, `ASKING_PRICE`, `SALE_PRICE`, `PURCHASE_PRICE`, `MILEAGE`, `TRANSMISSION`, `PURCHASE_DATE`, `SALE_DATE`) VALUES ('5FNYF4H91CB054036', '2012', 'Honda', 'Pilot', 'Touring', 'White Diamond Pearl', 'Leather', '37807', 'NULL, '34250', '7076', 'Automatic', '2012-11-08', NULL);

When I hit enter I get this '> Any ideas?

Subject
Written By
Posted
September 21, 2022 12:45PM
September 21, 2022 05:47PM
September 21, 2022 05:56PM
September 21, 2022 05:59PM
September 21, 2022 06:07PM
September 21, 2022 06:02PM
September 21, 2022 07:34PM
September 21, 2022 07:48PM
September 21, 2022 08:22PM
September 22, 2022 08:00AM
Re: creating a table is there another way to do this?
September 22, 2022 09:31AM
September 22, 2022 03:50PM
September 22, 2022 06:05PM
September 22, 2022 06:12PM
September 22, 2022 06:25PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.