Original Message-
> From: Martijn Tonies [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 19, 2006 9:45 AM
> To: Dan Buettner; Scott Hamm
> Cc: Mysql
> Subject: Re: Re: CREATE TABLE Inv_Id
>
>
>
>
> > Scott, what's wrong with 'PRIMARY
> Scott, what's wrong with 'PRIMARY KEY' ?
A PRIMARY KEY has nothing to do with the "uniqueidentifier" datatype.
A "uniqueidentifier" is a GUID.
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscen
Scott, what's wrong with 'PRIMARY KEY' ?
Dan
On 10/19/06, Scott Hamm <[EMAIL PROTECTED]> wrote:
Wish MySQL would have something like what Microsoft use, "uniqueidentifier"
as datatype.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
Wish MySQL would have something like what Microsoft use, "uniqueidentifier"
as datatype.
Thanks!
On 10/16/06, Gabriel PREDA <[EMAIL PROTECTED]> wrote:
I would try:
CREATE TABLE Inv_Id (
ID INT(12) UNSIGNED ZEROFILL AUTO_INCREMENT PRIMARY KEY,
MID INT NOT NULL,
FOREIGN (MID) REFERENCES 'Model' (ID)
);
Note the UNSIGNED and ZEROFILL flags !
-- -- -- -- -- -- -- -- -- -- -- -- --
I would try:
CREATE TABLE Inv_Id (
ID INT(12) UNSIGNED ZEROFILL AUTO_INCREMENT PRIMARY KEY,
MID INT NOT NULL,
FOREIGN (MID) REFERENCES 'Model' (ID)
);
Note the UNSIGNED and ZEROFILL flags !
-- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Gabriel PREDA
Senior Web Developer
--
MySQL General Mailing
(casecode prefix,
a manufacturers id, a partnumber, and a check digit) to the table definition.
- Original Message -
From: Gerald L. Clark <[EMAIL PROTECTED]>
To: Scott Hamm <[EMAIL PROTECTED]>
Cc: Mysql
Sent: Monday, October 16, 2006 2:31:47 PM GMT-0500 US/Eastern
Subject: R
Alright, I'll abandon UPC, I'm trying to serialize all components i.e. video
cards, keyboards, sound cards, etc and when I process these info into
database I would like for it to give me the image of bar code with number on
bottom and small enough to put on the metal side of components i.e. ethern
Hmmm. When the table is first created, the id number should default
to starting at 1. Once the table has had entries added and deleted
you can run an ALTER TABLE to reset it to 1, provided it is empty I
think.
There's no way to store an integer left-padded with zeros like that, however.
What y
Scott Hamm wrote:
I'm trying to create a table as follows:
CREATE TABLE Inv_Id (
ID INT(12) AUTO_INCREMENT PRIMARY KEY,
MID INT NOT NULL,
FOREIGN (MID) REFERENCES 'Model' (ID)
);
How do I make ID to start out as '0001' for UPC barcode assignment?
UPC barcodes are not sequential number
10 matches
Mail list logo
