Re: [PHP-DB] Help. Mysql Query optimisation not very clever?
Hello Ross, why don't use: explain select . and you'll see what mysql is thinking... ;) -- Best regards, Pablo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Help. Mysql Query optimisation not very clever?
On Saturday 17 July 2004 09:31, Ross Honniball wrote: Attention all Sql gurus, Is there a way to FORCE mysql resolve specific conditions within a query before wasting it's time trying to resolve other conditions? www.mysql.com -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* All I can think of is a platter of organic PRUNE CRISPS being trampled by an army of swarthy, Italian LOUNGE SINGERS ... */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] HELP: mySQL table name
From: Adrian Donoiu [EMAIL PROTECTED] I need information about how can I get the table name from this query : select * from test_table as t when I use : $field=mysql_fetch_field($result, $i); $field-table return the name of the table as t but I need the real name of the table test_table. How can I do it? You can't. If you alias the table as t, then that's the table name. Either don't use an alias or write a function that'll parse the query to retrieve the table name. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Help MySQL server has gone away
I do not think php is the problem here. Take a look here http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.html#Gone _away There are some good pointers on what to do... Regards Joakim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] HELP! (mysql)
if you have phpMyAdmin then just use that (if you don't then you *really* should :) otherwise, yeah just use mysql_query() or use the command line of course the second 2 options assume you can construct the SQL command to do it, using phpMyAdmin you won't really need to know. /beau // -Original Message- // From: Duncan Abbott [mailto:[EMAIL PROTECTED]] // Sent: Friday, 26 October 2001 9:17 AM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] HELP! (mysql) // // // hello, // // can one of you clever people guys 30 seconds to help a lady...? // // can someone just tell me the best way to create a new table // in a mysql // database? // should i use the mysql_query() function? // // thank you boys, // // xxx // // // // -- // PHP Database Mailing List (http://www.php.net/) // To unsubscribe, e-mail: [EMAIL PROTECTED] // For additional commands, e-mail: [EMAIL PROTECTED] // To contact the list administrators, e-mail: // [EMAIL PROTECTED] // -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Help ! MySQL Problem
ok you must get your variables like row1, row2 etc from anywherelse then try this format too insert them at your db mysql_connect("localhost","username","password") or die ("cant connect database"); @mysql_select_db("databasename") or die("cant connect database"); mysql_query("INSERT INTO yourtablename(row1, row2, row3) VALUES ('$row1', '$row2', '$row3') ") ""Rosen"" [EMAIL PROTECTED] wrote in message 987flt$h2r$[EMAIL PROTECTED]">news:987flt$h2r$[EMAIL PROTECTED]... Hi, I'm using MySQL database and I try: " insert into roubr('id','pos','name') values ( select id,pos,name from requestroubr) " and it don't work ! Please help! Rosen Marinov -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Help ! MySQL Problem
Thanks, but it doesn't work ! "Brinzoi Constantin Aurelian" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... On Thu, 8 Mar 2001, Rosen wrote: Hi, I'm using MySQL database and I try: " insert into roubr('id','pos','name') values ( select id,pos,name from requestroubr) " Try this: insert into roubr(id,pos,name) values select id,pos,name from requestroubr I hope this will work ! Best regards Constantin Brinzoi and it don't work ! Please help! Rosen Marinov -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]