f you need to have more control over what is copied, you can add a
WHERE clause in the SELECT above. Also, you can restrict how it is done by
adding some fields restrictions:
INSERT INTO table1 (field1, field2)
SELECT field1, field FROM table2
WHERE field1 =
t you know... I'm not the only one
inserting values into the table. :-)
Cheers,
Jose Miguel.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
t; FROM sites_criterios
-> );
Empty set (0.01 sec)
Note that this query is THE SAME as the previous one, but with a wider
result set inside the subquery. This makes no difference in my queries as we
confirmed at least the word "su-turno" does not exists.
Thanks for your patience. If you think I'm doing something wrong please
reply.
Cheers,
Jose Miguel.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
- www.domain.com?id=2 (There is no /)
Beware though, this usage will not use indexes on "url" column so be
careful and do not use this on big tables. You will need to use more
elaborated techniques to speed up query times on big tables.
Cheers,
Jose Miguel
Hi Andy!
> After compiling with the options (as suggested by Jose Miguel Pérez)
[...]
> I now get ...
> Everything Cool with the connection
> Bus Error (core dumped)
>
> Sound familiar!!
Sorry Andy but I couldn't help any more. I am not familiar with Solari
z
It worked fine, maybe you should try to compile with debug options and
give gdb a try.
Cheers,
Jose Miguel.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
o be some "%" inside "whatever" you will get coredumps.
For instance, see what happends when in your program,
mysql_error(connection) returns "Please use %d to display integers." (Not a
real MySQL error, obviously!! :-)
Cheers,
Jose Miguel.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
functions (which I
suppose I can include them even as UDF functions).
Please, anyone could give me advice on that?
Cheers,
Jose Miguel.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
assigned tasks. If you want
to
> further select which one of the projects with the most assigned tasks you
> want, you must order by another column, like date (or filter out the
> projects in the WHERE clause).
>
> Given said that,
>
> Cheers,
> Jo
must order by another column, like date (or filter out the
projects in the WHERE clause).
Given said that,
Cheers,
Jose Miguel.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
olution. ;-)
>
> That would have to do the same thing behind the scenes.
I have to beg you pardon here. ;-) Think again this solution doesn't
require a JOIN, nor a temporary table. I think the UDF solution doesn't have
to be less efficient than a MAX or AVG aggregate fun
led something
like EXTERNAL_MAX(...) or something, so that we could do like:
SELECT EXTERNAL_MAX(date, version) ---> i.e: Returns the "version"
value for the row with MAX(date).
This, for sure, will be the best solution. ;-)
Cheers,
Jose Miguel.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the join are unique. The result set returned with the
last example is this:
++--+-+
| date | location | version |
++--+-+
| 2004-09-16 | PARIS| 10 |
| 2004-09-16 | NEW-YORK | 10 |
| 2004-09-15 | TOKYO| 11 |
++--
ing.
Cheers,
Jose Miguel.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
't showing
them in the list. A nasty GUI bug, sure, but this renders SQLyog unuseable
to me.
Cheers,
Jose Miguel.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
involved creating such a tool, I'm a programmer after
all, and some of them are in beta anyway. I would appreciate if anyone knows
some tool which good foreign key support.
Cheers,
Jose Miguel.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e that I use MySQL 4.0.12, so I cannot use the DELETE ...
USING ... syntax which were added in 4.0.2
Cheers,
Jose Miguel.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
index |
+-+---+---+-+-+--+--
-+--+
System: MySQL server 4.0.13 on a Red Hat 7.2 box.
Cheers,
Jose Miguel.
- Original Message -
From: "Willem Bison" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]&
you don't have more indexes than really needed. You can
test with a temporal table without any keys (not even primary) and adding
indexes until you get the behaviour described so that you can locate which
is the problem.
Cheers,
Jose Miguel.
--
MySQL General Mailing List
For
en "(sales2.amt -
sales1.amt) == NULL" which is, obviously, erroneous for your pourposes of
getting an increment of 1000 in the sales.
I hope this helped!
Cheers,
Jose Miguel.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
wice, except for the JOIN
clauses, of course.
For example, you cant type "... WHERE blah, blah WHERE blah, blah too"
nor repeat a GROUP BY, SORT, etc.
May I suggest you to read the manual more carefully? ;-)
Cheers,
Jose Miguel.
--
MySQL General Mailing Li
3.41 version. However, I have read all the changelogs up to
4.0 and it doesn't say anything the developers have changed something to the
low level connection layer or something.
Cheers,
Jose Miguel.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
T
s
seen above. I have not come to a conclusion on this topic, so all you can
help is greatly appreciated.
I go so far as to capture the packets with a packet sniffer (ethereal),
and I got crazy: Everything seems fine, all connections generate the same
packets, in the same order... But when conne
23 matches
Mail list logo
