"ERROR 1113: A table must have at least 1 column"

Hi all,

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:

Creating columns.

What all this NOT NULL etc, stuff is.

And what is VARCHAR?

Thanks in advance,
PT

Everything is outlined in the MySQL manual, specifically the sections 'MySQL Tutorial', 'Creating a table', and 'Column Types'.

Hey man,

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,
nota_stdt FLOAT,
PRIMARY KEY (code_stdt)
)



> I hope to have helped...

nice one, but i really doubt the original poster has waited these eight years for your reply