Tạo 1 table từ  1 table khác: Create Table new_table Select * From old_table

Export MySQL data records to an Excel file in one PHP file, simple and easily! This tutorial require 1 PHP file and 1 table of mySQL database. export_excel.php Database “tutorial” and table “name_list” with 2 fields: id(auto_increment), name(varchar, 50) and put some records about 20 – 30 records into this table. (directly by phpMyAdmin Source Code <? // Connect database. mysql_connect(“localhost”,””,””); mysql_select_db(“tutorial”); // Get data records from table. $result=mysql_query(“select * from name_list order by id [...]

++++++++++++++ + Website_cv ++++++++++++++ + cv_id + status ++++++++++++++ +++++++++++++++ + Website_apply_job +++++++++++++++ + cv_id + status +++++++++++++++ => copy Status From website_cv to website_apply_job UPDATE website_apply_job JOIN website_cv ON website_cv.cv_id = website_apply_job.cv_id SET website_apply_job.STATUS = website_cv.STATUS;