nixCraft

raj · #1 (**permalink**) 12-19-2006, 01:08 AM

Dear All,

I am new to MySQL and SQL coding. Just wondering how do I display some (selected) or all of the columns from a table. All I wanted to do is to force mysql select column. But I don't know linux mysql client commend.

Regards

nixcraft · #2 (**permalink**) 12-19-2006, 01:15 AM

MySQL SQL SELECT command is used to retrieve rows selected from one or more tables. It allows you to select mysql table columns.

Login to MySQL

Code:

mysql -u user -p databasename

If your table name is books, to select all columns type command:

Code:

SELECT * FROM books;

Using * is easy, you an specify the column name with following command (let us say column name is author and email):

Code:

SELECT autor, email FROM books;

For more information please see SELECT command syntax
http://dev.mysql.com/doc/refman/5.0/en/select.html

raj · #3 (**permalink**) 12-19-2006, 01:23 AM

Thanks for quick reply and yup, SELECT autor, email FROM books; did the trick for me.

This is what I am using:

Code:

SELECT puser, email FROM mailinglist;

I am looking at syntax mysql site.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create output in columns	rakeshrhn	Shell scripting	5	12-07-2007 06:27 PM
Select specific rows	c341	Shell scripting	6	01-18-2007 02:04 AM
help me in editing this columns	sureshbup	Shell scripting	1	12-12-2006 02:29 PM
rearranging columns in a text file	sureshbup	Shell scripting	2	12-06-2006 09:43 AM
Calculations across different lines & columns of a file	Guest	Shell scripting	2	09-16-2005 04:18 AM

nixCraft

Mysql how to specify select columns

Mysql how to specify select columns

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

Similar Threads