Code: Select all
mysql -u You -p database
Code: Select all
LOAD DATA INFILE 'data.csv' INTO TABLE table
http://dev.mysql.com/doc/refman/5.0/en/load-data.html
Code: Select all
mysql -u You -p database
Code: Select all
LOAD DATA INFILE 'data.csv' INTO TABLE table
Code: Select all
awk '{ print $2 }' list.txt
Code: Select all
awk -F ";" '{ print $2 }' list.txt
Code: Select all
$yesterday=date('Y-m-d', mktime(0, 0, 0, date("m") , date("d") - 1, date("Y")));
Code: Select all
$yesterday=date("Y-m-d", time()-86400);
Code: Select all
/etc/init.d/svscan status
Code: Select all
/etc/init.d/svscan start
Code: Select all
svc -u /service/bincimap/
Code: Select all
$float = 55.3333333333;
$new_num = number_format($float, 2);
echo $new_num; //55.33