creat table

[Dan Liu]

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

 

Union does not work

[Dan Liu]

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.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Union does not work

[Dan Liu]

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

Thanks!
Dan


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

left join

[Dan Liu]

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 to make it faster?

Dan 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

PHP memory problem

[Dan Liu]

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.  Does anyone know anything about why this behavior may 
be occuring and any solutions we could try?  Is this a PHP problem or a MySQL problem? 
 Using pconnect versus connect does not appear to be the problem.

Dan


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Hi all,

[Dan Liu]

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


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php