Open Source

2002-11-18 Thread Alexander Burbello
Hi people, 

It's available in the site br.geoticies.com/burbello the Source of My 
Database Manager. 

I opened the source for everybody to do the best tool for us. It's was made 
in Delphi 6 and Zeos DBO. Ok 

Regards. 


Alexander 


sql,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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



Certification

2002-11-14 Thread Alexander Burbello
Hi,

I would like to know if are there any certification for MySQL like DBA
Oracle or something like that?

Grettings

Alexander

sql,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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Insert many records

2002-11-12 Thread Alexander Burbello
Hi,

How can I insert many records (for instance: 1.000.000) without to do this
by application?

Are there a loop sintax like PL/SQL?

Regards


sql, 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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Insert many records

2002-11-12 Thread Alexander Burbello
I know I can do it by application. 

But I would like to know if are there other way to do the same. 




sql, query 


[EMAIL PROTECTED] escreve: 

In a message dated 12/11/2002 18:46:08 GMT Standard Time, [EMAIL PROTECTED] 
writes: 


Hi, 

How can I insert many records (for instance: 1.000.000) without to do this
by application? 

Are there a loop sintax like PL/SQL? 

Regards 


sql, query

either use BatchUpdate or a transaction. 

Are you using ADO. ?
Sam


-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Profiler

2002-11-07 Thread Alexander Burbello
I would like to know if the MySQL has any command where I get the queries
requested by the application.

SQL Server has Profiler.
Oracle has any command that I don´t know

With Delphi I run SQLMonitor.

Regards


Alexander



sql,query

___
Yahoo! Encontros
O lugar certo para encontrar a sua alma gêmea.
http://br.encontros.yahoo.com/

-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: My Database Manager

2002-11-06 Thread Alexander Burbello
People,

now the site is running. Please, if anyone could get, send me suggestions
and criticals. Ok

I count with you.

Alexander


