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
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?
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
://dev.mysql.com/doc/mysql/en/show-table-status.html
Am 09.04.2005 um 11:42 schrieb Daniel Kiss:
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 length
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
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 list archives:
with
\
and try it with
fields terminated by ',' optionally enclosed by '' as mentioned by
Mike Johnson's posting
(escaped by '\' is default)
-Original Message-
From: Daniel Kiss [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 3:02 PM
To: [EMAIL PROTECTED]
Subject: LOAD DATA
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]
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 ??
--
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
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
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
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:
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:
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 versions
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:
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
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 them connects to my local network and the
other connects
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 pseudocolumn for
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 with
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,
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
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:
Hi,
Does MySQL use other port(s) for network communicaton
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]
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
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
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:
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:
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,
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
/*
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
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)
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)
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
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:
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
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
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)
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
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
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,
:/mysql/bin/mysqld-nt.exe
I've tried appending the line default-character-set=big5 to it and
restarted MySQL but doesn't seem to do the trick.
Should I create a my.cnf in the C: root instead with the
default-character-set to it?
Thanks a lot!
Paul
- Original Message -
From: Daniel Kiss
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 comments to your
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 Value, Count FROM Table,
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
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 answer
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
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:
Im inserting 6.000.000 records on a table... but in 3.500.000
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
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
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,
The password() function is a one way encoder. In other words it just
generates some kind
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
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
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:
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
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
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/
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:
. 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 4:23 PM
To: [EMAIL PROTECTED]
Subject:Delphi 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
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
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
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
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
64 matches
Mail list logo