PLANOS DE SAÚDE PARA VOCÊ OU PARA SUA EMPRESA

Seu cliente de e-mail não pode ler este e-mail. Para visualizá-lo on-line, por favor, clique aqui: http://www.ps-mkt.com/emailer/display.php?M=259&C=10a817f92e8d8a7838d6001dda9522d0&S=11&L=6&N=3 Para parar de receber nossos e-mails:http://www.ps-mkt.com/emailer/unsubscribe.php?M=259&C=10

Relationships - Foreign Key

Hi, sorry for my english, but, how can I do relationships between tables? Is possible? Thanks, Paulo Daniel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

limiting acess by Triggers

Hi all , Im new on mysql,how can block update column of specif table for a user "x" by trigger in mysql? Is possible deny acess for columns on mysql? version: 5.0.77 Regards

Recreate orphaned table from innodb

les... They were all bunched up together. The question is: how can I see the data stored in the InnoDB datafile so that I can try and rebuild the FRM files or something like that?? Any ideas? Thanks a lot... Paulo Bernardo Lindoso Systems Engineer Datacraft do Brasil [EMAIL PROTECTED] Tel +55 11

Replication and Transaction

What happen? Would it be synced later? []'s Paulo Angelo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thre

MySQL driver for DELPHI ?

I am a DELPHI developer and I need to know if exists a MySQL driver for DELPHI. Does MySQL have a driver for DELPHI??? If it does, please send me it... My e-mails: [EMAIL PROTECTED] [EMAIL PROTECTED] ... at least I´d like to know if it does or it doesn´t and

error creating database

r: '@localhost' to database 'desenv'' The directory "/usr/local/mysql" and subfiles owner and group are "mysql" Anybody can help me! Thanks! Paulo Fonseca Jr. [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysq

Server tuning

n the manual (if so, my apologies, but I could not find). TIA, -- João Paulo Vasconcellos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Newbie: Replication Question

Very good, gmail does not handle mailing lists properly.. Sorry for sending this off-list to you, Alec. On Fri, 9 Jul 2004 17:09:45 -0300, João Paulo Vasconcellos <[EMAIL PROTECTED]> wrote: > > > On Fri, 9 Jul 2004 10:44:42 +0100, [EMAIL PROTECTED] > <[EMAIL PROT

Re: SELECT difficulties

SELECT offerid, resellerid, price FROM A WHERE pricece = MIN(price) GROUP BY resellerid; - Original Message - From: "Michael Stassen" <[EMAIL PROTECTED]> To: "Daniel Lahey" <[EMAIL PROTECTED]> Cc: "Haitao Jiang" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, July 30, 2004 7:33 PM

Index problems

usuario.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair >---< My question is: how can I repair / recreate hte index definition ? I scan the manual, and it says nothing about it. Thanks in advance, -- João Pa

Index problems

usuario.frm' doesn't have a correct index definition. You need to recreate it before you can do a repair >---< My question is: how can I repair / recreate hte index definition ? I scan the manual, and it says nothing about it. Thanks in advance, -- João Pa

MySQL Dumps

witch. -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 3852-9008 Ramal 31 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Newbie: access denied for user

5: Access denied for user: 'root@localhost' (Using password: NO) > > # ./mysql -u root test > ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) > -- João Paulo Vasconcellos Gerente de Tecnologi

InnoDB is better than MyISAM ?

in MySQL, and I would like to know if InnoDB is better than MyISAM for this. Best regards, -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com

InnoDB and replication

Hello there, anybody here has some background using InnoDB and MySQL replication feature ? If so, would you mind sharing those information with me ? -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 3852-9008 Ramal 31 [EMAIL PROTECTED

Re: My.S.Q.L

Very fun ! - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, April 06, 2002 2:35 PM Subject: My.S.Q.L > Ok... it's Saturday and I've been meaning to share this with a wider > audience for years Antti, you'll probably remember this from when > I

SELECT from blob column

I've tried LOAD_FILE with many other files, including files in world-readable directories, and I always get the same result. Am I missing something ? -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008

Re: SELECT from blob column

Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: SELECT from blob column

ou put a trailing newline, it appears. sql -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Install problem!

Hello there. Some time ago I have installed MySQL and after a short period of time I uninstalled it. Now when I try to install it again the installshield makes a sound (like a warning) show a message box to quickly (it disappears right after) and don’t install MySQL. I’m using windowsxp pro

What is `Aborted Clients` ?

Hello Everybody, can anyone explain me what is an Aborted Client ? I begin to wonder about this because this number was about 20 or 30 last week, and now suddenly it got above 200 ! I have no idea of what it means, so any help would be appreciated. Filter : sql -- João Paulo

Re: What is `Aborted Clients` ?

Thanks everybody. > Filter : sql -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the man

(Maybe) Silly question

, but I am not sure if the DATE part will be the same after the change. Anybody here did this before ? [ Hello filter, I can speak SQL :) ] -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED

Re: (Maybe) Silly question

eld. > Thanks. I'll try it. > -----Original Message- > From: João Paulo Vasconcellos [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 03, 2002 1:43 PM > To: [EMAIL PROTECTED] > Subject: (Maybe) Silly question > > > Hello everybody, > > i was thinking about my data

Re: Stupid - I just can't get it (NOT IN or NOT EXISTS)

should work fine. > > It comes up with an error 1064: SQL syntax near '(SELECT msoccerroster.SID > FROM msoccerroster)' > > please help > J > > -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED] -

