lock table...

I using MySQL (type=MyISAM) with Delphi5 -MyODBC, the problem is that when I edit one row The MySQL not lock for other machines, therefore other person can edit the same row and save the changes and when I try to save, it get one error. Tell me I to do? Thanks. -

newbie

I'm newbie MySql I have one field path-char-250. How can i insert the following value ('c:\temp\calc.exe')? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

license...

I'm developing a program, that is not free software and i'm using mysql with myodbc. The question is if i need a license or not... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists

Re: license...

But my program not use only mysql (able to oracle, paradox and MS Sql Server), However, do i need license? - Original Message - From: Jay Blanchard <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 10, 2002 4:10 PM Subject: RE: license... > [snip] > I'm developing a progra

Create database in other location ...

I'm using MySQL 4.0.1 ( Innodb) and I want to create a database 'c:\mydata\sami_d0' and log file 'c:\mylogs\sami_l0', How can i do that? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http:/

newbie - start (innodb)

This is the configuratin My.ini: [WinMySQLAdmin] Server=C:/MYSQL/bin/mysqld-max.exe user=root [mysqld] basedir=C:/MYSQL #bind-address=192.168.10.10 datadir=C:\mydata innodb_data_home_dir = c:\mydata innodb_data_file_path =sami_d1:100M innodb_log_group_home_dir =c:\mylogs innodb_log_arch_dir =c:\

create a new table in a tablespace...

I'm using MySQL 4.0.1 and my question is "How can i do to create a new table in a tablespace?". Thank you! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: create a new table in a tablespace...

If i had more than one tablespace, don't i control where it will be stored ? - Original Message - From: Egor Egorov <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 18, 2002 11:06 AM Subject: Re: create a new table in a tablespace... > Silmara, > Tuesday, June 18, 2002,

lost connection

I have one client with three IPs one 0.0.0.0 other to connect internet and the last from LAN. The problem is that when i try to connect a server MySQL through MyODBC, i get the follow error message: [MySQL][ODBC 3.51 driver] Lost connection to MySQL server during query What's happening? Thank y

text

I'm working with MySQL and Delphi. I created the following table: Create table Ligacoes ( Lig_cod INTEGER NOT NULL, Lig_codate INTEGER NOT NULL, Lig_nomeat VARCHAR(20), Lig_data DATE NOT NULL, Lig_duv TEXT, Lig_resp TEXT, Lig_penden CHAR(1), Lig_codcli INTEGER, Lig_erro CHAR(1), Lig_os

Innodb X myisam

I have been working with Mysql-Myisam, but when I converted to Inoodb I noticed that my queries were much slower. Why? what can I do for best the performance? When do I have to use the innodb? Best regards. Thank you! - Bef