problems creating a table

[krash]

I am getting an error 1064 every time I try to create a table. I am new to MYSQL but have used oracle quite a bit. I've read thru the manual and don't think I have the syntax wrong but nevertheless it won't seem to work. I must have a setup problem or something. I am typing:<br>
<br>
create table table_name (column varcharXX);<br>
<br>
shouldn't this work?<br>
<br>
Erik craddock

 

[Damon]

You should be doing:<br>
<br>
create table my_table (my_column varchar(40));<br>
<br>
You've only left out the parenthesis.<br>
<br>
<br>
<br>

 

[cibrran]

maybe you have wrong in this line

create table my_table (my_column varchar(40));

=>this part

as you see above line wrong that between my_table... amony

(my_column....!

only You must have set it up one's empty space!

on the other hand .... You don't have merge that's between