Re: INSERT IF NOT EXISTS?

, that would be pretty high up on my whish-list : ) > Yes: INSERT IGNORE INTO ... You can read more at http://www.mysql.com/doc/I/N/INSERT.html -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 38

The silence...

Wow, what happened today ? Never saw that list so quiet. SQL. -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED] - Before posting, please check: http

Re: faster update

x27; WHERE email = ?"; > my $sth = $dbh->prepare($sql_statement) || die "Error1 preparing update > statement on track:\n" . $dbh->errstr; > > while (){ > > print "$_\n"; > $sth->execute($_) || die "Error2 executing update statement

Re: ROOT Access Denied !!

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/ph

Re: Obvious mistake in query?

--- > 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 > unsubscr

Re: Mysql SELECT IF()

quest this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED]

Re: email address authentification .....

uest this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED]

MySQL and Filesystems

Hello everybody, someone can tell me the best FS to run MyISAM along with InnoDB tables ? SQL - For you-know-who -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED

startup automatic

Hi all I have Mysql Version: 3.23.49a at RadHat 7.2 I read the documentation about automatic startup/shutdown but when I start the script it wait for a ENTER then it doesn't work at boot I always need do manual startup anybody have any hint ?? ats

update

How do I do to execute a UPDATE using sub query as in the example below? update veiculo2000 set marca = ( select arq2.marca fromveiculo arq2 where veiculo2000.status_veic = '0'

Re: Neede MySQL query Equivalent.

Hi Erwin Try Select afield from atable where index=(select max(index) from atable); []s Paulo Botelho - Original Message - From: "Erwin Hogeweg" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 07, 2002 12:47 PM Subject: Neede MySQL qu

Problem when install PHP4 with MySQL

Hi all I need a Help I installed mysql 3.23 ( mysql-3.23.33-hp-hpux11.00-hppa2.0w.tar.gz ) in HP-UX 11.00 and now I try install PHP4 ( 4.0.4pl1 ), but I have some problem's # cd /opt/php4 # ./configure --with-mysql=/opt/mysql # make after make command occur the follow error message

Lost Connection

MySQL server during query" The MySQL is working fine but I can´t use MySQL Administrator for Windows (or dBTools) anymore. Did anyone have such problem? Does anybody know how to solve it? Thank you. Eng. Deleo Paulo Ribeiro Junior [EMAIL PROTECTED] (55) 48 233-0081 (55) 48 231-1586 Flo

Innobase

\MYSQLD.EXE: Got signal 11. Aborting! 010517 9:07:55 Aborting InnoDB: Warning: shutting down not properly started database 010517 9:08:03 C:\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete Thanks, Paulo Arantes de Azambuja Diretor de Tecnologia Freedom2buy - F2b Tel: 55 11 3079-2229 r116 Fax: 55 11 3079

mm.mysql.jdbc-1.2c and applets

documentation says that "it allows Java developers to make connections to MySQL servers from both Java applications and applets", so I don't understand what is wrong. The same piece of code works nice if running as an application. Cheers, Paulo Mora de Freitas. Nestacap