"ERROR 1113: A table must have at least 1 column"
Here's the problem of mine,
I'll create or open a db alright,
then I go to create a table, and here's what I get:
I need help with:
What all this NOT NULL etc, stuff is.
And what is VARCHAR?
Thanks in advance,
November 30th, 2012, 07:44 PM
first, and most important:
- VARCHAR as INT or CHAR are "datatypes", or types of variables...
- VARCHAR is the type normaly used to get strings
- NOT NULL indicates the restriction (if you'll can leave this table field empty - with a null value)
ok, the other important thing you will need know is about the Primary Key
this table field will identify each row of your table
this will need a unique value (each row will have a unique key)
this is important becouse is this the column that will identify specific data in your table
well, one example may be this way:
CREATE TABLE student (
code_stdt INTEGER not null,
name_stdt VARCHAR(70) not null,
PRIMARY KEY (code_stdt)
> I hope to have helped...
November 30th, 2012, 09:04 PM
nice one, but i really doubt the original poster has waited these eight years for your reply
Originally Posted by patrickpff