Global Unique Identifiers

Hi All, I'm designing a database where it is required for each row in a table to have a unique identifier accross a bunch of running MySQL servers on a network. I'm considering two options: 1. Have a two-column primary key, where the first column is a normal auto incremented ID field, the

MySQL+InnoDB Licenses

Hi All, I would have a question about licensing MySQL. I am writing an application that relies on MySQL+InnoDB (uses MySQL as a database backend). I will distribute my program under GPL (get fees only for official support). Do I or my client have to buy MySQL+InnoDB licenses in this case? T

Re: Large tables

dev.mysql.com/doc/mysql/en/table-size.html> > <http://dev.mysql.com/doc/mysql/en/full-table.html> > <http://dev.mysql.com/doc/mysql/en/create-table.html> > <http://dev.mysql.com/doc/mysql/en/show-table-status.html> > >> Am 09.04.2005 um 11:42 schrieb Daniel Kiss:

Large tables

Hi All, I would like to know how big is the biggest database that can be handled effectively by MySQL/InnoDB. Like physical size, number of tables, number of rows per table, average row lenght, number of indexes per table, etc. Practically, what if I have a master/detail table-pair, where the

Collations

Hi Everyone, I used MySQL 4.1.0 and I've just upgraded to 4.1.2. I have noticed that several character sets and collations are just disappeared somehow from the new version. I have checked it with the 'show collation' and 'show character set' command. Is there any switch or configuring option t

RE: LOAD DATA LOCAL INFILE

