Hi,
I have a question about 'create table'.
If two persons create table both name 'table1' at the same time in same
database, what would happen?
Thanks in advance.
Dan
Hi,
Could somebody tell me what is wrong with this query?
select location from visiExPr where location=1 union (select location from
demandInfoAd where location=0);
ERROR 1064: You have an error in your SQL syntax near 'union (select location from
demandInfoAd where location=0)' at line 1
Than
Hi,
Could anybody tell me why the following query does not work?
SELECT location FROM visiExPr where location=1 union (SELECT location FROM visiExPr
where location=0);
Thanks!
Dan
-
Before posting, please check:
http://www
Hi everyone,
I ran a query which is:
select A.a as a,B.b as b from A left join B on A.c=B.c and A.d=B.d order by A.c,A.d;
Both table A and Table B have about 3000 records.And there are about 3000 records in
the result.But it takes 3 minutes and 50 seconds to run the query.
Does anybody know how t
Hi everyone,
when we execute queries through MySQL using PHP, a significant amount of memory is
being used in the process. We have noticed that the memory is not being released
again for several hours. Despite attempts to force it to release memory in the code,
the problem is still occuring.
Hi all,
I am running a query on mysql.The query is simple.It retrieves 2800 rows and 250
columns data.I created index for the query.But it still takes over a minute.
Could somebody tell me what should I do?And why it is so slow?
Thanks!
Dan
--
