How to use transactions

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 __

Difference between Max

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

Version

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 c

Re: MySQL with Delphi 5.0

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 Compo

Re: MySQL with Delphi 5.0

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 DataAcces

Message

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

Message

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. Acess

Message

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. Aces

Seem to be short

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) d

Indexes

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 Mund

Indexes

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 Mu

New Manager

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 Cop

Privileges

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/

version

Hi, I am using the component zeos, but I need to connect to oracle version 7.3.4. He gives me a error "ORA-03115 unsupported network datatype or representation" Anybody know if Do I get to connect Oracle 7.3.4?? Regards sql, query __

New tool

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

Presentation

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 ___

Re: Presentation

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, > &g

Presentation

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 ___

Concept

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.

Concept

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

instance

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.c

InnoDB

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 su

lock row

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

File path

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 __

Re: Connecting to another machine with myCC

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

Privileges

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

privileges

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 o

Use host

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

Diferences between check and analyze

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/ (th

Gemini Table

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 __

Privileges - Does Anybody knows how to answer to me?

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 pri

Start Transaction in InnoDB

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

Replication

I am try to make replication between two servers. I configurated the master and slave servers with the follow parameter in my.ini MASTER server-id=1 SLAVE master-host= master-user= master-password= master-port= server-id= What I have to do for the servers starts to replicate data? Alexander

Fw: Replication

Every time I want to replicate, do I have to restart? Alexander sql,query - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Alexander Burbello" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, October 31, 2002 9:33

Re: Replication

]> > To: "Alexander Burbello" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Thursday, October 31, 2002 9:33 PM > Subject: Re: Replication > > > > On Thu, Oct 31, 2002 at 05:02:49PM -0300, Alexander Burbello wrote: > > > I am try to make rep

Size

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 _

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"

Re: Opinion

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: Opini

Re: My Database Manager

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 Mana

Profiler

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 __

Insert many records

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

Re: Insert many records

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)

Certification

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

Open Source

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