- Original Message -
From: Chris Boget [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 11:13 AM
Subject: Re: My Database Manager


 Yesterday, someone (I cannot recall who) posted a link
 for a piece of software called My Database Manager.
 I tried going to that link on and off for the last day and
 I'm always getting a 404.  Has anyone successfully DL'd
 this app?  If so, could you send me a copy?  I'd be very
 interested in checking it out.

 Chris

 sql,query --- arrgh!!



 -
 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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Opinion

2002-11-05 Thread Alexander Burbello
Hi people, 

I did my work but I need to put some opinions and suggestions in my 
graduation project about the implementation. 

Could anybody get the program br.geocities.com/burbello and evaluate and 
after report to me, some critical, suggestions and bugs about the Manager 
My Database Manager. Doesn´t need to install, is simply. I intend the end 
of this year to make a good tool for the MySQL user and put available in 
january. 

I count with your help. 

Regards 


Alexander 


sql, 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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



Re: Opinion

2002-11-05 Thread Alexander Burbello
Sorry,

Geocities is run out.

http://www.burbello.hpg.ig.com.br/


Version 1.6 18/09/2002 - Size 650 KB - exe-file only

  My Database Manager -Srv1
  My Database Manager -Srv2


Get the Second link. Ok


Alexander


- Original Message -
From: Mark Armer [EMAIL PROTECTED]
To: 'Alexander Burbello' [EMAIL PROTECTED]
Sent: Tuesday, November 05, 2002 2:00 PM
Subject: RE: Opinion


Hi,

Can't get in with that url. What should I use?

Mark

-Original Message-
From: Alexander Burbello [mailto:burbello;pop.com.br]
Sent: Tuesday, November 05, 2002 09:26
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Opinion


Hi people,

I did my work but I need to put some opinions and suggestions in my
graduation project about the implementation.

Could anybody get the program br.geocities.com/burbello and evaluate and

after report to me, some critical, suggestions and bugs about the
Manager
My Database Manager. Doesn´t need to install, is simply. I intend the
end
of this year to make a good tool for the MySQL user and put available in

january.

I count with your help.

Regards


Alexander


sql, query

-
Please check http://www.mysql.com/Manual_chapter/manual_toc.html;
before posting. To request this thread, e-mail
[EMAIL PROTECTED]

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it, e-mail
[EMAIL PROTECTED] instead.





-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Size

2002-11-04 Thread Alexander Burbello
I and my friend will do a test with SQL Server, Oracle and MySQL

We´ll start with a table with 2.000.000 rows.

What´s the best table type to do it?

I thought to do in InnoDB but how much do I set the size? Maybe 200MB?


Regards


Alexander


sql, query

___
Yahoo! Encontros
O lugar certo para encontrar a sua alma gêmea.
http://br.encontros.yahoo.com/

-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Start Transaction in InnoDB

2002-10-30 Thread Alexander Burbello
Hi,

I would like to know, how can I start a new transaction using InnoDB Tables?

Alexander


mysql, query

___
Yahoo! Encontros
O lugar certo para encontrar a sua alma gêmea.
http://br.encontros.yahoo.com/

-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Privileges - Does Anybody knows how to answer to me?

2002-10-15 Thread Alexander Burbello


 Hi, I read the book, but there is not explain about it.

I would like to know when I give privileges to the user, in the table
level, and after I give privileges in the database level. Do I replace the
privileges?
 
 
 There are two tables ('db' and 'tables_priv') in mysql database.
 
I gave privileges, for example, to the table 'tables_priv', I give only
'select' privilege to the table Tb01.
 
But I give other privileges, now to the table 'db'. I gave 'insert',
'delete' and 'update' privileges to the database 'Test'.
 
Now the user has privileges to:
- 'select' the table 'Tb01'
- ''insert', 'delete' and 'update' the database 'Test'. Right

---
What can he do?
Can he insert or delte on the table tb01?
Can he select data in all the tables of the database 'Test'?

 
Regards
 
 
sql, 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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




privileges

2002-10-14 Thread Alexander Burbello

Hi, I would like to know when I give privileges to the user, in the table
level, and after I give privileges in the database level. Do I replace the
privileges?


There are two tables ('db' and 'tables_priv') in mysql database.

 I gave privileges, for example, to the table 'tables_priv', I give only
 select to the table Tb01.

 But I give other privileges, now to the table 'db'. I gave insert,
delete
 and update privileges to the database 'Test'.

 Teste  - Database
   |
    Tb01   - Table

 The user has these privileges,
 What can he do?
 Can he insert on the table tb01?
 Can he select data in all the tables of the database?

 Regards


 Alexander




 sql, 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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Use host

2002-10-14 Thread Alexander Burbello

Hi,

I would like to know when I use the table Host.

Why does she exists?




query, sql


-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Diferences between check and analyze

2002-10-14 Thread Alexander Burbello

I make always confuse,  what is the diference between the command CHECK and
ANALYZE.

Regards

sql, 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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Gemini Table

2002-10-14 Thread Alexander Burbello

I would like to know what the exactly diference the ACID nomenclature.

I read the mysql documentation, but it´s a little difficult to understand
between C and D.

Does anybody can explain. Tks.

Greetings

Alexander



sql, query

___
Yahoo! Encontros
O lugar certo para encontrar a sua alma gêmea.
http://br.encontros.yahoo.com/

-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Privileges

2002-10-11 Thread Alexander Burbello

 I need to know urgent.

 There are two tables ('db' and 'tables_priv') in mysql database.

 I gave privileges, for example, to the table 'tables_priv', I give only
 select to the table Tb01.

 But I give other privileges, now to the table 'db'. I gave insert, delete
 and update privileges to the database 'Test'.

 Teste  - Database
   |
    Tb01   - Table

 The user has these privileges,
 What can he do?
 Can he insert on the table tb01?
 Can he select data in all the tables of the database?

 Regards


 Alexander




 sql, query

___
Yahoo! GeoCities
Tudo para criar o seu site: ferramentas fáceis de usar, espaço de sobra e acessórios.
http://br.geocities.yahoo.com/

-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Connecting to another machine with myCC

2002-08-29 Thread Alexander Burbello

Hi,

Try another tool named My Database Manager. You can download the site
br.geocities.com/burbello.

Greedings


Alexander

- Original Message -
From: Fred Tsang [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 29, 2002 7:38 AM
Subject: Connecting to another machine with myCC


 Folks,

 I have a question about myCC.  I can't connect to a local linux machine
(ip
 192.168.0.232) for the life of me from my win2k box (ip 192.168.0.232)
using
 myCC.  I've done the following:

 GRANT ALL ON test.* TO 'fred'@'192.168.0.230';
 FLUSH PRIVILEGES;

 but, in my mysql.log I still get:

 020816 14:11:18   6 Connect Access denied for user:
 '[EMAIL PROTECTED]' (Using password: YES)

 My user table looks like:
 mysql select user,host from user;
 ++---+
 | user   | host  |
 ++---+
 | root   | 192.168.0.230 |
 | fred   | 192.168.0.230 |
 || lancelot  |
 | root   | lancelot  |
 || localhost |
 | fred   | localhost |
 | root   | localhost |
 ++---+

 What have I done wrong?  I know that mysql is up and running and listening
 to port 3306.  If anyone has an idea, please let me know.

 Cheers,
 Fred


 -
 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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

___
Yahoo! Encontros
O lugar certo para encontrar a sua alma gêmea.
http://br.encontros.yahoo.com/

-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




File path

2002-08-12 Thread Alexander Burbello

Hi all,


How can I change the file paht c:\windows\my.ini.

Is possible I have two files because I want to start
two instances in same machine.

I would like to change like that:
-  c:\windows\my.ini
-  c:\windows\my2.ini


Regards


Alexander





sql, query

___
Yahoo! PageBuilder
O super editor para criação de sites: é grátis, fácil e rápido.
http://br.geocities.yahoo.com/v/pb.html

-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




lock row

2002-08-09 Thread Alexander Burbello

Hi,

how can I lock only one row in the table?

What table type I have to use to lock?


Regards


Alexander



sql, query

___
Yahoo! PageBuilder
O super editor para criação de sites: é grátis, fácil e rápido.
http://br.geocities.yahoo.com/v/pb.html

-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




InnoDB

2002-07-19 Thread Alexander Burbello

I intend to install innoDB tables in my MySQL Server.
But where I make download of the InnoDB databases.

And after, how do I install??



Greetings

Alexander





sql query

___
Yahoo! Encontros
O lugar certo para encontrar a sua alma gêmea.
http://br.encontros.yahoo.com/

-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




instance

2002-07-17 Thread Alexander Burbello

When I want to run two servers with different
configuration. Can I run in the same machine and two
running?


Alexander



sql, query

___
Yahoo! Encontros
O lugar certo para encontrar a sua alma gêmea.
http://br.encontros.yahoo.com/

-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Concept

2002-07-16 Thread Alexander Burbello

I would like to know if MySQL has the same concept
like Oracle has about Instance? or phisical structure
like datafiles, control files, etc.

___
Yahoo! Encontros
O lugar certo para encontrar a sua alma gêmea.
http://br.encontros.yahoo.com/

-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Concept

2002-07-16 Thread Alexander Burbello

I would like to know if MySQL has the same concept
like Oracle has about Instance? or phisical structure
like datafiles, control files, etc.


Regards


Alexander






sql, query

___
Yahoo! Encontros
O lugar certo para encontrar a sua alma gêmea.
http://br.encontros.yahoo.com/

-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Presentation

2002-07-15 Thread Alexander Burbello

Hi,

anybody have any presentation showing about mysql.

For example topics: History, Phisical structure, Logic
structure, etc.

I need to make a presentation about mysql.

If somebody could help me. I would appreciate


Alexander




sql, query

___
Yahoo! Encontros
O lugar certo para encontrar a sua alma gêmea.
http://br.encontros.yahoo.com/

-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Presentation

2002-07-14 Thread Alexander Burbello

I need to make a presentation about the topics of
mysql like history, phisical structure, logic
structure, like that.


Alexander


 --- Jeremy Zawodny [EMAIL PROTECTED] escreveu:
 On Sat, Jul 13, 2002 at 11:12:11PM -0300, Alexander
 Burbello wrote:
  Hi,
  
  I need to make a presentation about MySQL
 (structure,
  etc.)
  
  Anybody can help me. If anybody have a
 presentation
  (powerpoint, etc) would you be so kind to send me
 by
  e-mail, please.
 
 Can you be a little more specific?  Saying
 structure, etc doesn't
 tell me *at all* what you intend to present.  The
 structure of what?
 
 I have several presentations on-line here:
 
   http://jeremy.zawodny.com/mysql/
 
 but I suspect that none of them will help you.  Let
 me know if they
 do.
 
 Jeremy
 -- 
 Jeremy D. Zawodny, [EMAIL PROTECTED]
 Technical Yahoo - Yahoo Finance
 Desk: (408) 349-7878   Fax: (408) 349-5454   Cell:
 (408) 685-5936
 
 MySQL 3.23.51: up 45 days, processed 977,585,799
 queries (250/sec. avg)
 

-
 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 unsubscribing? Try:
 http://lists.mysql.com/php/unsubscribe.php
  

___
Yahoo! Encontros
O lugar certo para encontrar a sua alma gêmea.
http://br.encontros.yahoo.com/

-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Presentation

2002-07-13 Thread Alexander Burbello

Hi,

I need to make a presentation about MySQL (structure,
etc.)

Anybody can help me. If anybody have a presentation
(powerpoint, etc) would you be so kind to send me by
e-mail, please.

Regards


Alexander





sql, query


___
Yahoo! Encontros
O lugar certo para encontrar a sua alma gêmea.
http://br.encontros.yahoo.com/

-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




New tool

2002-07-09 Thread Alexander Burbello

People,


there is a new tool on the site:

http://geocities.yahoo.com.br/burbello/

it's worthwhile.



sql, query



___
Yahoo! Encontros
O lugar certo para encontrar a sua alma gêmea.
http://br.encontros.yahoo.com/

-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Privileges

2002-07-02 Thread Alexander Burbello

I would like to know what does mean the privilege
References_priv on the table users??

Regards

Alexander





sql, query

___
Yahoo! Encontros
O lugar certo para encontrar a sua alma gêmea.
http://br.encontros.yahoo.com/

-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




New Manager

2002-06-24 Thread Alexander Burbello

Hi,


There are a new MySQL Database Manager.


Try this site: http://geocities.yahoo.com.br/burbello/


doesn't need to install, just download and execute.


Regards


Alexander

___
Copa 2002
Yahoo! - Patrocinador oficial da Copa do Mundo da FIFA 2002
http://br.sports.yahoo.com/fifaworldcup/

-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Indexes

2002-06-18 Thread Alexander Burbello

I would like to know if mysql have any resources to
know when I execute any sql (eg. select) and I would
like to know what index was used, like SQL server.

 

Regards



___
Copa 2002
Yahoo! - Patrocinador oficial da Copa do Mundo da FIFA 2002
http://br.sports.yahoo.com/fifaworldcup/

-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Indexes

2002-06-18 Thread Alexander Burbello

I would like to know if mysql have any resources to
know when I execute any sql (eg. select) and I would
like to know what index was used, like SQL server.
 
  
 
Regards


___
Copa 2002
Yahoo! - Patrocinador oficial da Copa do Mundo da FIFA 2002
http://br.sports.yahoo.com/fifaworldcup/

-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Seem to be short

2002-06-14 Thread Alexander Burbello

Sorry, but I had a problem with my e-mail.

Anybody can help me?? please

Alexander


I am using the component Zeos, and when I execute the sql show
create table
the resultset came like that:

CREATE TABLE `clientes` (
  `cli codigo ID` int(11) NOT NULL auto increment,
  `cli nome` varchar(50) default NULL,
  `cli endereco` varchar(70) default NULL,
  `cli bairro` varchar(20) default NULL,
  `cli cidade` varchar(20) default NULL,
  `cli estado` char(2) default NULL,
  `cli cep` varchar(9) default NULL,
  `cli cnpj` varchar(16) default NULL,
  `cli ie` varchar(15) default NULL,
  `cli data abertura` varchar(10) default NULL,
  `cli socio titular` varchar(40) default NULL,
  `cli cpf socio` varchar(Û8,wÌÚ

Seem to be short, but there are any componet property to set the
lenght.


What Can I do in this case??


Alexander



-- 
__
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup

Save up to $160 by signing up for NetZero Platinum Internet service.
http://www.netzero.net/?refcd=N2P0602NEP8


-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Message

2002-05-16 Thread Alexander Burbello

I made a program with delphi and I would like to get the message when is
execute any query.

eg: select ...
 10 rows in set (0.04 sec)  .

This message is important for me. How can I get it.


Alexander




A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br.


-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Message

2002-05-16 Thread Alexander Burbello

I made a program with delphi and I would like to get the message when is
execute any query.

eg: select ...
10 rows in set (0.04 sec)  .

This message is important for me. How can I get it.


Alexander




A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br.


-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: MySQL with Delphi 5.0

2002-04-23 Thread Alexander Burbello

I tryed to use Delphi 6.0 and dbExpress, but I didn't got.

What component and what property I have to set for use correct??


Regards


Alexander


-- Mensagem Original --

  Hi, Haroldo

  Is it first time to develop Database Application with Delphi?
  Do you know how to use DataAccess Component(e.g., TDatabase) and
BDE(or BDE Administrator)?

  I suggest to use Delphi6 Pro/Ent. It contains dbExpress Component which
help you to develop Database Application very easily.
  (Note: dbExpress is able to connect to MySQL server directly,
using Native Driver without ODBC Driver)

Thanks.

--
Borland Japan / Consulting Group
TAKAHASHI, KEN, Tomohiro

José Haroldo Filho wrote:

 I've installed MyODBC and then I've set up ODBC and I saw the driver
for
 MySQL DB, when I try to create a new alias wiht MySQL it does not apear
to
 select the DB, acording a book wich is guiding it should has to appear.

 Can anybody help to set up the ALIAS with MySQL

 Thanks

-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php







A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br.


-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: MySQL with Delphi 5.0

2002-04-23 Thread Alexander Burbello


I tryed to use Delphi 6.0 and dbExpress, but I didn't got.

What component and what property I have to set for use correct??


Regards


Alexander


-- Mensagem Original --

  Hi, Haroldo

  Is it first time to develop Database Application with Delphi?
  Do you know how to use DataAccess Component(e.g., TDatabase) and
BDE(or BDE Administrator)?

  I suggest to use Delphi6 Pro/Ent. It contains dbExpress Component which
help you to develop Database Application very easily.
  (Note: dbExpress is able to connect to MySQL server directly,
using Native Driver without ODBC Driver)

Thanks.

--
Borland Japan / Consulting Group
TAKAHASHI, KEN, Tomohiro

José Haroldo Filho wrote:

 I've installed MyODBC and then I've set up ODBC and I saw the driver
for
 MySQL DB, when I try to create a new alias wiht MySQL it does not apear
to
 select the DB, acording a book wich is guiding it should has to appear.

 Can anybody help to set up the ALIAS with MySQL

 Thanks

-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php







A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br.







A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br.


-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Version

2002-04-18 Thread Alexander Burbello

Anyone know about when will be available the new version of mysql?

Alexander




A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br.


-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Difference between Max

2002-03-18 Thread Alexander Burbello

I would like to know, what difference between the version mysql and mysql-max.

I don't found anything about.

Regards


Alexander
Pr/Brazil




A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br.


-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




How to use transactions

2002-03-15 Thread Alexander Burbello

I would like to know how work transactions!! are there is mysql 3.23.49??

If there is, how can I use transaction with rollback and commit? I read
about transaction, and exist other way to use. How can I use?



Regards



Alexander
Curitiba/Pr/Brazil









A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br.


-
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 unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php