Question about Sun MySQL

1 Answer

MySQL Auto Increase

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?


Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Contributor
  • 30 Answers

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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
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.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

'Table does not exist' error in MySQL, although it really exists


it usually means that no table exists in the default database with the given name. In some cases, it may be that the table does exist but that you are referring to it incorrectly. Maybe your database and table names are case sensitive if they are located on a file system that has case-sensitive file names. Or perhapsall references to a given table within a query must use the same lettercase.
Use SHOW TABLES to check which tables are in the default database.
Well, if you are sure that table is exist and you write its name exactly such it should be, then I suppose something wrong with the database, it can be seriously corrupt. And in this case you need a professional help. This tool must help at any rate - Recovery Toolbox for MySQL https://mysql.recoverytoolbox.com/

Mar 11, 2015 | Oracle MySQL Enterprise Ed 1-4 Socket...

Tip

Auto logon in Windows 7


You can use automatic logon to log on to your Windows 7
without having to type a user name or password.
(With automatic logon you will not see this anymore)

909853b.jpg

Configure Windows 7 to auto logon a specific user:

1. Open the Start Menu>All programs>Accessories>Run
(When you open this copy it) control userpasswords2
click the OK button.

340f3cb.png

2. Click on the user account name,
that you want to have automatically log on to highlight it.
Uncheck the Users must enter a user name and password
to use this computer box.
click the OK button.

176a6c5.png

3. If the listed box blank - unchecked.
Click on the user account name,
that you want to have automatically log on to highlight it.
click the OK button.

09c5ec2.png

4. In the Password field, enter the selected user account's password.
If the user account does not have a password, then leave this field empty.
click the OK button.

4c1f09d.png

5. Restart your system, and you’re automatically logged in to Windows 7.

on Jan 26, 2010 | Computers & Internet

1 Answer

How do I enable UPnP on this Netgear router WNR200


Open Internet Browser such as IE then type 192.168.1.1 or http://www.routerlogin.net on the address bar.Enter the required user name and password when prompted. If you have not previously set up a unique user name and password for the router, enter "admin" in the user name field and "password" in the password field. Click on the "OK" button to enter the router settings menu.
To Turn on UPnP - Select UPnP under Advanced of the main menu. The UPnP screen displays. Tick the box that says "Turn UPnP On"

11_20_2011_7_10_04_am.png
Hope this helps.

Nov 20, 2011 | NetGear WNR2000 Wireless Router

1 Answer

I need to open port for xbox live


Starting the SBG900 Setup Program

1. On a computer wired to the SBG900 over Ethernet or USB, open a Web browser. Do not attempt to configure
the SBG900 over a wireless connection.

2. In the Address or Location field, type http://192.168.100.1 or http://192.168.0.1 and press ENTER to display
the Log In window:brymz.jpg

3. In the User ID field, type the User Name; the default is "admin" (this field is case sensitive).
4. In the Password field, type the Password; the default is "motorola" (this field is case sensitive).
5. Click Log In to display the SBG900 user configuration and status windows:
brymz_0.jpg

6. Then click on "Gateway" located at the left corner.
7. Then click on "Port Triggers".
8. Then choose "custom"

brymz_1.jpg

And from there:

ADD NEW SPECIAL
APPLICATION

Name Enter the unique name for the port trigger. This is typically the protocol.
Enable Select this box to enable the custom port trigger.
Protocol Sets the transport protocol for the port trigger - TCP or UDP.
Port Range Sets the port range for the port trigger. Type the start of the range in the
(From:To) left field and the end in the right field.

Session Chaining Enable session chaining if the application needs to open one or more ports in
different ranges to operate properly. The options are Disable, TCP, TCP/UDP.

Session Interval Sets the session interval for the application:
• If the port triggers detect traffic on the Port Range within the Session
Interval, it is considered to be related to the initial session.

• If the port triggers detect traffic on the Port Range after the Session Interval
expires, it is considered to be a new and unique session.

Address Replace Sets the address replacement method for the application.
Multi Host Select if appropriate for the application.
Add Click to add the port trigger to the PORT TRIGGERS TABLE.
PORT TRIGGERS TABLE Lists all port triggers you defined and their parameters.

