Re: select from otherdb.table question?

2008-01-20 Thread Brent Baisley
When you establish a connection, it's a connection to a server, not a specific DB. You can set a default db so that you don't always have to specify the db name you are working with. So to answer your question, no, a new connection is not established. Brent On Jan 19, 2008, at 10:19 AM,

Re: select from otherdb.table question?

2008-01-20 Thread Alex K
Hi Brent, ahh of course :) thank you so much for answering though. Alex On 20/01/2008, Brent Baisley [EMAIL PROTECTED] wrote: When you establish a connection, it's a connection to a server, not a specific DB. You can set a default db so that you don't always have to specify the db name you

Re: Where can I get mysql.so?

2008-01-20 Thread Daniel Kasak
On Sat, 2008-01-19 at 19:02 +, Apple wrote: Fatal error: Call to undefined function mysql_connect() in /home/re/script.php on line 3 I've googled and found out that I need to add extension=mysql.so in CLI's php.ini file (separate php.ini file that works for CLI only). The

Re: Who know this strange problem

2008-01-20 Thread Moon's Father
This is correct.Thank you very much. But I also why I wrote is wrong on linux and right on windows. You can tell me answer if you have time.thanks. On Jan 19, 2008 12:47 AM, Baron Schwartz [EMAIL PROTECTED] wrote: Hi, On Jan 18, 2008 3:50 AM, Moon's Father [EMAIL PROTECTED] wrote: My test

Re: Handling Special Characters

2008-01-20 Thread Sebastian Mendel
Jerry Schwartz schrieb: I am having trouble inserting special characters into a table. I am using the MySQL client. I put the following commands into a text file (I'm on WinXP, using Notepad), copy them, and paste them into the MySQL command line client. SET NAMES utf8; CREATE TEMPORARY TABLE

Re: Is there any determined date for mysql 6 release?

2008-01-20 Thread Sebastian Mendel
legolas schrieb: Hi Thank you for reading my post Is there any scheduled date mysql 6 release? don't know I heard that it is based on falcon and can perform better... based on in the wrong term, MyISAM will still be the default storage engine, it just adds Falcon as a new storage engine

encrypt - password

2008-01-20 Thread Luca Ferrari
Hi all, I've got an account table with password encrypted thru the encrypt() function, and I should transfer them to a table with password() function. I don't want to decrypt the password, and I'd like to know if there's a way to build the password hash from the encrypt one. Any suggestion?