Hi all, Peter!
Sujay Koduri wrote:
You havent specified the datatype for the column 'id'.
Right, this should be fatal.
But I also take issue with other parts:
[[...]]
-Original Message-
From: Peter Matulis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 15, 2005 10:57 AM
In article [EMAIL PROTECTED],
Joerg Bruehe [EMAIL PROTECTED] writes:
CREATE TABLE users (
id PRIMARY KEY,
priority integer NOT NULL DEFAULT '7',
policy_id integer unsigned NOT NULL DEFAULT '1',
Even though this may work, it is wrong IMNSHO:
You set character strings as default values for
Harald Fuchs wrote:
In article [EMAIL PROTECTED],
Joerg Bruehe [EMAIL PROTECTED] writes:
CREATE TABLE users (
id PRIMARY KEY,
priority integer NOT NULL DEFAULT '7',
policy_id integer unsigned NOT NULL DEFAULT '1',
Even though this may work, it is wrong IMNSHO:
You set character strings as
--- Joerg Bruehe [EMAIL PROTECTED] wrote:
Sujay Koduri wrote:
You havent specified the datatype for the column 'id'.
Right, this should be fatal.
But I also take issue with other parts:
CREATE TABLE users (
id PRIMARY KEY,
priority integer NOT NULL DEFAULT '7',
Hi Peter, all!
Peter Matulis wrote:
--- Joerg Bruehe [EMAIL PROTECTED] wrote:
[[...]]
CREATE TABLE users (
id PRIMARY KEY,
priority integer NOT NULL DEFAULT '7',
policy_id integer unsigned NOT NULL DEFAULT '1',
Even though this may work, it is wrong IMNSHO:
You set character strings
You havent specified the datatype for the column 'id'.
sujay
-Original Message-
From: Peter Matulis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 15, 2005 10:57 AM
To: mysql@lists.mysql.com
Subject: where is the mistake in this SQL statement?
{ this is a resend, forgot subject in