Hi
AUTO_INCREMENT needs to be an integer, NUMERIC is a decimal?
not 100% sure but it looks like it
Peter
-Original Message-
From: Cesar Baquerizo [mailto:[EMAIL PROTECTED]
Sent: 24 March 2003 20:59
To: MySQL
Subject: CREATE syntax wrong?
Hello,
I am on:
mysql Ver 11.18 Distrib
helps
Roger
-Original Message-
From: Cesar Baquerizo [mailto:[EMAIL PROTECTED]
Sent: Monday, March 24, 2003 3:59 PM
To: MySQL
Subject: CREATE syntax wrong?
Hello,
I am on:
mysql Ver 11.18 Distrib 3.23.54, for pc-linux (i686)
Is there any reason the following should not work:
CREATE
Hello,
I am on:
mysql Ver 11.18 Distrib 3.23.54, for pc-linux (i686)
Is there any reason the following should not work:
CREATE TABLE category
(
category_id NUMERIC NOT NULL AUTO_INCREMENT,
category_name VARCHAR(40),
description VARCHAR(80),
PRIMARY KEY (category_id)
) TYPE=MyISAM;
I