dows) to search and replace the string > "" > with > \" > > > and try it with > fields terminated by ',' optionally enclosed by '"' as mentioned by > Mike Johnson's posting > > (escaped by '\' is default) > > >

LOAD DATA LOCAL INFILE

Hi all, How should I set the parameters of the LOAD DATA LOCAL INFILE command for a comma separated text file like this: "Text field",.4,123 "Text field with "" included quote",,45 "Text field with "","" a comma between quotes",1.2,44 Thanks, Dan -- MySQL General Mailing List For lis

Version 4.1.1

Hi all, Does anyone know when MySQL 4.1.1 will be released? I was told that around November 15th. Well, it's almost December now. Thanks, Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: rounding off

Hi! Use the round() function. round(14.9564, 2) = 14.96 round(32.1123, 2) = 113.11 Bye > Hello, > > > I need the ability to round off dollar amounts to the nearest 100th > of a dollar amount, IE $14.9564 to $14.96 or $132.1123 to $113.11 > > can this be accomplished with MySQL SQL function ??

Configuring built in OpenSLL

Hi all, I would like to know how to configure MySQL with the --with-vio and --with-openssl options. I have a MySQL-4.1 installed on a Red Hat 9 system from .rpm packages. When I use the show variables command, it returns have_opensll = NO. Does it mean that the ssl support is not compiled into t

Re: deleting files related to mysql

These are the InnoDB data and log files. They are there because probably you have the InnoDB feature switched on. You can delete them (all of them) safely, if you do not use InnoDB tables, but if you don't swicth off the InnoDB feature (in my.cnf for example), the system will recreate them after

SSL connection

Hi all, I would like to know how to set up the ssl parameters in the my.cnf file. Where can I find a complete example for this, or where is the detailed description of it in the MySQL documentation? Thanks, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

Client library

Hi all, I have already asked it a few days ago, but I got no answer. Does anyone know how to obtain the newest version of libmysql.dll and the header file(s) for it? Thanks, niel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://l

Re: mysqlfront versus mysqlcc

Try SQLyog at www.sqlyog.com It is pretty good, and full of interesting features. Bye > I currently use the excellent mysqlfront which is sadly no longer > supported. > > I've tried mysqlcc but it seems non-intuitive, and missing loads of > features. It also has a problem working with old versi

libmysql.dll

Hi all, I would like to know who develops and how to obtain libmysql.dll, and is there any Object Pascal header file for this library, or I have to make my own? Thanks, niel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.m

Changing Data Directory

Hi all, How can I change the directory of the databases? I have tries the basedir switch in the my.cnf [mysqld] section, but it did not work. How should I do it? Thanks, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMA

RE: ROWID

No. There is no physical address of a row in MySQL. >> On Thu, Nov 06, 2003 at 09:59:41AM -0800, Wan, Wenhua wrote:  >  >> Hi there,  > >> > Both Oracle and Informix use ROWID to uniquely represent the >> location of  > each row of data in a table.  ROWID is basically a >> hidden column or  > pse

Re: Connection speed

It is definitely not a DNS problem. I use IP addresses. Any other idea? Thanks > Sounds like a DNS problem to me. > > > Daniel Kiss wrote: > > >> Hi all, >> >> >> I have a MySQL 4.1 installed on a RedHat 9 machine with two >> interfaces. One of th

Connection speed

Hi all, I have a MySQL 4.1 installed on a RedHat 9 machine with two interfaces. One of them connects to my local network and the other connects to the internet. My problem is that it takes very long time (5-10 seconds or more) to connect to the MySQL from the local network. It takes long time t

Re: default-character-set=latin5

Have you tried this setting in the my.cnf file? [mysqld] default-character-set=latin5 Good luck > Hi, > > > I am from turkey.I have used  mysql  for a longtime.I downloaded > mysql_win 4.0.16 and then setup,But I can't startup mysql with latin5 > support.What can I do..? > > How can I recompile

MySQL 5 / Stored Procedures / SAP DB (MaxDB)

Hi all, I was reading the SAP DB chapter on mysql.com. I did not find all the answers for my questions, and maybe one of you knows them. So, I am in the designing phase of a robust enterprise database applications with a lot of modules. I am planning to use MySQL/InnoDB as a database server, but

Re: Login

unreachable from outside. That's why I asked that MySQL used other ports than 3306. Thanks,         niel > Hi! > > > Have you added users that are allowed to log in from hosts other than > localhost? > > Regards, > > > Chris > > > Daniel Kiss wrote: > >

Login

Hi, Does MySQL use other port(s) for network communicaton than the default 3306, or this is the only one. The reason why I ask it that I set up a firewall and I left this port open. But somehow, I cannot login from outside. The firewall is definitely configured well, and lets the 3306 port pac

Next release of v4.1

Hi all, Does anyone know when the next release of MySQL version 4.1 will come out? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SubQuery bug again in 4.1

Hi all, I think you misunderstood me. :-) I try to be more detailed, and I will also give an example. So, I have these two tables: CREATE TABLE main ( ID int not null, Value int, primary key (ID)) Type = InnoDB; CREATE TABLE sub ( MainID int not

SubQuery bug in 4.1

Hi all, I have two tables CREATE TABLE main ( ID int not null, Value int ); CREATE TABLE sub ( mainID int not null, KeyDate date not null, SubValue int not null ); I want the Value field in the main table to be set to the latest SubValue in the sub table. I suppose this syntax should w

mysql scripts

Hi all, I have a question about mysql client. How can I use it in such a way that it just executes a script on a specified database and then exists? Thanks, Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAI

Thist script does not run 2

Hi all, Sorry, I forgot to tell, that my default table type is InnoDB. I am trying to run this script below on a MySQL-4.0.11-NT server. It stops at the UserLogs table, but if I swap the last two tables' creation order, it runs correctly. Can anyone help me with this? Thanks Dan /* Beg

Thist script does not run

Hi all, I am trying to run this script below on a MySQL-4.0.11-NT server. It stops at the UserLogs table, but if I swap the last two tables' creation order, it runs correctly. Can anyone help me with this? Thanks Dan /* Begin */ CREATE TABLE `Branches` ( `Id` int unsigned not null, /

License

Hi all, If I develop a software for my company that works with MySQL and this software will be used only inside the company, do I have to purchase commercial license? Thanks, Dan - Before posting, please check: http

Re: Counting null values

Hi Octavian, Try this: select FieldName, count(*) from TableName group by FieldName Bye, Danny At 16:39 2003.02.08._+0200, you wrote: Hi all, I have a table where I have something like this: | abc | | abc | | xxx | | null | | null | | null | I want to count these lines to give the r

4.1 features

Hi all, Can anyone tell where can I find some documentation about the new features released in MySQL 4.1? Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.co

InnoDB on update cascade

Hi all, Does anyone know why 'on update cascade' option does not work in InnoDB foreign keys? Is it supported anyway? Thanks, Daniel mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) ht

