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:
:[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
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
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 =
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