At 6:53 PM -0700 7/14/07, Steffan A. Cline wrote:
I was trying to reduce a set of queries and ran into this:
insert into forums (forum_reply_id, forum_dev_id, forum_subject,
forum_message) values (0, 1, (select forum_subject from forums where
forum_id=3 ), "I figured this one needed a reply too
Mogens ,
forum_id is a primary auto increment key therefore it's unlikely that there
would be a dupe. I can see there being an error if there is a dupe but in
this case there is not.
Is it really necessary to do this:
set @x = (select forum_subject from forums where forum_id=3 );
insert into f
On Sun, July 15, 2007 03:53, Steffan A. Cline wrote:
> I was trying to reduce a set of queries and ran into this:
>
>
> insert into forums (forum_reply_id, forum_dev_id, forum_subject,
> forum_message) values (0, 1, (select forum_subject from forums where
> forum_id=3 ), "I figured this one needed
I was trying to reduce a set of queries and ran into this:
insert into forums (forum_reply_id, forum_dev_id, forum_subject,
forum_message) values (0, 1, (select forum_subject from forums where
forum_id=3 ), "I figured this one needed a reply too.")
yields:
error: You can't specify target table
Hi,
First up, the sites were working fine until the old server went buggy. I hadn't
worked on either of the shopping carts, so they should have been fine when I
transfered them over. No, I'm confident there is nothing wrong with my code,
etc. I suspect it has something to do with copying over
First up, the sites were working fine until the old server went buggy. I hadn't
worked on either of the shopping carts, so they should have been fine when I
transfered them over. No, I'm confident there is nothing wrong with my code,
etc. I suspect it has something to do with copying over the da
Hi,
Pat Singer wrote:
Hi;
I just built out a new server and transfered my databases. I use Zope to
server my web sites and ZMySQLDA to interface between the two. Everything seems
to be fine. I can see the databases, the tables, the columns in the tables, the
permissions are correct, etc. I
Hi;
I just built out a new server and transfered my databases. I use Zope to
server my web sites and ZMySQLDA to interface between the two. Everything seems
to be fine. I can see the databases, the tables, the columns in the tables, the
permissions are correct, etc. I hook up ZMySQLDA and that
At 01:38 AM 7/14/2007, Olav Mørkrid wrote:
hi, i have some questions about the command line of mysql for WIN32:
- does mysql have any macro system that lets you shorten often-used
commands, like expanding "n5 mytable" into "select * from mytable
order by id desc limit 5"
- how can tab completio
As fat as your first and last question go you can create views.
create view somename as select c1,c2,c2 from table (limit 5);
and then
select from somename;
i am not familiar with the windows client but i would expect auto completion
there too
olaf
-Original Message-
From: Olav Mørkr
hi, i have some questions about the command line of mysql for WIN32:
- does mysql have any macro system that lets you shorten often-used
commands, like expanding "n5 mytable" into "select * from mytable
order by id desc limit 5"
- how can tab completion be enabled (it does not work by default, e
11 matches
Mail list logo
