CREATE TABLE Item(Item_no varchar(10), Type varchar(10), Size varchar(10), Colour varchar(10), Brand varchar(30), Purchase_Date Date, Price varchar(15), Hiring_rate varchar(10));
What's wrong with this CREATE ＴＡＢＬＥ query?
When I try to insert it, it was told invalid identifier.
I dunno why.
Plz help me. Thank you very much!!!
The query is fine. I just created the table on my test database.
Post the exact error you are facing.
did you check if you have already created the table? did you try other queries? do they work?
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.