Think syntax is OK; Not even in arrangement....

mysql> create database clients;
Query OK, 1 row affected (0.02 sec)

mysql> use clients;
Database changed

mysql> create table users(
    -> client_id int unsigned not null auto_increment primary key,
    -> client_name varchar(20),
    -> client_mobile varchar(15),
    -> client_age int,
    -> country varchar(50),
    -> city varchar(50));
Query OK, 0 rows affected (0.02 sec)

Are you having bugs there.....?




2009/6/17 I. Ati <mueni0@gmail.com>
@nicholas same error

On Wed, Jun 17, 2009 at 11:29 AM, Nicholas Loki <lokimwenga@yahoo.com> wrote:
> mysql> create table client(
>    -> client_id int unsigned not null auto_increament primary key,
 
Chuck the 'not null clause in the definition of the client_id  field, see if that helps.

"Excellent people exceed expectations".


From: I. Ati <mueni0@gmail.com>
To: skunkworks <skunkworks@my.co.ke>; Skunkworks forum <skunkworks@lists.my.co.ke>
Sent: Wednesday, June 17, 2009 10:45:43 AM

Subject: [Skunkworks] mysql error 1064

hi guyz
am creating a database in a linux server the  mysql version is 5.1.31, am trying to google for  the solution to this problem but cant seem to get anything practical solution on how to solve this ,
in my localhost this mysql syntax seems to work well but in my server seems to be an issue yes they are the same version

changed the syntax as per the mysql version seems to be  getting the same error  still, any suggestion or ideas will appreciate

below is the error am getting

mysql> create table client(
    -> client_id int unsigned not null auto_increament primary key,
    -> client_name varchar(20),
    -> client_mobile varchar(15),
    -> client_age int,
    -> country varchar(50),
    -> city varchar(50)
    -> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'auto_increament primary key,
client_name varchar(20),
client_mobile varchar(15),' at line 2



_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
Other services @ http://my.co.ke
Other lists
-------------
Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce
Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science
kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general



_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
Other services @ http://my.co.ke
Other lists
-------------
Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce
Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science
kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general




--
_________________
Best Regards,

Thuo Wilson