Hope it help you....

Sep 13, 2011 | Arris SURFboard SBG900 Wireless Router...

1 Answer

Forgotten password


You should change your Yahoo! Messenger password for security purposes. Pick a password that only you can remember, but one that's unique so that no one else figures it out.

Instructions

1.Click on the Yahoo! Messenger icon found on your computer desktop, or enter the program from the Yahoo! home page. Log in to Yahoo! Messenger with your user ID and current password. Click the "Yahoo! Messenger" link when the Yahoo! Messenger window opens.

2.Go to "My Account Info." This will take you to the Yahoo! Messenger account information page.

3.Find the link that reads "Change Password." Type your old password into the first field, then type a different password into the new password field.

4.Enter your new Yahoo! Messenger password into the next form field to confirm it. Save the new password into your Yahoo! Messenger account.

5.Log out of Yahoo! Messenger, then log in again. Test your account by entering your user ID and new password.

Sep 06, 2011 | Yahoo Messenger

1 Answer

I forgot my password


Go to www.facebook.com
type your user name in the user name field and then click the forgot password link under the password field. Password would be mailed to your mail id registered with face book.

Jun 01, 2011 | Facebook Social Network

1 Answer

What is the syntax for search in mysql database?


1.select * from tab;
will display all tables in database

2.if u know tablename then
select * from tablename;
It will display all data in the table

3.if u want specific information
eg : TableName:Students
Contains Fields: id , name.
select name from Students where id=1;

it will display name of student id=1

contact me for more information bhushan.softwaredeveloper@gmail.com

Rate It
Have a nice day

Mar 03, 2011 | Computers & Internet

1 Answer

How do i get my gprs working


AT&T:
Main Menu
* Entertainment
* Services
* Data Account
* GPRS
- Find one free account (like Account 8, etc)
* Edit
- Change 'Account Name' and put the value 'ATT MMS'
- In 'apn' field put the value APN (which is wap.cingular)
- Fill the fields username and password with the ones on the table USER and PASSWORD (you don't actually need a user name and password for AT&T, you can leave these blank)
-Click 'Done' and say Yes to Save.

* Main Menu
* PIM
* Messages
* MMS
* Message Settings
* Server Profile
- Find one free account (like Profile 8, etc)
* Edit Profile
- Rename Profile and put the value 'ATT MMS'
- In Homepage field put the value HOMEPAGE (which is http://mmsc.cingular.com)
- In 'Data Account' select GPRS and then the account created before (the MMS one).
- Select 'Connection Type', choose HTTP and click OK
- Fill in the fields Proxy Address with PROXY and Proxy Port with PORT. Then click OK (066.209.011.061 is the proxy and 9201 is the port number)
- Fill the fields username and password with the ones on the table USER and PASSWORD (don't need a user name and password)
* Go back and Activate Profile

Nov 16, 2009 | AT&T CECT Unlocked i68+ Quadband GSM FM...

1 Answer

How to print only selected fields in ms access.


open your table in query, follow steps to do this...

1. open new query in access
2. locate the table
3. once table selected, select field name in selected table you only want to include in query
3. once finished selecting the field save the query
4. you can now view selected field in your table and print as well
5. you can edit the query anytime if you want to add or remove field
6. query will not affect your table since this is only query.

hope this will help you....

Oct 22, 2008 | Microsoft Access 2002 for PC

4 Answers

MySQL Error Messeage


When you install MySQL for the first time, no password is set for root user.
Move to the installation directory of mysql (cd/usr/local/mysql) Set the password for user, using the following command -
./bin/mysqladmin -u <username> password

Enter your password. Then you can connect to the mysql client as
./bin/mysql -u <username> -p <password>

Jul 27, 2008 | Sun MySQL

Not finding what you are looking for?
Sun MySQL Logo

Related Topics:

1,965 people viewed this question

Ask a Question

Usually answered in minutes!

Top Sun Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Cosma Papouis
Cosma Papouis

Level 3 Expert

409 Answers

Are you a Sun Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...