hi list user ,
i am new to list and new to mysql
i gotta do a project of my company w=hci reqiure to extract data
from a server
the user in his browser reqest a graph .in the client m/c and
this requset goes to server where a java servelet has to accept
the request ..now what the servelet
Hi, i was thingking about locking the tables first so no connection
could write so i can do myisamchk. Is this process safe?
Procedures:
1. lockdb
2. run myisamchk -r or -o
3. unlock db
Btw, mysqld is running. I want to off it but i can't its a production
server.
Hope anyone could give me more
OK!
You can use SELECT DISTINCT:
SELECT DISTINCT id
FROM Table
WHERE nr=123
OR nr=456
this gives you all uniqe id's with nr = 123 OR nr = 456 and that is id = 1.
//
Jonny
-Ursprungligt meddelande-
Från: Spielberg Micha [SMTP:[EMAIL PROTECTED]]
Skickat: den 22 maj
David,
did you upgrade from a very old version of MySQL to .49? The sorting order
of latin1 accent characters was changed about 8 months ago, and that may
cause the assertion you have encountered. You should dump and reimport your
tables if you have accent characters.
Anyway, the B-tree index
Thats right...
But I don't want all id's with nr=123 or nr=456.
I want all id's with nr=123 and nr=456 and only these id's.
For Example:
id nr
---
1123
1 456
1 678
2 457
2 897
2 123
3 123
3 678
3 456
Id 1 and id 3 have only both numbers.
If I
Hi,
I have a scenario..
I lock this mysql table and then a query/insert came in one of my script's.
the table is locked, what will happen to that query?
Will it retry again to insert on that table or no, it will not.
ty,
louie...
Hi, i was just wondering... i have inserted 1 row on my table,
how come when i did lock table. Mysql did not see one of my insert.
Please check mail below, thanks.
mysql select * from louie2;
++---+
| id | firstname |
++---+
| 1 | louie |
++---+
1 row in
You've to do a self join to get this done.
select a.id from table a, table b where a.id = b.id and a.nr=123 and
b.nr=456;
Spielberg Micha wrote:
Thats right...
But I don't want all id's with nr=123 or nr=456.
I want all id's with nr=123 and nr=456 and only these id's.
For Example:
It works fine
thank you
regards Micha
-Ursprungliche Nachricht-
Von: Sammy Lau [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 22. Mai 2002 09:17
An: Spielberg Micha
Cc: [EMAIL PROTECTED]; Jonny Stendahl
Betreff: Re: AW: Subselect or other way?
You've to do a self join to get this
Hi,
I like the sincerely mans.
http://www.mysql.com/downloads/index.html
You can choose what version of MySQL do you want and in the bottom of every
page you can find the source
code.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail
Hello Dan Nelson [EMAIL PROTECTED],
Is there any lock problem on iSCSI or SAN environment?
Say, mutliple mysql server mount the backend iSCSI or SAN storage device.
Is it safe?
On Fri, 17 May 2002 12:49:01 -0500
Dan Nelson [EMAIL PROTECTED] wrote:
In the last episode (May 18), Patrick Hsieh
Can someone help me with the correct sytax here !
I'm trying to show results from the last two days(or week etc)
This is what I've got as my sql query
SELECT .
WHERE.
AND ( (DATE_SUB(j.stellen.t_stellen_date INTERVAL 2 day)
j.stellen.t_stellen_date)
but it doesn't work !
Hello,
I have a problem in an Apache module which connects to MySQL using C
API for counting banner views and clicks.
This module creates a report table for each day. This table is called
report_MMDD, where MMDD is the current day. To keep thing
simple I just make following query
I've noticed that MySQL doesn't support the use of internal selects with the
in and not in methods such as in this example from a where statement.
and shift_id not in
(select shift_assoc from facdba.staff_schedule_temp
where status 'EXL')
This
Hi,
thanks for all of the replies to my query.
I'm not sure that I explained my problem very well as the solutions
received are solutions to the problem I described, but not the one I
meant :-) (I don't think anyway)
I have a table in the format:
family | member | score
Never mind, I figured it out by reading a previous question and I understand
how to use Left join to do this.
-Original Message-
From: Alan Coleman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 5:22 AM
To: [EMAIL PROTECTED]
Subject: Internal Select statements using IN and
Can someone help me with the correct sytax here !
I'm trying to show results from the last two days(or week etc)
This is what I've got as my sql query
SELECT .
WHERE.
AND ( (DATE_SUB(j.stellen.t_stellen_date INTERVAL 2 day)
j.stellen.t_stellen_date)
but it doesn't work !
Hi i was using pure mysql in my project now using
adodb to provide portability.
now ihave a query like this
$date_time = $conn-Execute(select field from
tabname)
This field i mentioned is a date time field.
so its format is 2002-04-22 14:01:00 i can use
userDate in adodb to print the date
Hello! :)
One of my table suddunly stop working when I try to
execute SQL statement it'returns error msg:
Got error 127 from table handler
Is there a way to repair it. The information in this
table i very important for me.
Thank you.
__
Do You
If I install MySQL on the same server as Apache Php and only use MySQL
in Php, do I then have to install the MySQL client?
Regards Jacob
[ www.sharksforum.com ]
-
Before posting, please check:
I see at least three different techniques, each of which performs better for
different datasets. First, let's formalize our environment:
create table theTable (family int, member int, score int);
insert into theTable values (1,1,10), (1,2,15), (1,3,12), (1,4,17);
insert into theTable values
On Wednesday 22 May 2002 07:27 am, Jacob Friis Larsen wrote:
If I install MySQL on the same server as Apache Php and only use MySQL
in Php, do I then have to install the MySQL client?
Technically, you don't need it. But when I am debugging PHP, I often turn to
mysql client just for a sanity
If I install MySQL on the same server as Apache Php and only use
MySQL in Php, do I then have to install the MySQL client?
Technically, you don't need it. But when I am debugging PHP,
I often turn to
mysql client just for a sanity check on a query. If your
database stuff
fails,
ahem, well, I think that's covered it, thanks very much that's
excellent. That has to be in the top ten of 'comprehensive replies'
I was with you on the first option. I wanted to avoid dipping into perl
in this case ( or at least I was trying to get by without it.)
I will go with the second
Hi Jakob !!
If I install MySQL on the same server as Apache Php and only use
MySQL in Php, do I then have to install the MySQL client?
Technically, you don't need it. But when I am debugging PHP,
I often turn to
mysql client just for a sanity check on a query. If your
Having impossible problems installing MySQL.
Starting a project and don't want to use Oracle (cost is outrageous) or
anything on MSSQL (which performs like crap).
I keep getting errors involving resolveip when I install, or it just don't
work. When I try to run the ./configure command in Linux
louie,
Wednesday, May 22, 2002, 9:23:02 AM, you wrote:
lm Hi, i was thingking about locking the tables first so no connection
lm could write so i can do myisamchk. Is this process safe?
lm Procedures:
lm 1. lockdb
lm 2. run myisamchk -r or -o
lm 3. unlock db
lm Btw, mysqld is running. I want
louie,
Wednesday, May 22, 2002, 9:56:23 AM, you wrote:
lm Hi, i was just wondering... i have inserted 1 row on my table,
lm how come when i did lock table. Mysql did not see one of my insert.
lm Please check mail below, thanks.
lm mysql select * from louie2;
lm ++---+
lm | id |
Konstantin,
Wednesday, May 22, 2002, 2:02:42 PM, you wrote:
KY One of my table suddunly stop working when I try to
KY execute SQL statement it'returns error msg:
KY Got error 127 from table handler
KY Is there a way to repair it. The information in this
KY table i very important for me.
Sure.
Jacob,
Wednesday, May 22, 2002, 2:27:05 PM, you wrote:
JFL If I install MySQL on the same server as Apache Php and only use MySQL
JFL in Php, do I then have to install the MySQL client?
No, you shouldn't install MySQL client, but I suggest you to install
client package. In some cases it might
Hi,
R Alternatively, you can compute your order statistic explicitly by joining
R the table against itself, and then filter based on that:
Why did you use max(curEntry.family) and max(curEntry.member) ? I
tried the query w/out max, and it works just the same.
The
On 22/5/02 at 4:02 pm, Ciprian Trofin [EMAIL PROTECTED]
wrote:
Hi,
R Alternatively, you can compute your order statistic explicitly by
joining
R the table against itself, and then filter based on that:
Why did you use max(curEntry.family) and max(curEntry.member) ? I
tried
Hi everyone!
Are there any limitations on update queries, like on how many fields one
can update at the same time?
The first update query works just fine, the second does not work at all:
working :
update memberscopy set password='$password' where name =
'$f_name' and surname
Wednesday, May 22, 2002, 9:23:02 AM, louie wrote:
lm Hi, i was thingking about locking the tables first so no connection
lm could write so i can do myisamchk. Is this process safe?
lm Procedures:
lm 1. lockdb
lm 2. run myisamchk -r or -o
lm 3. unlock db
lm Btw, mysqld is running. I want to
Matt,
Wednesday, May 22, 2002, 7:51:19 AM, you wrote:
[hardly skipped]
MH The error that I commonly get (only see errors when I try manually
MH installing it, otherwise it gives me no errors, but it just doesn't
MH work) involve resolveip (can't lookup localhost.localdomain with
MH resolveip
Hi
i want to do in mysql query like that:
SELECT col_name FROM table1 NOT IN (select col_nmae FROM tablse2)
how can i do that?
thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hello mysql,
I have been using MySql with php for quite some time. DB and app
works quite well.
I now have to connect to MySql from a DB environment called
OpenInsight. Not to bore you with the details but it is a 32bit
windows environment whose primary database is a multi-dimensional db
Hi,
Any problem is an effect of the cause
so...
I keep getting errors involving resolveip when I install, or it just don't
work. When I try to run the ./configure command in Linux (7.1-7.3), it
kicks me back an error.
What error?
If I use the rpm installation, it seems to install
Przemyslaw,
Wednesday, May 22, 2002, 2:02:52 AM, you wrote:
PP SELECT ISBN,TITLE FROM tBooks
PP WHERE tBooks.ISBN=1876340436
PP AND MATCH (tBooks.TITLE) AGAINST (britannica)
PP ++-+
PP | ISBN | TITLE |
PP
What are you trying to accomplish with the query? What results do you
EXPECT to be returned?
Can you not do what you're trying to do with:
SELECT id FROM Table WHERE (nr=3D123 AND nr=3D456)
?
- Original Message -
From: Spielberg Micha [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Dear MySQL wizards,
Thanks for your help in the past. I'm gaining on it!
Here is a SELECT statement that does exactly what I want it to do...
SELECT lml.*, ahs.registrant FROM lml INNER JOIN ahs USING (cultivar)
OR for a more generic presentation,
SELECT a.*, b.field7 FROM
See the MySQL Documentation section on sub-selects, section 1.7.4.1
Sub-selects.
Gives examples of rewriting sub-select queries that MySQL does not support.
- Original Message -
From: Inbal Ovadia [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 22, 2002 10:59 AM
Subject: in
Robert,
Wednesday, May 22, 2002, 12:18:22 PM, you wrote:
RV I have a problem in an Apache module which connects to MySQL using C
RV API for counting banner views and clicks.
RV This module creates a report table for each day. This table is called
RV report_MMDD, where MMDD is the
SELECT table1.col_name
FROM table1 LEFT JOIN tablse2
ON table1.col_name = tablse2.col_nmae
WHERE tablse2.col_nmae IS NOT NULL
?
Tim Ward
Brett Ward Limited - www.brettward.co.uk
-Original Message-
From: Inbal Ovadia [mailto:[EMAIL PROTECTED]]
Sent: 22 May 2002 16:00
To: [EMAIL
Hi there,
I do have a user table with 38000 records. Now I would like to count the
female and male users.
This query:
SELECT sex, count(*) AS c
FROM user GROUP BY sex
works, but takes 0.8 s
So I don't think an index would do some good. There are only two values 1,
and 2
The column type is
Hi,
select table1.col_name FROM table1 left join table2
on table1.col_name = table2.colnmae where table2.clnmae is null
Rich
Inbal Ovadia wrote:
Hi
i want to do in mysql query like that:
SELECT col_name FROM table1 NOT IN (select col_nmae FROM tablse2)
how can i do that?
thanks
Hello
I can't create innoDB tables in db MySQL to do
rollback and commit
transactions.
I try to modify the my.cnf file with the instructions
that I find in manuel.pdf but it don't work.
Can you help me please ?
Thanks.
Ps : i'm french. :-)
Mark wrote:
Wednesday, May 22, 2002, 9:23:02 AM, louie wrote:
cut
Personally, I find the behavior of myisasmchk to be a bit beta when it
comes live tables. It would be real easy for myisasmchk to refuse to run
when mysqld is running. That should be a built-in precaution. I can
understand
Hi Egor,
Thanks for your reply.
What table was deleted? report_YYYMMDD?
Yes.
RV MySQL Log file says nothing.
Nothing about table delete or nothing about error?
Nope.
Robert Vetter
Internet Application Developer
Kontor23 GmbH
Ottenser Hauptstrasse 56-62
22765 Hamburg
Tel.: 040/380893-14
please let us know the SQL query you are trying, and a DESCRIBE TABLENAME so we can
see how your table(s) are laid out. also, please tell us what you actually changed
in your my.cnf file
by the way, before you can do transactions, you must set the AUTOCOMMIT variable to
0
-Ryan Hatch
a a
Hi,
Could anybody tell me why the following query does not work?
SELECT location FROM visiExPr where location=1 union (SELECT location FROM visiExPr
where location=0);
Thanks!
Dan
-
Before posting, please check:
i want to get really length of text field,but function
length() allways return 8,how can i get it with sql?
thanks.
__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
be aware... linux/unix table names are case sensitive. if you're using Win32 MySQL
on your system, the query might work, but on the ISP side, if it's a *NIX system...
you must have the correct capitalization.
moreover, if any of your variables contain a single quote character ( ' ), it will
I have been using .49 for well over 1 month now. Not sure how it was
corrupted but it happened. I followed the instructions with some
variation and was able to recover everything. In my.cnf I added '
set-variable = innodb_force_recovery=4'. I was then able to start the
database, and did a
Hi,
I'm running the following query:
Load data infile 'data.txt' into table records fields terminated by ';'
IGNORE 1 LINES
The field-order in my txt file is different than that in my table, can i
rearrange the order of the data being loaded and load blank fields in
between?
Any help will be
Description:
Given a table that has a timestamp field which is either the primary key or
one field in a multi-column primary key, the value in this field is
updated to the current time any time an SQL UPDATE is done, even
when the timestamp field is not intended
First question: did you set autocommit=0?
--Walt Weaver
Bozeman, Montana
-Original Message-
From: a a [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 9:27 AM
To: [EMAIL PROTECTED]
Subject: transactions on MySQL (innoDB)
Hello
I can't create innoDB tables in db MySQL to do
Hi,
Sometime when connecting to mysql I get
mySQL Error Code: (2003)
Can't connect to MySQL server on '127.0.0.1' (10061)
even when the server is up and running.
I think it might happen cause it is very busy.
I there a way to maybe make it wait longer for the client to connect?
Thanx
David,
if the corruption happens again, please run CHECK TABLE and report what you
get to 'hostname'.err. 3.23.52 will also contain diagnostic code which will
help to track the problem.
Best regards,
Heikki
- Original Message -
From: David Piasecki [EMAIL PROTECTED]
To: 'Heikki Tuuri'
Sub-selects are not permitted in MySQL yet..
See: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
Gurhan
-Original Message-
From: Dan Liu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 11:58 AM
To:
Subject: Union does not work
Hi,
Could anybody tell me why the
Greetings everyone,
I have an ASCII CSV or Tab Delimited file that is
roughly 3.5 gigabytes, and I want to load it into a mysql
database so I can do some analysis.
First of all, I'm wondering, is there anything I should be aware of,
or worried about, size-wise?
I know that I can't even look
Dan,
Wednesday, May 22, 2002, 6:57:49 PM, you wrote:
DL Could anybody tell me why the following query does not work?
DL SELECT location FROM visiExPr where location=1 union (SELECT location FROM
visiExPr where location=0);
DL Thanks!
What exactly doesn't work? Have you got an error or wrong
Hi,
Could somebody tell me what is wrong with this query?
select location from visiExPr where location=1 union (select location from
demandInfoAd where location=0);
ERROR 1064: You have an error in your SQL syntax near 'union (select location from
demandInfoAd where location=0)' at line 1
Hello,
I'm currently building a free mySQL database service. I have managed to
solve the quota problem with this list. Thanks to all!
Now I have another problem:
If a large number of databases have been created (1000) it takes some time
to change a database. I do know that I can ommit the
Hi!
On May 22, Victoria Reznichenko wrote:
Przemyslaw,
Wednesday, May 22, 2002, 2:02:52 AM, you wrote:
PP SELECT ISBN,TITLE FROM tBooks
PP WHERE tBooks.ISBN=1876340436
PP AND MATCH (tBooks.TITLE) AGAINST (britannica)
PP ++-+
PP | ISBN |
Hi,
Perhaps try to remove the brackets ?
SELECT location FROM visiExPr where location=1 UNION SELECT location FROM
visiExPr where location=0;
(I assume you're using MySQL 4.0.x ?)
Regards,
Jocelyn Fournier
- Original Message -
From: Dan Liu [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
In message [EMAIL PROTECTED], Dan Harrington write
s:
I have an ASCII CSV or Tab Delimited file that is roughly 3.5
gigabytes, and I want to load it into a mysql database so I can do
some analysis. First of all, I'm wondering, is there anything I
should be aware of, or worried about,
- Original Message -
From: Dan Harrington [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 22, 2002 5:41 PM
Subject: Loading massive data set from CSV
Greetings everyone,
I have an ASCII CSV or Tab Delimited file that is
roughly 3.5 gigabytes, and I want to load it into
I'm trying to install Bugzilla and according to the instructions you
have to make a few changes to MySQL and i'm a little confused. It says
that you have to add mysqld to init script and then add -0
max_allowed_packet=1M to the command that starts mysqld. I'm not
completely sure how to do
He is not doing a sub select...he is doing a union. Unions are
implemented in MySQL 4.x
HTH
Sam Masiello
Software Quality Assurance Engineer
Synacor
(716) 853-1362 x289
[EMAIL PROTECTED]
-Original Message-
From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002
I tried to create a password for the root user in a new installation of
MySQL by typing
% mysql -u root mysql
Then typing and update statement like
Update user set password = somepassword where user=root;
After doing this I typed because I could still get into mysql without a
password
%
The is the proper, documented functionality of the timestamp field. An
exerpt from http://www.mysql.com/doc/D/A/DATETIME.html is below:
The TIMESTAMP column type provides a type that you can use to automatically
mark INSERT or UPDATE operations with the current date and time. If you have
I searched the archive found the issue but not the answer.
Configuration:
I'm running win2000, mysql is loaded and I can manually create databases and
tables per MySQL manual (via Amazon). I've loaded samp_db in sub
directory of mysql.
Problem:
mysql samp_db create_president.sql;
Result:
Hi all,
What's the best way to store a numeric IP address into a table with the
least possible size and overhead on the mysql server?
I'm talking millions of records here With not one single duplicate IP
address (unique index)..
Currently, the database hosts just over 1.2 million unique
Hello,
I think that MAX_SLOW_QUERY_PER_HOURS is useful options for
GRANT ... WITH MAX_QUERIES_PER_HOUR = N1
MAX_UPDATES_PER_HOUR = N2
MAX_CONNECTIONS_PER_HOUR = N3;
statment.
Thank.
Best regards,
Andrew Sitnikov
e-mail :
I tried to create a password for the root user in a new installation of
MySQL by typing
% mysql -u root mysql
Then typing and update statement like
Update user set password = somepassword where user=root;
After doing this I typed because I could still get into mysql without a
password %
Description:
When using MySQL with InnoDB table type, and turning on the
table case-insensitivity flag in the config file
(set-variable = lower_case_table_names=1), MySQL/InnoDB does not
correctly handle the case-insensitivity of the target table name in
the REFERENCES part of the FOREIGN KEY
Sorry to jump into the conclusions:) IT wasn't evena sub select and union
is used to join the results of SELECT statements...
Your statement can be written as SELECT location FROM visiExPr WHERE
(location=1 OR location=0) GROUP BY location;
What version of MySQL are you running? UNION
Amy Zediak wrote:
I'm trying to install Bugzilla and according to the instructions you
have to make a few changes to MySQL and i'm a little confused. It says
that you have to add mysqld to init script and then add -0
max_allowed_packet=1M to the command that starts mysqld. I'm not
completely
Chris Knipe wrote:
I'm currently storing them into varchar(16), although I've been thinking of
doing it as for smallint columns, but then I can't be 100% certain I won't
get duplicates.
Why not? Just define a UNIQUE index across all four smallint columns,
and MySQL will throw an error if
If I understand correctly, you have to define a char field as binary if you want the
database to treat it as a 'case sensitive' field. Is there any way via a SQL query to
force case sensitivity to be used for a non-binary char field? i.e.: for comparing
strings in a case sensitive way. Or
Hi,
How should I setup MySQL development environment? We run MySQL from Sun
Solaris. I have a script file to create tables and load data which will
be distributed to all developers. The developer will own his set of
data where he is the only one who can modify it.
In Oracle, each user
Multiple subnets :/
columns like this:
octet1, octet2, octet3, octet4
195,196,192,23
232,196,231,11
This would then be seen as a duplicate
Kind Regards,
Chris Knipe
MegaLAN Corporate InterNetworking Services
Tel: +27 21 854 7064
Cell: +27 72 434 7582
- Original Message -
From: Myk
Nick,
You're going to be mostly out of luck.
You can ship a MySQL binary with a pre-configured config, and get the java
app to exec the binary, and send a shutdown command when it's finished.
Alternatively you can assist me in developing my Type II driver for MySQL,
then embed
Hi Richard,
Richard Bolen wrote:
If I understand correctly, you have to define a char field as binary if you want the
database to treat it as a 'case sensitive' field. Is there any way via a SQL query
to force case sensitivity to be used for a non-binary char field? i.e.: for
comparing
Hi!
The fact that foreign key definitions do not honor lower_case_table_names=1
is mentioned in the manual. I have added the fix to this on the TODO list
for July 2002.
You have found the right place, this mailing list is the right place to
report bugs in InnoDB.
Best regards,
Heikki Tuuri
Hopefully this is the right list. We have multiple servers going, and one
user just set up a dedicated machine with mysql. He had about 5 databases
going on another server for months with no problem. The new server has a
different version of mysql on it. I copied the database directories over
A colleague who is connecting to mysqld started as /u/local/mysql/bin/safe_mysqld
--user=mysql --safe-show-database --default-character-set=ujis -O
wait_timeout=$WAITTIMEOUT -O max_connections=$MAXCONNECTIONS has encountered the
following problem:
We could not add data which contains 0xADA1
Hello,
I think that MAX_SLOW_QUERY_PER_HOURS is useful options for
GRANT ... WITH MAX_QUERIES_PER_HOUR = N1
MAX_UPDATES_PER_HOUR = N2
MAX_CONNECTIONS_PER_HOUR = N3;
statment.
Thank.
Best regards,
Andrew Sitnikov
e-mail :
yes, you needed to use the PASSWORD( ) function
mysqladmin -h hostname -u user password 'new password'
-Ryan Hatch
Miretsky, Anya wrote:
I tried to create a password for the root user in a new installation of
MySQL by typing
% mysql -u root mysql
Then typing and update statement like
Hi,
I was converting my table from MyISAM to Innodb, but i had a trouble. I had
to kill an alter table command (It was an ADD INDEX in a DATETIME field) but
it didn't stop. So i restarted the mysql but the mysql starts only if i
disable innodb. Did i lost all my innodb tables? Is there
Hi!
Heikki == Heikki Tuuri [EMAIL PROTECTED] writes:
Heikki Andrei,
Heikki this is probably not a bug in InnoDB. In theory, 4000 random disk seeks
Heikki would use more time than scanning the whole table of 700 000 rows.
Heikki The optimizer was tuned .48 (not yet in 4.0.1) to favor index
On 22 May 2002, at 14:52, Richard Bolen wrote:
Is there any way via a SQL query to force case sensitivity to be
used for a non-binary char field? i.e.: for comparing strings in a
case sensitive way.
SELECT * FROM users WHERE BINARY password = 'cAsE_MAttErS';
you're not making much sense to me
in your first post... you wanted make sure every IP you have is unique, correct?
Do an ALTER TABLE with UNIQUE(octet1, octet2, octet3, octet4).
or am I not understanding your question?
Regards,
-Ryan Hatch
* remember me? yesterday #php on DALNet, G3X7
Hi all,
We need to prevent Dirty Reading.
How can we perform transaction isolation in mySQL? Are the following:
TRANSACTION_SERIALIZABLE, TRANSACTION_REPEATABLE_READ, TRANSACTION_READ_COMMITTED,
TRANSACTION_READ_UNCOMMITTED, TRANSACTION_NONE supported by MySQL? Or has anyone tried
any other
abw wrote:
Is it possible to zip up database directories on one server and move
them to another server, then simply unzip them?
Yes.
If so, once that is done, does something need to be done to mysql so
it is aware of the databases? Is there some file that has a list of
databases that
I am trying to compile a custom program I wrote some c++ wrapper classes
around the mysql c function. I have the mysqlclient_r lib installed in
/usr/local/lib/
ls -l /usr/local/lib/libmysqlclient_r.a
rw-r--r--1 root root 287356 May 22 13:28
/usr/local/lib/libmysqlclient_r.a
The
Hi there,
My Ibdatafile is set too big (the disk is full to the point that nothing is
executing properly) I am wondering is it safe to delete this file and then
in the my.cnf file reset the size to something smaller... - how does the
Ibdata file work in conjunction with mysql...
Will I lose data
And who said you ever get to old to learn :)
Never knew I could do unique indexes like this.. Definitely what I'm
looking for... Thanks guys :)
--
me
- Original Message -
From: Ryan Hatch [EMAIL PROTECTED]
To: Chris Knipe [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, May
Richard,
I will look at the UNION problem later.
I think MySQL uses a HEAP type temporary table when it calculates the UNION.
HEAP type tables are allocated from the main memory. The message 'Table is
full' tells that MySQL cannot allocate more memory.
Regards,
Heikki
Best regards,
1 - 100 of 144 matches
Mail list logo