MySQL Forums
Forum List  »  Newbie

Re: creating a table is there another way to do this?
Posted by: Barry Galbraith
Date: September 22, 2022 03:50PM


indicates that commandline client is waiting for you to close a quote ' and supply a terminator ;

If you look closely, there's an un-closed quote at 'NULL
You should lose the quote ' on NULL

To look at the definition of your table

to show the data in your table
SELECT * FROM inventory;

Note. Only use SELECT * in testing. In your real application you should SELECT the columns you want by name.

Good luck,

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.