I'm trying to use a INSERT INTO table1 (column1,
column2, column3) SELECT 'value', 'value2',
table2.value3 FROM table2 WHERE table2.value4='name';
This query fails from C, but if I copy and paste it
exactly to the mysql client, it works.
If I run mysql_info(), it tells me:
Records: 0 Duplicates
This should do what you want:
UPDATE Table2, Table1 SET
Table2.DataDestination=Table1.DataSource WHERE
Table1.col1=Table2.col1 AND Table1.col2=Table2.col2
AND Table1.col3=Table2.col3;
--- PandaCoop-Krasimir_Slaveykov <[EMAIL PROTECTED]>
wrote: > Hello mysql,
> I have 2 tables :
>
> Table1:
TED]> wrote: > On Tuesday
04 March 2003 16:51, Jamie Jennings
> wrote:
>
> > Hi. I've got two mediumint columns in a mysql
> table,
> > and I'm trying to subtract them like this:
> >
> > SELECT column1-column2 FROM table WHERE
> > name='john
Hi. I've got two mediumint columns in a mysql table,
and I'm trying to subtract them like this:
SELECT column1-column2 FROM table WHERE
name='johndoe';
This works some of the time, however, I get weird
results for negative numbers. For example, when
column1=0 and column2=4995, I get:
18446744073
