89b9 Mysql auto-update table - The FreeBSD Forums
The FreeBSD Forums  

Go Back   The FreeBSD Forums > Server & Networking > Web & Network Services
Reload this Page Mysql auto-update table
Register FAQ Calendar Search Today's Posts Mark Forums Read

Web & Network Services Discussion related to network/web services such as apache, bind, sendmail, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old July 21st, 2012, 16:16
junior junior is offline
Junior Member
  
Join Date: Jan 2011
Posts: 9
Thanks: 2
Thanked 0 Times in 0 Posts
Default Mysql auto-update table
Hello, I want to transfer information from table to another with separate databases, automatically. Is any chance to get this done?
Reply With Quote
  #2  
Old July 28th, 2012, 22:01
zhoopin zhoopin is offline
Junior Member
  
Join Date: Nov 2011
Posts: 60
Thanks: 5
Thanked 14 Times in 14 Posts
Default
I think that it's better to visit MySQL's communities. Anyway...

Code:
CREATE TABLE table_copy LIKE table_original;
INSERT INTO table_copy SELECT * FROM table_original;
__________________
Zhoopin (ʒuːpiːn) - Meri - Mehrshad Moslehi
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySql Error 1036 Table is Read Only alexy Web & Network Services 4 February 15th, 2011 09:52
[Solved] Generating from COMPRESSED table with mysql 5.1 not possible. parcival Installation and Maintenance of FreeBSD Ports or Packages 8 October 28th, 2010 11:34
what are the static table and the dynamic table in ffs？ coopci General 0 October 26th, 2009 03:39
FreeNAS mysql problem - mysql.sock not found kalns Web & Network Services 10 September 25th, 2009 17:46
Update MySQL 5.0 puzor Installation and Maintenance of FreeBSD Ports or Packages 8 July 14th, 2009 14:22


All times are GMT +1. The time now is 07:43.

Contact Us - FreeBSD - Archive - Top

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2013, vBulletin Solutions, Inc.
The mark FreeBSD is a registered trademark of The FreeBSD Foundation and is used by The FreeBSD Project with the permission of The FreeBSD Foundation.
Web protection and acceleration provided by CloudFlare
0