English Grammar and
Examples
Idioms
Jargon
Body language
MYSQL
Show Function Status
Show Index
Show Master Status
Show Privileges
Show Procedure Code
Show Procedure Status
Show Privileges
Show Profile
Show Profiles
Show Slave Status
Show Status
Show Triggers
Show Variables
Show Function Code
Call
Drop Function
Insert
Install Plugin
Load data infile
Replace
Set
Show Authors
Show Innodb Status
Show Open Tables
Show Plugins
Show Scheduler Status
Show Slave Hosts
Show Table Status
Show Tables
Show Warnings
Uninstall Plugin
Update
Show Create View
Show Databases
Show Engine

Full list of MYSQL
   Business Letters   Personal Letters   Resumes   CVs and more
       Facebook Example of rename table syntax mysql LINKED IN Example of rename table syntax mysql del-icio-us Example of rename table syntax mysql

Example Of RENAME TABLE Mysql Syntax:




DENAME TABLE tbl_name TO new_tbl_name
[, tbl_name2 TO new_tbl_name2] ...

CREATE TABLE new_table (...);
RENAME TABLE old_table TO backup_table, new_table TO old_table;

RENAME TABLE old_table TO tmp_table,
new_table TO old_table,
tmp_table TO new_table;

RENAME TABLE current_db.tbl_name TO other_db.tbl_name;



         


Link to this page:
* Required Fields
 Add Comment:
Name* :
Email :
Comment* :
 
Contact Us About Us Privacy Policy Disclaimer
Copyright © 2008 - 2010 ExamplesOf .com