Re: updating tables in MySQL
HACKATHORN, TODD (SWBT) wrote: Hello, Sorry if this is a obvious question, but I am new to mySQL, and PHP. I am used to working with MS SQL Server 2000 and coldfusion. In SQL server I can build DTS packages and schedule them to update the data in my tables with different queries, and to import current data from other databases. Is there a way I can do this in mySQL? I found how I can schedule scripts, but am not sure how to go about making a script do queries, or how to import data from a other data source. I could write a script to insert each record one at a time, but that seems like a lot of work. I work with fairly large tables. I am new to both Linux, and mySQL, but do have a decent amount of experience in other SQL system. I am using RedHat 9, mySQL Ver 12.22 Distrib 4.0.18, for pc-linux (i686). Todd: MySQL does not have this ability. You can, however, accomplish this with command-line shell/Perl/PHP scripts run from cron (type "man cron" and "man crontab" to learn more, if you are not familiar with it). -- Sasha Pachev Create online surveys at http://www.surveyz.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: updating tables in MySQL
Are you using the DTS to schedule replication or periodic data imports? >> Original Message << On 2/25/04, 11:48:02 AM, "HACKATHORN," TODD "(SWBT)" <[EMAIL PROTECTED]> wrote regarding updating tables in MySQL: > Hello, > Sorry if this is a obvious question, but I am new to mySQL, and PHP. I > am > used to working with MS SQL Server 2000 and coldfusion. In SQL server I > can > build DTS packages and schedule them to update the data in my tables > with > different queries, and to import current data from other databases. Is > there a way I can do this in mySQL? I found how I can schedule scripts, > but > am not sure how to go about making a script do queries, or how to import > data from a other data source. I could write a script to insert each > record > one at a time, but that seems like a lot of work. I work with fairly > large > tables. I am new to both Linux, and mySQL, but do have a decent amount > of > experience in other SQL system. > I am using RedHat 9, mySQL Ver 12.22 Distrib 4.0.18, for pc-linux > (i686). > Thanks in advance, > Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]