Currently viewing the tag: "select"

Oracle SQL Video Tutorial 1: SELECT Statement

Oracle SQL Video Tutorial: SELECT Statement . In This video we explained how to use select statement. “oracle as” “what is oracle” “sql and pl sql” “pl sql pl sql” “pl sql &” “& pl sql” “pl sql and” “pl sql and sql” “oracle to sql” “to sql oracle” “sql to oracle” “oracle 10g” “oracle 11g”…

Tagged with: • • • •
 

How to I select a database from the MySQL command prompt?

Question: How to I select a database from the MySQL command prompt?
I am trying to test some code in the MySQL command prompt. It keeps giving me an error saying that I am not connected to the database. How can I connect to the database in the command prompt? Can’t figure it out. Thanks.

Answer:

Answer by Mako
mysql -h hostname -u username -p

Replace hostname and username with the database address and your username. It will then ask you for your password.

Tagged with: • • • • •
 

How to select a row from MySQL data base?

Question: How to select a row from MySQL data base?
I have a MySQL database with the first column containing id numbers. How would I “SELECT” the row containing id 58 for example?

Answer:

Answer by jtaber79
Select * from tablename where id=’58′

Replace tablename with the actual table containing the data you want to access.

Tagged with: • • • •