Re: LEGAL information about MySQL.

Hi, Well I think the licence rules of MySQL are not that comlicated than you wrote below. I studied this a few month ago, and I interpret it much simplier. 1. You develop a software under GPL which uses MySQL (connects to, includes, uses, etc. whatever). In this case you don't need any licenc

Re: How to get MySQL to list current db's ?

Hi, At 11:35 2002.12.09._-0500, you wrote: Is there a way to ask MySQL to list the db's that are currently created? Yes: SHOW DATABASES Good luck, Daniel - Before posting, please check: http://www.mysql.com/manual

Re: using Delphi with MySql to store binary data

Hi, Read a blob field (containing any kind of data) from the database is easy. You have to do the same thing as in case of other field types. And if you use TBlobField field type (or dynamic typecast), this field type has a .SaveToStream (.SaveToFile) method. You can use this to save the data t

Where is 4.1 source

Hi all, Where can I download MySQL version 4.1 source code? Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request thi

Version 4.1

Hi all, I would like to know when MySQL version 4.1 will be available for windows as compiled install kit? Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.

Re: Reg: InnoDB

Hi, InnoDB is under GPL as well as MySQL. Anyway InnoDB is included in any distributions of MySQL-Max on any OS. Bye, Daniel At 11:50 2002.11.07. +0530, you wrote: Hello All, I would like to know whether MySQL-Max or MySQL 4 with InnoDB is freely available or InnoDB is available

Re: [newbie question] how do you change the default charset of MySQLunder windows

Hi Paul, Was the table01 created before you did the new settings and restart the service? Because if yes, youhave to recreate the table or rebuild the indexes. Anyway, I don't really know how chinese double-byte character representation works. Fortunately the Hungarian language uses the latin c

Re: [newbie question] how do you change the default charset of MySQLunder windows

aracter-set" to it? Thanks a lot! Paul - Original Message - From: "Daniel Kiss" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 3:06 PM Subject: Re: [newbie question] how do you change the default charset of MySQL under windows > Hi

Re: [newbie question] how do you change the default charset of MySQLunder windows

Hi You have to write a line like this into your my.cnf (in the C: root directory): default-character-set=... or whatever you like. You can find examples in your mysql directory for the my.cnf file. Oh, yes! You're from Hong Kong. So maybe you need this: default-character-set=big5 Bye,

Re: help needed

Hi Sheela, At 01:49 2002.10.11. -0700, you wrote: >hi, >I am using mysql >while creating a table I want to give column >descriptioneither by using a query or GUI >ex >create table t1( >a bigint not null ' here i wamt to tell what for the a >is >) > >pl help me > >thanks >sheela You can add comm

Re: Query Unsort Single Column

Is there primary key on field Value? Or any index? Daniel At 14:37 2002.10.04._ +0800, you wrote: > > Hi, > > > > My tables is something like this > > > > Value Count > > B 10 > > C 20 > > A 15 > > D 8 > > > > When I query using "SELECT Val

Re: How to create a table from other tables

Hi! It sounds like a simple UNION ALL thing, but I think I don'tunderstand well what your problem is. Can you give an example? Daniel At 12:59 2002.09.26. +0800, you wrote: >Dear all >i had two tables, tableA & Table B. >I want to create a permanent table call Table C which the first two field

Re: MyISAM to InnoDB

Hi! At 10:12 2002.09.24._ +0100, you wrote: >Question is, will this >require any SQL code changes to our application? We make heavy use of >features like temporary tables, autoincrement columns etc. Would if be >as simple as dumping the database and restoring it to InnoDB tables? The simple answ

Re: transactions...

Hi! At 00:56 2002.09.23._ -0300, you wrote: >Do I loose >too much performance using InnoDB tables in autocommit mode instead of >using MyISAM tables? The real quiestion is: Why do you want to use InnoDB tables when you don't want to use its transaction safe features? Anyway yes. I'm sure it is

Re: The table is full

Hi, There's no table size limit, but if you use InnoDB, maybe you need to extend the size of your tablespaces, because they CAN be full. Check out your my.cnf Good luck, Daniel At 08:21 2002.09.06._ -0300, you wrote: > IŽm inserting 6.000.000 records on a table... but in 3.500.000

Re: Table partitioning functionality

Hi, No, I'm afraid. MyISAM tables cannot be cut in several pieces. But check ot the InnoDB table type, because they work very similar to Oracle. InnoDB uses tablespaces, and there can be many of them, maybe with autoextend functionality. I know it is not the same you would like, but maybe you

Re: mysql password ( )

ord security for a website? > > >Randy >- Original Message - >From: "Daniel Kiss" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Thursday, August 29, 2002 12:19 AM >Subject: Re: mysql password ( ) > > > > Hi, > > > &g

Re: mysql password ( )

Hi, The password() function is a "one way encoder". In other words it just generates some kind of checksum of the input parameter. So you cannot decrypt them, but it is much safer than encrypting and decrypting strings, because even the attacker cannot decrypt them. :-) You can use it this way

