17 Jun
2009
17 Jun
'09
12:56 p.m.
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