i just typed that here , in my server its auto_increment too, On Wed, Jun 17, 2009 at 10:52 AM, Steve Obbayi <steve@sobbayi.com> wrote:
check your spelling of auto_increament it should be auto_increment
Steve Obbayi,
Tel: +1 202 470 0575 cell: +254 722 627691
*From:* skunkworks-bounces@lists.my.co.ke [mailto: skunkworks-bounces@lists.my.co.ke] *On Behalf Of *I. Ati *Sent:* Wednesday, June 17, 2009 10:46 AM *To:* skunkworks; Skunkworks forum *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