libmysql

Hi, I'm interested in what are the differences between different versions of libmysql.dll's and libmysql.so's? And are their versions the same under linux and windows? Where can I get their header files in C or Object Pascal? Thanks, Daniel ---

Re: temporaere Dateien.

Hi, Please write in English to this mailing list, or go to a German one. Vielen Danke, :-) Bye Daniel At 11:04 2002.08.15. +0200, you wrote: >Hallo, >Ich wuerde gern wissen, warum und wann MySQL temporaere Dateien erzeugt. >Ausserdem wie vermeide ich, dass meine Festplatte bei der Ausf

MySQL logo

Hi, I'm planning to develop a commercial application with MySQL database engine. I would like to include the logo of MySQL on the splash screen and about box of the software. Do I need any permission to use the logos of MySQL. Thanks, Daniel ---

Benchmark

Hi, Where can I find some benchmark test result documentation. First of all, I'm interested in comparing MySQL, Oracle and MSSQL speed in different situations. Thanks, Daniel - Before posting, please check: http://

String collating support

Hi, I've read in the MySQL manual that "If the sorting rules for your language are too complex to be handled with the simple sort_order[] table, you need to use the string collating functions" I also read that the best documentations about how to use this feature are the already implemented ch

Czech complex character set

Hi, I would like to get the Chech complex character set. Where can I find it? Thanks, Daniel SQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (

RE: Delphi MySQL Access Components

eer >PhilCom Corporation >Tel. No.(Office) (088) 858-1028 >(Home) (088) 858-8889 >Mobile No. (63) (919-3085267) > > > > > -Original Message- > From: Daniel Kiss [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, July 24, 2002

Delphi MySQL Access Components

Hi, Can someone tell me what is the best MySQL native component set for Delphi? It does not matter if it is commercial, but I need one urgently. Thanks, Daniel - Before posting, please check: http://www.mysql.com/ma

Re: Sorting order in MySQL

Nikolaos and Victoria, Victoria! Just like Nikolaos, I also don't know what you mean send new character sets as seen with the explanations. The first thing I have to mention that I'm not sure how MySQL string comparison works, but I think it just compares the characters at the same position (

InnoDB free space

Hi, How can I ask the MySQL server how much free space is in InnoDB tablespaces? Thx, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the l

Foreign key definitions

Hi, I just would like to ask that what are the following foreign key definition extensions good for exactly? I mean how does these SQL syntaxes work? MATCH FULL | MATCH PARTIAL ON DELETE/UPDATE RISTRICT/CASCADE/SET NULL/NO ACTION/SET DEFAULT Thx, Daniel

Sorting order in MySQL

Hi all, I (like almost everyone else) use different character set than latin1. I have noticed that the Hungarian sorting does not work properly. I have checked he .conf files, and if I see it well, the way of comparing character fields is very simple. Just comparing he characters at the same po

MySQL Database Designer

Hi all, I have created a Database Designer for the MySQL databases on Windows. I wanted to attach it to this mail, but it's more than 300K, so I wouldn't be a good idea to send it to the mailing list, I think. But I would like some of you to check it out. So, if you would like to be a "beta test