×

Welcome to TagMyCode

Please login or create account to add a snippet.
1
0
 
0
Language: SQL
Posted by: bejoy balan
Added: Sep 18, 2014 5:50 AM
Views: 20
Copy a mysql table with data
  1. SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
  2.  
  3. DROP TABLE IF EXISTS `copy_adjholiday`;
  4. CREATE TABLE `copy_adjholiday` LIKE `adjholiday`;
  5. INSERT INTO `copy_adjholiday` SELECT * FROM `adjholiday`;