On Thu, Jun 06, 2002 at 02:24:06PM -0700, Matt Rowe wrote:
Dear list,
After doing a good bit of reading, the details are still hazy.
I have a web-based application (about 20 tables, with up to 100,000
records per table - but most tables are much smaller). 99% of
select queries are very
Hello John,
Friday, June 7, 2002, 1:54:52 AM, you wrote:
JK Num refers to the text file from which the data is read. It contains the count of
JK records shown in the Records column, followed by the total number read in to that
point.
JK The time in seconds to insert these records is under the
Hello,
Starting mysqld with --flush, flushes tables to database or disk
log??
Thanx in advance,
Ritu Singla
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi,
I use MySQL-Max-4.0.1 and i am wantering if
is true that the information about the foreign keys are stored at
comment properties of table with maximum length 60 characters?
I need to use innodb tables with many f.keys.What I have to do?
Thank you.
- Original Message -
From: asong [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 07, 2002 8:40 AM
Subject: mysql database quota problems.
Hello,
I want to set quota to mysql database by every database or by every user,
I
can not find any issues from mysql official
- Original Message -
From: asong [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 07, 2002 4:29 PM
Subject: Fw: mysql database quota problems.
- Original Message -
From: asong [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 07, 2002 8:40 AM
Subject:
- Original Message -
From: asong [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 07, 2002 4:29 PM
Subject: Fw: mysql database quota problems.
- Original Message -
From: asong [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 07, 2002 8:40 AM
Subject:
- Original Message -
From: asong [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 07, 2002 4:30 PM
Subject: help with quota problem, thx.
- Original Message -
From: asong [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 07, 2002 4:29 PM
Subject: Fw:
ok folks,
I was digging into my own problem and that's what I found:
host 'hegel' running 3.23.39 is using character_set latin1
host 'fidel' running 4.0.1 is using character_set latin1_de
latin1_de is character set '#31' mentioned in the error message below.
Character set latin_de was
Hi,
I use MySQL-Max-4.0.1 and i am wantering if
the information about the foreign keys are stored at
comment properties of table with maximum length 60 characters?
I need to use innodb tables with many f.keys.What I have to do?
Thank you.
Hello all,
Does anyone know if there is a way to remotely call the data_source
[DBI-data_source('mysql')] property to pull all available databases/drivers?
I can't seem to do it since you are not allowed to specify a host name, user name,
or password with it. The docs mention nothing
-Original Message-
From: victoria papazoi [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 07, 2002 11:58 AM
To: [EMAIL PROTECTED]
Subject: foreign keys in MySQL-Max-4.0.1
Hi,
I use MySQL-Max-4.0.1 and i am wantering if
the information about the foreign keys are stored at
comment
Hi,
Right from the connect section in the DBD::mysql manual:
$dsn =
DBI:mysql:database=$database;host=$hostname;port=$port;
$dbh = DBI-connect($dsn, $user, $password);
Shawn wrote:
Hello all,
Does anyone know if there is a way to remotely call the
Hi,
I have a vb application which connects to mysql via ado/myodbc 3.51.03. In
it, users can choose to connect to databases on different machines. I
construct a connection string from the hostname, database etc. So far so
good.
The problem I have only occurs (as far as I can tell) on Windows
* Benjamin Pflugmann
On Thu 2002-06-06 at 19:17:10 +0200, [EMAIL PROTECTED] wrote:
[...]
But... is this the only feature of mysql which is dependant on the
processor architecture?
See it the other way: You are not garantueed more than 31 tables in a
join. If you happen to have a 64Bit
Hi everybody,
I'm new to MySQL and have got the following code that works with Oracle
SQL... After looking at the documentation I realised that DECODE seems to be
reserved for encryption... any idea of how this would work with MySQL? Here
is the code:
The tables are as follows
Hi ,
-Original Message-
From: mySQL list [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 07, 2002 2:35 AM
To: [EMAIL PROTECTED]
Subject: MyODBC DSN Configuration Dialog Hidden
Hi,
I have a vb application which connects to mysql via
ado/myodbc 3.51.03. In
it, users can
Can someone *please* pick up the dropped ball on the
release schedule and run with it ? It's not such
a big deal for ISAM table users but it's a very big
deal for InnoDB tables...
MySQL AB: The least you could do is say: OK, we have this X problem and
still working out Y... but we
Hi,
Sorry to bother the Guru's here, but I've recently started working on
getting a mySQL database up and running and I noticed that some
aggregate functions like MAX and MIN don't have 'DISTINCT' as an
optional arguement. Are these not supported or is this just missing
from the documentation?
Hi,
try including this path i.e. /usr/lib/mysql/ in LD_LIBRARY_PATH in .cshrc
file...i guess, it'll do...
Ritu
On Fri, 7 Jun 2002, Charitha wrote:
Hello all,
I am having one application in which i am using mysql as database.
When i run my application it gives following error.
Mark,
3.23.51 is built and works on most major platforms, including Linux,
Solaris, Windows, and FreeBSD.
But the mysqld.sym file was forgotten from the Linux distribution. The build
master is working on that right now.
I think the release will be handed over to the web team after that, and
I still feel the best starting point for data modelling is the original
Flemming/von Halle book, _Handbook of Relational Database Design_. It
doesn't address any individual RDBMS implementation, which makes its lessons
general, but it carefully walks you through all the fundamentals of
modelling,
Hello,
(i had already posted this ques, got a reply but that
character format was unreadable..so i'm sorry for
posting it again..)
Starting mysqld with --flush, flushes tables to
database or disk log??
Pls. help!!
Thanx in advance,
Ritu Singla
sql,query
Hello dear all,
i have a table like this:
field_machine, field_date, field_time, field_function.
field_function can be =TT or +BT
well i need to perform a select query, witch display on one line
field_machine,
(field_date, field_time where field_function =TT) AS start,
(field_date,
[snip]
So I figured I'd go to the list and ask the question. What are peoples
opinion's on the best book(s) covering the following topics?
1. Creation
2. Normilazation
3. Optimization
4. Managing
5. Modeling
[/snip]
A great place to start is Database Design For Mere Mortals (watch wrapped
URL)
I'm afraid I'm not quite clear on what you're trying to do; do you want one
result per row, with one NULL column and one non-NULL column, or do you want
one row per distinct 'machine', with both a start and a stop date?
In the first case, this can be implemented with a simple IF():
Hi Venu,
The problem I have only occurs (as far as I can tell) on
Windows XP, not
Windows 2000: If I try and connect to a host where mysql is
not running, the
driver pops up an error message box,
saying [MySQL][ODBC 3.51 Driver] Can't connect to MySQL
server on 'hostname'
A release schedule would be a big help. Can anyone provide a date as to
when 4.xx will go beta?
Fred Steinkopf
Can someone *please* pick up the dropped ball on the
release schedule and run with it ? It's not such
a big deal for ISAM table users but it's a very big
deal for InnoDB
Hi,
I use MySQL-Max-4.0.1 and i am wantering if
the information about the foreign keys are stored at
comment properties of table with maximum length 60 characters?
I need to use innodb tables with many f.keys.What I have to do?
Thank you.
Frederick,
4.0.1 is beta quality, or even stable, if you do not use the multi-table
delete or replication.
For 3.23.51 my guess is it will be is released June 14, 2002. For 4.0.2 my
guess is July 15, 2002.
For 3.23.52 I guess July 7, 2002. InnoDB-3.23.52 is already completed. When
the build
When you have a table with both numeric and variable-length text data,
and you need to update the numeric part a lot, it made sense in MyISAM
to split the numeric from the textpart. (Because working on fixed-length
tables is so much faster.) Say...
Original:
Table 1: id1 int, id2 int,
Are you shure you don't really want ENUM('y','n')
SET('y','n') will allow the field to be both 'y' and 'n' at the same time.
Chris Knipe wrote:
I'm talking under correction here, but
SET('y'.'n') default 'n' NOT NULL - should work. I normally just do all
this stuff via phpmyadmin, it works
I located this behavior this morning and was wondering how to prevent it;
I have 3 (or more tables) where I perform a query like this;
SELECT a.btn, b.dateFlag, c.dateFlag, d.dateFlag
FROM tblA a, tblB b, tblC c, tblD d
WHERE a.btn = b.btn
tblA and tblB have information in them and btn is a
Hi everybody,
I'm new to MySQL and have got the following code that works with Oracle
SQL... After looking at the documentation I realised that DECODE seems to be
reserved for encryption... any idea of how this would work with MySQL? Here
is the code:
The tables are as follows
table
This happens because a 'normal' join is like a multiplicative product
between all the rows matched in all the tables:
result_rows = a_rows * b_rows * c_rows * d_rows
so if any of the factors are zero, the result is zero.
Your WHERE clause will cut down on the number of rows you get back, and you
[snip]
This happens because a 'normal' join is like a multiplicative product
between all the rows matched in all the tables:
result_rows = a_rows * b_rows * c_rows * d_rows
so if any of the factors are zero, the result is zero.
Your WHERE clause will cut down on the number of rows you get back,
Geeze... This message was sent (according to my sentbox) on 5/24/02 and just appeared
on the list on 6/7/02 (I had given up on it). I don't know whats up with that...
Next, what I asked for was a way to read the datasources, NOT connect to mysql. I
want to be able to see all the
Either I'm misunderstanding what you're trying to do or that Oracle query is
a really complicated way of doing something simple.
create table Customer ( name text, id int auto_increment primary key );
create table Skill ( description text, id int auto_increment primary key );
create table
I am working on a project were the customer info will be uploaded to a MySQL
database from multiple sources with a customer ID already assigned to them
and this data needs to be related to other tables with related info. OK I
have an auto increment column set up as the primary key to keep track
At 9:59 -0500 6/7/02, Shawn wrote:
Geeze... This message was sent (according to my sentbox) on 5/24/02
and just appeared on the list on 6/7/02 (I had given up on it). I
don't know whats up with that...
Next, what I asked for was a way to read the datasources, NOT
connect to mysql. I want
I want to use SOUNDEX for name queries, but I don't
seem to be doing it correctly.
As a test, I made a small table and popluated it
with my name. My goal is to be able to find my name
'Callaghan', with its most common misspelling
'Callahan'.
I've read the MySQL doc, so I know how to
I hate to be the one to break this to you, but
soundex('Callaghan') != soundex('Callahan')
It's just the sad truth: the algorithm thinks they are pronounced
differently, so it doesn't consider them to match.
soundex() is certainly better than nothing, but in many cases not much
better. I'm not
Hi,
You are doing everything fine, however, soundex is not a perfect system and does not
always work. It does simplify some types of queries. But in the vast majority of cases
I don't think that it is worth the bother.
It doesn't actually link all the same sounding sirnames, if there were a
Tim,
Friday, June 07, 2002, 7:05:40 AM, you wrote:
TJ I am using
TJ mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu
TJ on RH 7.2
TJ I would like to sort on multiple columns, but Mysql
TJ tells my that the specified key would be too long
TJ (error 1071).
TJ If
Roger,
Friday, June 07, 2002, 12:43:38 PM, you wrote:
RB * Benjamin Pflugmann
On Thu 2002-06-06 at 19:17:10 +0200, [EMAIL PROTECTED] wrote:
[...]
But... is this the only feature of mysql which is dependant on the
processor architecture?
See it the other way: You are not garantueed more
Kris,
Friday, June 07, 2002, 1:21:48 PM, you wrote:
KS Sorry to bother the Guru's here, but I've recently started working on
KS getting a mySQL database up and running and I noticed that some
KS aggregate functions like MAX and MIN don't have 'DISTINCT' as an
KS optional arguement. Are these not
Greg,
Thursday, June 06, 2002, 6:42:09 PM, you wrote:
GT help please. I am seeing very disturbing, very large, and very sporadic
GT temporary files appear in the MySQL $tmpdir location. Here's a brief listing:
GT-rw-rw1 mysqlmysql6488514560 Jun 6 14:14 #sql4f3_1f8aa_2.MYD
* Dave Callaghan
I want to use SOUNDEX for name queries, but I don't
seem to be doing it correctly.
As a test, I made a small table and popluated it
with my name. My goal is to be able to find my name
'Callaghan', with its most common misspelling
'Callahan'.
That will be difficult using
Thanks for your response Daniel,
1. I appreciate that InnoDB is more robust than ISAM- passes the ACID
test.
2. Just convert InnoDB tables to MyISAM and backup the MyISAM version.
I did this on a large table- it took a while and generated lots of I/O.
Multiply this by 200 databases and 1000
Thanks you for your prompt reply!
Luck of the Irish, I guess. This is another reason
to test your systems on your client's platform, not
your own. My client's target the Latin American
population, so let's try this again with a more
representative data sample.
Note that I had an error in my
Hi All
At 11:17 PM 6/6/2002 -0700, Jeremy wrote:
However, there is the occasional select query that requires a good
amount of work on the database.
Why? Can it be optimized?
The query is needs about 10 left joins, and requires data from about 12
different tables (some tables have 50,000
Is there any way to dynamically create columns non programatically? As in pure sql
queries?
This is what I am doing now:
SELECT SQL_BUFFER_RESULT
ORDERHEADER.ID_CUSTOMER AS 'Acct #',
CUSTOMER.Company AS 'Company',
SALESLEVEL.Name AS 'Client Type',
DATE_FORMAT(ORDERHEADER.AvailableAt, '%b')
* Victoria Reznichenko
RB mysql is considered to be platform independant, and I suppose
RB MySQL AB is trying to keep it that way...?
Roger, MySQL is platform independent.
I did not say it was not... :)
It works on any platform with
the same data, but if the architecture is 64 bit, you
Hi,
I'm new to this stuff. I first tried to install the binary distribution
but it failed because of not finding libz.so,
then I am trying to install with the source code,
./configure --prefix=/rstc/user1/erc/pushkar/mysql-3.23.49
make was okay, mesgs. were given about not finding libz.so but
Seems like this should be an easy question, but I just don't get it:
If I have CREATE TABLE Elems (ObjId INT, ElemId INT);
Is there a nice query to find the Number of Distinct ElemId's for each ObjId?
Motivation: Later I will want to add a WHERE ObjId IN (...) and join the Obj
describing table
You mean
SELECT ObjId,ElemId,count( distinct Objid,ElemId ) from Elems group by
ObjId;
?
Csaba Gabor wrote:
Seems like this should be an easy question, but I just don't get it:
If I have CREATE TABLE Elems (ObjId INT, ElemId INT);
Is there a nice query to find the Number of Distinct
Hello,
I created an eVC++ app for Pocket PC that uses libmySQL.lib, but it won't compile. It
compiles
when I comment out any references to any mySQL functions from the libmySQL dll. I
initially used
mysql++ but found out that it uses STL, which of course eVC++ doesn't support, so I
was
Depends. If this is a correlation table and the combined columns are a
primary key,
SELECT ObjId,
COUNT(ElemId)
FROMElems
GROUP BY ElemId;
if the combination is not unique, then:
SELECT ObjId,
COUNT(DISTINCT ElemId)
FROMElems
GROUP BY ElemId;
-
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
how much access does odbc@localhost need?
i don't have any dsn that use the user, i don't have any php scripts that use
it as a log in into the database; however if i disable the user, ALL of the
pages that use a mysql odbc datasource break with the error that
odbc@localhost can't log in.
Hello,
I created an eVC++ app for Pocket PC that uses libmySQL.lib, but it
won't compile. It compiles
when I comment out any references to any mySQL functions from the
libmySQL dll. I initially used
mysql++ but found out that it uses STL, which of course eVC++ doesn't
support, so I was
Hi,
I am using SuSE 7.0 and MySQL 4.0.1. I had quite a time
getting the daemon started on Linux but finally succeeded.
I can start the daemon logged on as su and I can connect
to the database as user=mysql and modify the existing DB
called test.
I set the permissions as recommended in
Hello.
On Fri 2002-06-07 at 05:15:51 +0200, [EMAIL PROTECTED] wrote:
[...]
No, it's probably not difficult at all. It simply seems as if
people do not understand exactly what you want. A communication
problem, IMHO.
Kevin was also kind enough to point this out to me, and I have to
Cindy Nelson wrote:
Hi,
I am using SuSE 7.0 and MySQL 4.0.1. I had quite a time
getting the daemon started on Linux but finally succeeded.
I can start the daemon logged on as su and I can connect
to the database as user=mysql and modify the existing DB
called test.
I set the
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/
Hello,
I created an eVC++ app for Pocket PC that uses libmySQL.lib, but it
won't compile. It compiles
when I comment out any references to any mySQL functions from the
libmySQL dll. I initially used
mysql++ but found out that it uses STL, which of course eVC++ doesn't
support, so I was
INSERT INTO table (column) VALUES ('path');
I'd recommend you goto www.mysql.com and download the manual - then read it.
Kind Regards,
Chris Knipe
MegaLAN Corporate Networking Services
Tel: +27 21 854 7064
Cell: +27 72 434 7582
- Original Message -
From: Silmara Cristina Basso [EMAIL
Escape the \
like so:
'c:\\temp\\calc.exe'
It's all in the manuals.
Kind Regards,
Chris Knipe
MegaLAN Corporate Networking Services
Tel: +27 21 854 7064
Cell: +27 72 434 7582
- Original Message -
From: Silmara Cristina Basso
To: [EMAIL PROTECTED]
Sent: Friday,
Hi.
On Fri 2002-06-07 at 11:43:38 +0200, [EMAIL PROTECTED] wrote:
[...]
However, I think my question is valid... I don't think it is a good idea to
limit the number of joins based on the processor architecture, and this
makes me wonder what other 'strange' limitations I might find in mysql...
Hi all,
I am using mysql-4.0.1. I am trying to set up a second innodb datafile.
Following the instructions in the manual I added :
innodb_data_file_path=ibdata1:64M;ibdata2:100M:autoextend
in my my.cnf file, but when I restart the mysql I get the error:
InnoDB: syntax error in
Minor points:
Why didn't you add -I/usr/include/mysql to compile options instead of
changing mysql.h to mysql/mysql.h?
Try posting to [EMAIL PROTECTED] instead, it's low traffic but the
correct list for mysql++
I upgraded to GCC 3.0.4 for other reasons and built mysql++ with that, and
never
I believe the autoextend functionality won't be available until 4.0.2.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: vlady [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 07, 2002 2:19 PM
To: [EMAIL PROTECTED]
Subject: Innodb autoextended
Hi all,
I am using mysql-4.0.1. I am
Hello,
I created an eVC++ app for Pocket PC that uses libmySQL.lib, but it
won't compile. It compiles
when I comment out any references to any mySQL functions from the
libmySQL dll. I initially used
mysql++ but found out that it uses STL, which of course eVC++ doesn't
support, so I was
We are using MySQL 3.23.42 and having some difficulties with locks.
I was wondering if anyone out there has written any neat monitoring tools
or knows of
one that will alarm and send email when locks are excessive/persistent.
Thanks, in advance
Candy Bostwick
Candice Bostwick ([EMAIL
Hi,
I try to change the root password after the first time
connecting to mysql server. I followed the tutorial
at http://www.mysql.com/articles/mysql_intro.html.
Somehow, I got the error mesage, what did I type
wrong?
Please help. Thank you.
~ # mysql -u root
Welcome to the MySQL monitor.
Try 'mysqlaccess root localhost' and see if there is a password set in
the output.
Try man mysqladmin and set the password there.
If you've hosed your perms then stop the damon and restart it with
--skip-grant-tables and start again.
Remember to do mysqladmin reload or flush privileges
A client of mine runs MySQL in a pretty high volume environment, and for
the past couple months we've had a lot of trouble with corrupt tables
(error 127). We've changed the MySQL version (presently to version
3.23.49), FreeBSD version (presently to 4.5-STABLE), hardware (from IDE
to SCSI)
Hey gang,
I have two tables:
user
++--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
++--+--+-+-+---+
| user_id| int(10) unsigned |
What's the best way to lock down a slave to ensure that only select SQL
queries are executed and that all command line SQL inserts, updates, and
deletes are performed only on the master?
TIA
-
Before posting, please check:
* Benjamin Pflugmann
On Fri 2002-06-07 at 11:43:38 +0200, [EMAIL PROTECTED] wrote:
[...]
However, I think my question is valid... I don't think it is a
good idea to
limit the number of joins based on the processor architecture, and this
makes me wonder what other 'strange' limitations I
On Fri, 7 Jun 2002 17:40:01 -0600 , Orr, Steve
[EMAIL PROTECTED] wrote:
| What's the best way to lock down a slave to ensure that only select SQL
| queries are executed and that all command line SQL inserts, updates, and
| deletes are performed only on the master?
|
| TIA
Only put in select
Please excuse me if this is something blindingly obvious, but having now
encountered this in several circumstances, but I have been unable to find a
resolution in the docs (perhaps I just missed it?).
In actuality we encountered the problem when doing some nasty joins, but the
problem seems
Jon,
Have you tried phrasing your WHERE clause as
WHERE sequence_log_id = 0 ?
If there is a determinate lower bound other than zero, then substitute it
for 0 as the second comparand.
Let us know how it comes out.
(And however it comes out, don't ask me why. The real experts can sort
* Mysql, after reading the query, decides wether using an index would be
better than just a table row scan. Hence, it's MySql's decision
* You can force MySql to use indexes using the 'using index' option with the
select query.(MySql 'might' still reject the force, not sure of the
Yes, regarding the $PATH my bad... putting it in /usr/lib should have
resolved it(since it's generally in LD_LIBRARY_PATH). Besides that, as Ritu
suggested, it should be in LD_LIBRARY_PATH variable in the environment not
$PATH. Not familiar with /etc/ld.conf, that might work too.
Bhavin.
-
* Mysql, after reading the query, decides wether using an index would be
better than just a table row scan. Hence, it's MySql's decision
MySQL is making the wrong decision. As stated below, it's doing a table
scan when it only needs to look at some 2,800 rows out of 970,000 rows. In
No, there is no way to trigger an insert automatically when you are doing a
LOAD DATA (bulk load). You will need another flat file with the appropriate
info and load that in as well...just as you have thought of.
- Original Message -
From: Dion Wickander [EMAIL PROTECTED]
To: MySQL Help
In the last episode (Jun 07), Thomas Lackner said:
A client of mine runs MySQL in a pretty high volume environment, and for
the past couple months we've had a lot of trouble with corrupt tables
(error 127). We've changed the MySQL version (presently to version
3.23.49), FreeBSD version
In the last episode (Jun 07), Jule Slootbeek said:
Hey gang,
I have two tables:
user
++--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
First, thanks for your response.
I don't have the error message in front of me, but it's something like:
# myisamchk -r table
Data rows: 56,402
Attempting to fix records: 0/0 something something
Data rows: 0
#
Next time it occurs I'll save the detailed error message.
MySQL doesn't crash..
Description:
Change datadir in /etc/my.cnf or elsewhere. Start server (i.e.,
/usr/local/share/mysql/mysql.server start) and then try to stop it
(/usr/local/share/mysql/mysql.server stop)
How-To-Repeat:
# joe /etc/my.cnf
Change some settings, especially datadir
#
92 matches
Mail list logo