Select Data from MySQL | Learn MySQL Online
×

Select Data from MySQL

3496

Select Data from MySQL
'SELECT' statement is used to select the data from the table. If you want to select all the data from the table, then the

Syntax :
SELECT * FROM table_name;
And, if you want to select particular FIELD from the table, then the SYNTAX will be :

SELECT name FROM student;
After selecting a particular field like 'name' from the table like 'student', only that field will be selected.

Example :
<?php
$sql="SELECT * FROM table_name";

// Now all data fetch from table, * is use for fetch all data from database

$result= mysql_query($sql);
$row= mysql_fetch_array($result);

echo $row;
?>



Best WordPress Hosting


Share:


Discount Coupons

Get a .COM for just $6.98

Secure Domain for a Mini Price



Leave a Reply


Comments
    Waiting for your comments