Question about Sun MySQL
Trying to build a table that has 3 fields - ID, User Name, Password.
I want The ID to be unique for each user, & i want it to increase by one each time.
First users ID is 1, the second is 2, etc....
How can this be done?
Try this -
CREATE TABLE users (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
login TEXT NOT NULL,
password TEXT NOT NULL,
PRIMARY KEY( id )
INSERT INTO users VALUES ( null, 'bob', 'mypassword' );
INSERT INTO users VALUES ( null, 'bill', 'pass' );
INSERT INTO users VALUES ( null, 'sean', '1234' );
Posted on Aug 10, 2008
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Mar 11, 2015 | Oracle MySQL Enterprise Ed 1-4 Socket...
on Jan 26, 2010 | Computers & Internet
Nov 20, 2011 | NetGear WNR2000 Wireless Router
Sep 13, 2011 | Arris SURFboard SBG900 Wireless Router...
Sep 06, 2011 | Yahoo Messenger
Mar 03, 2011 | Computers & Internet
Nov 16, 2009 | AT&T CECT Unlocked i68+ Quadband GSM FM...
Oct 22, 2008 | Microsoft Access 2002 for PC
Jul 27, 2008 | Sun MySQL
Oct 09, 2017 | Sun MySQL
Oct 11, 2011 | Sun MySQL
1,968 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: