Programming Forums > Script Programming > Other Scripting Languages

darkone916 · Nov 19th, 2005, 12:21 PM

ahm... i have been learning MySQL lately 'cause i want to use them in webpages with php.
but there is just one simple thing that i couldn't figure how to do it:

How do you set a primary key in one of the fields?

Thank You!

OpenLoop · Nov 19th, 2005, 1:06 PM

It's been a while since i did sql but i believe that if you set a field to "not null" and "unique" it becomes a primary key.

(Toggle Plain Text)

CREATE TABLE mytbl(custname CHAR(20) NOT NULL UNIQUE);

darkone916 · Nov 19th, 2005, 1:15 PM

Thanks A lot! And please don't think that i was just been lazy, i did do some googling and searching in the forum...

DaWei · Nov 19th, 2005, 2:14 PM

(Toggle Plain Text)

CREATE TABLE mytbl
(
custname CHAR(20) NOT NULL,
...
...
...
PRIMARY KEY (custname),
...
...
);

is an alternative I use.

Nov 19th, 2005, 12:21 PM	#1
darkone916 Hobbyist Programmer Join Date: Jul 2005 Location: Oman Posts: 125 Rep Power: 4	primary key ahm... i have been learning MySQL lately 'cause i want to use them in webpages with php. but there is just one simple thing that i couldn't figure how to do it: How do you set a primary key in one of the fields? Thank You! __________________ From the bottom of the stone steps... ...i'm calling still.

Nov 19th, 2005, 1:06 PM	#2
OpenLoop Expert Programmer Join Date: May 2005 Location: East Lansing, MI Posts: 663 Rep Power: 4	It's been a while since i did sql but i believe that if you set a field to "not null" and "unique" it becomes a primary key. (Toggle Plain Text) CREATE TABLE mytbl(custname CHAR(20) NOT NULL UNIQUE); CREATE TABLE mytbl(custname CHAR(20) NOT NULL UNIQUE);

Nov 19th, 2005, 1:15 PM	#3
darkone916 Hobbyist Programmer Join Date: Jul 2005 Location: Oman Posts: 125 Rep Power: 4	Thanks A lot! And please don't think that i was just been lazy, i did do some googling and searching in the forum... __________________ From the bottom of the stone steps... ...i'm calling still.

Nov 19th, 2005, 2:14 PM	#4
DaWei Resident Grouch Join Date: Jun 2005 Posts: 6,453 Rep Power: 10	(Toggle Plain Text) CREATE TABLE mytbl ( custname CHAR(20) NOT NULL, ... ... ... PRIMARY KEY (custname), ... ... ); CREATE TABLE mytbl ( custname CHAR(20) NOT NULL, ... ... ... PRIMARY KEY (custname), ... ... ); is an alternative I use. __________________ Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code. Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)