MySQL Forums
Forum List  »  Newbie

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?

Options: ReplyQuote




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.