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
-> client_id int unsigned not null* auto_increament* primary key thought it's auto_increment Josiah Mugambi +254 738 504418 http://blog.josiahmugambi.com SK Classifeds... Visit stockskenya.co.ke for more info. On Wed, Jun 17, 2009 at 10:45 AM, I. Ati <mueni0@gmail.com> wrote:
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
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
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
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
@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
I created the table as you have specified using MySQL Query Browser, then copied the SQL statements it generated below (I am using version 5.1.30-community): CREATE TABLE `client` ( `client_id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `client_name` VARCHAR(20), `client_mobile` VARCHAR(15), `client_age` INTEGER UNSIGNED, `country` VARCHAR(50), `city` VARCHAR(50), PRIMARY KEY (`client_id`) ) ENGINE = MyISAM; And below is your query: 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) -> ); Differences: 1. The auto_increment part 2. The primary key definition On 6/17/09, I. Ati <mueni0@gmail.com> wrote:
@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
@peter it worked thanks a lot, i appreciate every one input On Wed, Jun 17, 2009 at 11:58 AM, Peter Karunyu <pkarunyu@gmail.com> wrote:
I created the table as you have specified using MySQL Query Browser, then copied the SQL statements it generated below (I am using version 5.1.30-community):
CREATE TABLE `client` ( `client_id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `client_name` VARCHAR(20), `client_mobile` VARCHAR(15), `client_age` INTEGER UNSIGNED, `country` VARCHAR(50), `city` VARCHAR(50), PRIMARY KEY (`client_id`) ) ENGINE = MyISAM;
And below is your query: 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) -> );
Differences: 1. The auto_increment part 2. The primary key definition
On 6/17/09, I. Ati <mueni0@gmail.com> wrote:
@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
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
Actually apart from the auto_increment spelling. Your syntax is correct. Steve Obbayi, _____ From: skunkworks-bounces@lists.my.co.ke [mailto:skunkworks-bounces@lists.my.co.ke] On Behalf Of I. Ati Sent: Wednesday, June 17, 2009 11:44 AM To: Skunkworks forum Subject: Re: [Skunkworks] mysql error 1064 @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
On Wed, Jun 17, 2009 at 12:04 PM, Steve Obbayi <steve@sobbayi.com> wrote:
Actually apart from the auto_increment spelling. Your syntax is correct.
Steve Obbayi,
Obbayi's right. Copied and pasted your original syntax, corrected the typo and it's fine: mysql> create table client( -> 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.00 sec) Maybe you copy/paste what's on your screen again? BR, S
On Wed, Jun 17, 2009 at 10:45 AM, I. Ati <mueni0@gmail.com> wrote:
mysql> create table client( -> client_id int unsigned not null auto_increament primary key,
Specify the max number of characters in this column before 'unsigned', example: client_id int(30) unsigned not null auto_increment primary key, BR, S
participants (7)
-
I. Ati -
Josiah Mugambi -
Nicholas Loki -
Peter Karunyu -
Steve Muchai -
Steve Obbayi -
Thuo Wilson