Re: updating tables in MySQL

2004-02-25 Thread Sasha Pachev
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 cu

Re: updating tables in MySQL

2004-02-25 Thread vpendleton
Are you using the DTS to schedule replication or periodic data imports? >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/25/04, 11:48:02 AM, "HACKATHORN," TODD "(

updating tables in MySQL

2004-02-25 Thread HACKATHORN, TODD (SWBT)
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

Re: updating tables

2003-01-24 Thread Stefan Hinz, iConnect \(Berlin\)
Tivano" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 24, 2003 10:50 AM Subject: Re: updating tables > Stefan, > > The problem look be solved; > > i've just changed structure of the updatable table. > First this table have only 1 primary k

Re: updating tables

2003-01-24 Thread Fabrizio Tivano
Hinz <[EMAIL PROTECTED]> > Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> > Heesestr. 6, 12169 Berlin (Germany) > Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 > > - Original Message - > From: "Fabrizio Tivano" <[EMAIL

Re: updating tables

2003-01-23 Thread Stefan Hinz, iConnect \(Berlin\)
ent: Thursday, January 23, 2003 5:22 PM Subject: updating tables > > hello dear all, > > i have a problem updating tables: > > in my queries i try to use REPLACE but is same like INSERT command. > > ...i need only to refresh table_1 wit

updating tables

2003-01-23 Thread Fabrizio Tivano
hello dear all, i have a problem updating tables: in my queries i try to use REPLACE but is same like INSERT command. ...i need only to refresh table_1 with new entries from table_2. any ideas? TIA fabrizio - Before

Re: Not updating tables with data but no errors either

2002-01-17 Thread nod
On Thursday 17 Jan 2002 4:52 pm, fla wire wrote: > Hello, > I have a freebsd machine running mysql and php. Yes I am one of those > newbies. > I have read the FU*K manual. I have a sams learn in 21 day book. also a php > essentials and build your own database drive book. I have a brazilian rain >

RE: Not updating tables with data but no errors either

2002-01-17 Thread Carsten H. Pedersen
> We have a php page that we put in people that belong to a football pool. > However it is not adding the data to the table. We do not get any error > messages either even tho the php page is setup to display the errors. > I find no errors in the http-errrors.log. the httpd-access.log shows the >

Not updating tables with data but no errors either

2002-01-17 Thread fla wire
Hello, I have a freebsd machine running mysql and php. Yes I am one of those newbies. I have read the FU*K manual. I have a sams learn in 21 day book. also a php essentials and build your own database drive book. I have a brazilian rain forest of manuals,printouts etc. We have a php page that we

Re: Updating tables via cron

2002-01-04 Thread zb
Hi! On Thu, 3 Jan 2002, Webmaster wrote: > I tried to search the archives for this but I can't find it. (Not saying > it isn't there just I could not find it.) I have a table that tracks > events on a monthly and daily basis. Currently I am resetting the > appropriate fields to 0 on

Re: Updating tables via cron

2002-01-04 Thread DL Neil
David, Was this question addressed? > I tried to search the archives for this but I can't find it. (Not saying > it isn't there just I could not find it.) I have a table that tracks > events on a monthly and daily basis. Currently I am resetting the > appropriate fields to 0 on a daily and mon

RE: Updating tables via cron

2002-01-03 Thread Gary . Every
] Sent: Thursday, January 03, 2002 10:57 AM To: [EMAIL PROTECTED] Subject: Updating tables via cron I tried to search the archives for this but I can't find it. (Not saying it isn't there just I could not find it.) I have a table that tracks events on a monthly and daily basis.

RE: Updating tables via cron

2002-01-03 Thread Land, Christopher
Here is a select statement, as example: mysql -e "select * from user \G" mysql Add user and password as required. Xi2 ('sE-'tü) -Original Message- From: Webmaster [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 8:57 AM To: [EMAIL PROTECTE

Updating tables via cron

2002-01-03 Thread Webmaster
I tried to search the archives for this but I can't find it. (Not saying it isn't there just I could not find it.) I have a table that tracks events on a monthly and daily basis. Currently I am resetting the appropriate fields to 0 on a daily and monthly basis (not fun). Is there a

Re: Re[2]: updating tables

2001-07-02 Thread Radius Newbies
Hi Werner, -- On Mon, 2 Jul 2001 15:59:19Werner Stuerenburg wrote: >Hi noelt, > > >> i mean, the value of the duration field will be transferred or >> copied to the consumed field w/c is in a diff. table. > >So these are just some fields like column1 and column2 - nothing >to do with

Re[2]: updating tables

2001-07-02 Thread Werner Stuerenburg
Hi noelt, > i mean, the value of the duration field will be transferred or > copied to the consumed field w/c is in a diff. table. So these are just some fields like column1 and column2 - nothing to do with duration of the process itself. The following is in php and uses class db_mysql - there

updating tables

2001-07-01 Thread Radius Newbies
Hello All! I am just starting to learn mysql so forgive if i sound so beginner here. I have 2 tables, table1 and table2. At table1, i have username and consumed field_names. at table2, i have username and duration fieldname. I need to put the value of duration to consumed. How will I do that?