Call PHP file from MySQL

Hi, Is it possible to call from within MySQL an external PHP script ? I've read MySQL Stored Procedure Programming from O'Reilly but found nothing :( How can I do this ? Any help would be appreciated. Warm Regards, Mário Gamito -- MySQL General Mailing List For list archives: http

Send INSERT statement from MS SQL SERVER to MySQL

Hi, Is it possible to send an INSERT statement from a Windows server running MS SQL SERVER 2005 to a Linux box running MySQL ? If so, how ? Do I need any special tools ? Any help would be appreciated. Warm Regards, Mário Gamito -- MySQL General Mailing List For list archives: http

Newbie: A single number

(my bad, probably). What I want is to have just 47 as a result of the SELECT. Any help would be appreciated. Warm regards, Mário Gamito -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Newbie: A single number

. Any ideas ? Warm Regards, Mário Gamito Sebastian Mendel wrote: Mário Gamito schrieb: Hi, I'm trying to get a single number out of a SELECT statement: SELECT comment_approved, COUNT(comment_agent) from wp_comments WHERE comment_agent LIKE '%Linux%' OR comment_approved=0 GROUP

Re: Newbie: A single number

Hi Michael, I've tried your tip, but I get the error: #1054 - Unknown column 'ct_ct_comment_agent' in 'field list' Any ideas ? Warm Regards, Mário Gamito Michael Cole wrote: You have two rows the zero which has a single row and the other row If the answer you are after is 48. select sum

charset

. Warm Regards -- :wq! Mário Gamito -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Inserting a file in MySQL

Hi, How do i insert a file in a blob field from the command line ? Any help would be appreciated. Warm Regards -- :wq! Mário Gamito -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

More than one MyQSL in a server

Hi, I have a 3.23 MySQL running in a server and i want to install 5.0.27 I made # ./configure --prefix=/usr/local/mysql-5.0.27 --with-tcp-port=3307 # make # make install and then # scripts/mysql_install_db --datadir=/usr/local/mysql-5.0.27/var # ./mysqld_safe

Re: More than one MyQSL in a server

from pid file /usr/local/mysql-5.0.27/share/mysql.sock2 061102 10:54:03 mysqld ended Any ideas ? Best Regards, Mário Gamito On 11/2/06, Nico Sabbi [EMAIL PROTECTED] wrote: Mário Gamito wrote: Hi, I have a 3.23 MySQL running in a server and i want to install 5.0.27 I made # ./configure

Can't create database

Hi, I've installed MySQL 5.0.27, but can't create databases. I get ERROR 1006 (HY000): Can't create database 'contineo' (errno: 28) In the log file i have this: InnoDB: Error: auto-extending data file ./ibdata1 is of a different size InnoDB: 0 pages (rounded down to MB) than specified in the

Troubles starting MySQL

: 'create'. InnoDB: Cannot continue operation. 061102 14:08:25 mysqld ended What's going on here ? This never happened to me in years. What is teh problem and how to solve it ? Thanks in advance. Mário Gamito

Resetiing indexes

. Warm Regards, Mário Gamito -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem in a very simple SQL statement

it be ? Any help would be apreciated. Warm Regards, Mário Gamito -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problem in a very simple SQL statement

Arghh... shame on me forever. I'm speachless. Mikhail Entaltsev wrote: Missed FROM clause... ;) Best regards, Mikhail. - Original Message - From: Mário Gamito [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, March 11, 2005 1:49 PM Subject: Problem in a very simple SQL statement

Re: Unable to login in MySQL database after installation

that there is to it :) Regards, Mário Gamito Mysql Plusplus wrote: Hi, After I installed rpm packages on my system, I am unable to connect to the databse. I have installed in the following order 1)Server 2)Client 3)Devel 4)Shared Compat After starting the databse with: /etc/rc.d/init.d/mysql start I am

chroot mysql

it be ? Any help would be apreciated. Warm Regards. -- Mário Gamito Administração de sistemas e desenvolvimento Netual - Multimédia e Telecomunicações, Lda. Rua João Afonso, Nº1 3800-198 Aveiro - Portugal Tel. +351 234 371 431 / Fax. +351 234 371 438 E-mail: [EMAIL PROTECTED] www.netual.pt -- MySQL