Hello Everyone
Iam Exporting All My Data From Mysql To Txt File With This Code
<?php
$sql2 = mysql_query("SELECT * FROM export
INTO OUTFILE '/Zero.txt'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'");
?>
I Need To Edit The Code So It Export The New Data I Insert In MySql Only (( Not All Data Again ))
diafol Helped Me With This Code
Have another field in export:
int(5?) called txtfile, default 0
When you're ready to create a new textfile:
$r = mysql_query("SELECT MAX('txtfile') + 1 AS nextval FROM export");
$d = mysql_fetch_assoc($r);
$nextval = $d['nextval'];
$r = mysql_query("SELECT * FROM export WHERE txtfile = 0
INTO OUTFILE '/Zero_$nextval.txt'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'");
$r = mysql_query("UPDATE export SET txtfile = $nextval WHERE txtfile = 0");
It Works Ok
I Need To Make The Same Idea But Without Creating Tables In The Database