Re: creating a table is there another way to do this?

[Barry Galbraith]

Quote

'>

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

SHOW CREATE TABLE inventory;

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,
Barry.