Primary Key question

I've created the following table (server 4.1 in win2k) CREATE TABLE `os` ( `id` tinyint(10) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `description` varchar(255) default NULL, PRIMARY KEY (`id`,`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; and was very surprised

Re: Primary Key question

Haisam K. Ido [EMAIL PROTECTED] wrote on 01/07/2005 15:04:01: I've created the following table (server 4.1 in win2k) CREATE TABLE `os` ( `id` tinyint(10) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `description` varchar(255) default NULL, PRIMARY KEY

Re: Primary Key question

PROTECTED] To: mysql@lists.mysql.com Subject: Primary Key question I've created the following table (server 4.1 in win2k) CREATE TABLE `os` ( `id` tinyint(10) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `description` varchar(255) default NULL, PRIMARY KEY (`id

Primary Key Question

Hi all, I have table with primary key on field PO,BrgId, NOSP but when i try insert several new reccord with field NOSP = '', mysql will accept the new reccord without complaint error. Is this normal behavior? My perception if i have primary key on the three field the three field must be not

Re: Primary Key Question

Hendro Suryawan [EMAIL PROTECTED] wrote on 06/16/2005 06:53:31 PM: Hi all, I have table with primary key on field PO,BrgId, NOSP but when i try insert several new reccord with field NOSP = '', mysql will accept the new reccord without complaint error. Is this normal behavior? As long as

Re: Primary Key Question

Hendro, In SQL an empty string is not null. PB Hendro Suryawan wrote: Hi all, I have table with primary key on field PO,BrgId, NOSP but when i try insert several new reccord with field NOSP = '', mysql will accept the new reccord without complaint error. Is this normal behavior? My

RE: Compound Primary Key question

-Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: 23 April 2004 23:51 To: Emmett Bishop Cc: [EMAIL PROTECTED] Subject: Re: Compound Primary Key question On Fri, Apr 23, 2004 at 03:40:43PM -0700, Emmett Bishop wrote: Quick question. In general, is it better

Compound Primary Key question

Quick question. In general, is it better to create compound primary keys or use an auto increment field to uniquely identify each record? --T __ Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢

Re: Compound Primary Key question

On Fri, Apr 23, 2004 at 03:40:43PM -0700, Emmett Bishop wrote: Quick question. In general, is it better to create compound primary keys or use an auto increment field to uniquely identify each record? Yes. It depends on your application and your data. Jeremy -- Jeremy D. Zawodny |

Primary key question

Hi, Does MySQL automatically create index on primary key ? If not how can I create an index on a primary key ? Thanks for any help. Patrice Serrand - Before posting, please check: http://www.mysql.com/manual.php (the

Re: Primary key question

On Tue, 17 Dec 2002 19:15:08 +0100, Serrand Patrice wrote: Does MySQL automatically create index on primary key ? Yes. See http://www.mysql.com/doc/en/CREATE_TABLE.html - Steve Yates - Antonym: The opposite of the word you're searching for. ~ Taglines by Taglinator - www.srtware.com ~

Primary Key Question

I understood that MySQL didn't internally keep up with the relationships between tables... like MS Access... And that it was up to the programmer to referential integrity... But I noticed in phpMyAdmin that the offer the option of defining a column in a table as 'Primary' Am I confused on this

re: Primary Key Question

On Monday 16 December 2002 18:12, tmb wrote: I understood that MySQL didn't internally keep up with the relationships between tables... like MS Access... And that it was up to the programmer to referential integrity... But I noticed in phpMyAdmin that the offer the option of defining a

RE: mysql primary key question!

- From: Erick Papadakis [mailto:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 6:30 AM To: mysql Subject: mysql primary key question! hello, i hope some database guru can help me with this! i need to set up an auto_increment field inside mysql. for various reasons, the maximum size

mysql primary key question!

hello, i hope some database guru can help me with this! i need to set up an auto_increment field inside mysql. for various reasons, the maximum size is 3. but i don't want this to be ONLY integers because that limits me until 999 numbers only. since i have all flexibility for these three

Re: mysql primary key question!

] [EMAIL PROTECTED] - Original Message - From: Erick Papadakis [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Monday, July 08, 2002 2:30 PM Subject: mysql primary key question! hello, i hope some database guru can help me with this! i need to set up an auto_increment field

Re: mysql primary key question!

- From: Erick Papadakis [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Monday, July 08, 2002 2:30 PM Subject: mysql primary key question! hello, i hope some database guru can help me with this! i need to set up an auto_increment field inside mysql. for various reasons, the maximum

Re: mysql primary key question!

* Erick Papadakis i need to set up an auto_increment field inside mysql. for various reasons, the maximum size is 3. Could you say something about these reasons...? but i don't want this to be ONLY integers because that limits me until 999 numbers only. Well... using three _bytes_, the

SQL PRIMARY KEY question

I have written the following SQL request, but I get an error, why ? create table MovementOrder ( teamCode INT(4) NOT NULL, quarter INT(4) NOT NULL, position INT(4) NOT NULL, priority INT(4) NOT NULL, order VARCHAR(10), parameter VARCHAR(5), PRIMARY