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 expert 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 repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (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 11, 2011 | Sun MySQL
1,965 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: