Insert Multiple Row using SQL – NEW

INSERT INTO TableName (FieldName1,FieldName2,FieldName3)
SELECT '235', 'Black', 'black.jpg'
UNION ALL
SELECT '457', 'Charcoal', 'charcoal.jpg' 
UNION ALL
SELECT '235', 'Khaki', 'khaki.jpg' 
UNION ALL
SELECT '689', 'Navy', 'navy.jpg' 
UNION ALL
SELECT '568', 'OD Green', 'odgreen.jpg';

Select record has highest “Date”(any field)

You can select record corresponding to its highest value in any field

SELECT * FROM tableName where fieldName = (SELECT MAX( fieldName ) FROM tableName)

Here,

SELECT MAX( fieldName ) FROM tableName

Get the Highest in fieldName. It can be number or date(In this “2014-02-30 12:20:12” format).

MAX( fieldName ), does the Magic….;)

Export data in DB as CSV file (Store in system / Send it to Mail)

Export data in DB as CSV file (Store in system / Send it to Mail)


function query_to_csv($db_conn, $query, $filename, $attachment = false, $headers = true) {

if($attachment) {
// send response headers to the browser
header( 'Content-Type: text/csv' );
header( 'Content-Disposition: attachment;filename='.$filename);
$fp = fopen('php://output', 'w');
} else {
$fp = fopen($filename, 'w');
}

$result = mysql_query($query, $db_conn) or die( mysql_error( $db_conn ) );

if($headers) {
// output header row (if at least one row exists)
$row = mysql_fetch_assoc($result);
if($row) {
fputcsv($fp, array_keys($row));
// reset pointer back to beginning
mysql_data_seek($result, 0);
}
}

while($row = mysql_fetch_assoc($result)) {
fputcsv($fp, $row);
}

fclose($fp);
}

// Using the function
$sql = "SELECT * FROM table";
// $db_conn should be a valid db handle

// output as an attachment
query_to_csv($db_conn, $sql, "test.csv", true);

// output to file system
query_to_csv($db_conn, $sql, "test.csv", false);