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, you can't reply to this topic. It has been closed.

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.