Calculation in a mysql column

2004-04-01 Thread Mike R
I am using mysql 4.0.16. Is it possible to put a calculation of two other columns as the default value for a third column? Like: time = decimal 3,2 rate = decimal 3,2 totals = default is time * rate Thanks, -Mike -- MySQL General Mailing List For list archives:

RE: Going from 3.23 to 4 - sql statement errors

2004-03-19 Thread Mike R
:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 8:21 AM To: [EMAIL PROTECTED] Subject: Re: Going from 3.23 to 4 - sql statement errors Mike R [EMAIL PROTECTED] wrote: Sorry if I posted this twice - I had some email issues yesterday, and I didn't know if this made it to the list: I am

Going from 3.23 to 4 - sql statement errors

2004-03-18 Thread Mike R
Sorry if I posted this twice - I had some email issues yesterday, and I didn't know if this made it to the list: I am using php with mysql, and after moving my tables to a new server, I am suddenly getting this error: Query failed: You have an error in your SQL syntax. Check the manual that

Going from 3.23 to 4 - sql statement errors

2004-03-17 Thread Mike R
I am using php with mysql, and after moving my tables to a new server, I am suddenly getting this error: Query failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'this = 'No', fp_ext = 'No', username =

RE: Ideas on creating connections

2003-09-25 Thread Mike R. Duncan
try adding a '\' before the comma like a \n in c++ -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 10:41 AM To: Roger Davis; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Ideas on creating connections Thank you for