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

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

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 answ

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_appr

Newbie: A single number

but found no answer (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]

charset

iated. 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]

Troubles starting MySQL

ibdata1 InnoDB: File operation call: '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

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

Re: More than one MyQSL in a server

ING 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 wan

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 --datadir=/usr/local/mysql-5.0.27

Resetiing indexes

d 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: Sent: Friday, March 11, 2005 1:49 PM Subject: Problem in a very simple SQL stateme

Problem in a very simple SQL statement

obviously something's wrong. What can 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: 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

chroot mysql

Any ideas of what can 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 PROTEC

yacc defenition file

Can any one tell me where can I find the gramar defenition for sql language used in mysql? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: convertion probleme from string to char *

Hello, I use a little function to solve this problem in mysql++ . char* c_string(const string& s){ char* p = new char[s.length() + 1]; s.copy(p, string::npos); p[s.length()] = 0; return p; } char *temp = c_string(row[ "YOUR COLUMN"].c_str()); MArio H.C.T. -

Beginner with MYSQL on linux RH 7.1

But I dont know how I can start the client to do the table. Thanks a lot. Ass. Mário Coelho __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard