Online computer courses, code, programming tutorial and sidebar information for monitoring Canadian S&P/TSX index. Build friendship and networking. Welcome to visit my blogs often!!! I also have two other sites: YouTube Channel and Google site.
Adsense
Popular Posts
- PHPWind-- A PHP forum script applcaition in China
- Using Cron Job to process PHP scripts
- Install PHPMailer 5.2.4 and use smtp gmail
- Datatable export excel wraptext and newline
- PHP connect IBM db2 database in XAMPP
- Sweet Alert JS library - beautiful replacement of JavaScript Alert
- PHP - Export Content to MS Word document
- Using JS Chosen library for multiselect dropdown
- phpexcel toggle expand and hide column in EXCEL and summary
- PHP: add a download as pdf file button in report page
Saturday, April 6, 2013
Copy table in MySQL, change table name in MySQL
To copy a table in MySQL, for example copy table users to new_users.
First we create an empty table new_users with the same structure as users
create table new_users like users;
Then we insert new_users withe same content from users
INSERT new_users SELECT * FROM users;
To change table name in MySQL, for example new_users to new_users1
RENAME TABLE new_users TO new_users1;
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment