Hi Peter,
I just tried it on a table with 10 rows and it works fine on 4.0.15.
Have you already tried on a small table?
How many rows is your WHERE clause matching when it's not using the
index? Do you know that MySQL won't use an index if it thinks it will
find more than about 30% of all rows?
Hello,
I got Lost connection to MySQL server during query from time to time when
connecting to MySQL server.
Using following PHP code,
$this - conn = mysql_connect( $host,
$c_user,
$c_passwd) ;
if(
Hi!
I'm having a strange problem - I can't read data using the
mysql -u root -p databasepath/to/whatever.sql
Not getting any error message, but some kind of introduction text
flashes by reading:
[powerbook:~] victor% /usr/local/mysql/bin/mysql -u root -p *** databas
Hi Jordan
Have had a look at the date input page, and the source code that it produces
looks fine. If you still haven't sorted it out could I suggest the
following:
Output the tenure date at the following points in the application:
1) When it is returned by the input form.
2) When it is
if you are using mysql on web (which is the most possible case, as MySQL is
created to be used on web), you can use your scripts to create tamporary
tables and use them as views. else you can write procedures for that
purpose, depending on your need.
Nitin
- Original Message -
From:
Sorry for wrong answer, actually, that's the behavior of oracle query cache,
so I guessed it would be same for MySQL too. I sincerely apologize for any
inconvenience caused.
Nitin
- Original Message -
From: Dan Nelson [EMAIL PROTECTED]
To: Nitin [EMAIL PROTECTED]
Cc: Reto Baumann [EMAIL
Dicky 'Mas Saint' wrote:
Hi !
Does anybody have experience running MySQL with OpenMosix ?
How is the performance increase ?
Thank you.
According to this paper:
Victor Sp?ng Arthursson [EMAIL PROTECTED] wrote:
Hi!
I'm having a strange problem - I can't read data using the
mysql -u root -p databasepath/to/whatever.sql
Not getting any error message, but some kind of introduction text
flashes by reading:
[powerbook:~] victor%
I'm not talking about storing data into temporary tables for ever, but for
the better accessibility inside the scripts. As anyway after the connection
to your MySQL server is closed, temporary tables no more remain there. So
you can just use those tables from within a single script, to help you
Hi
- Original Message -
From: Nitin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, October 13, 2003 10:42 AM
Subject: Re: Views in MYSQL
I'm not talking about storing data into temporary tables for ever, but for
the better accessibility inside the scripts.
then who said, you cant delete temporary tables
Nitin
- Original Message -
From: [EMAIL PROTECTED]
To: Nitin [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Monday, October 13, 2003 3:22 PM
Subject: Re: Views in MYSQL
Hi
- Original Message -
From: Nitin
Hi There,
i tried to load a big file into a MySQL table using LOAD DATA LOCAL INFILE ...
Everything worked fine but after about 2 hours it say:
Lost connection to MySQL- server during query
The server was allwaiys up and I don't have a clue what happend.
I thought, that maybe our intranet was
did you install your debian with bf24 option??? it´s a kernel 2.4
instalation... in my debian woody 4.0 is very goodmysql 4.0 is ok!
BOA SORTE!!!
---
Gustavo Polillo Correa - Analista de Sistemas
Instituto de Biociencias - USP
Sao Paulo
Hello,
I would like to examine with as much detail as possible the following
aspects of my queries:
- Hows the total execution time distributed between disk reads / writes
and cpu / memory usage?
- Hows the total execution time distributed between index search and
actually reading data?
-
Hello,
I'm experimenting with a large table (currently 9.7 M rows / 500 MB disk
space) that stores measuring results and I sometimes (!) get slow
queries for no good reason. The table looks like this:
++
| values |
++
| int (11)
Hi Group,
I am wondering whether MySQL is planning to implement Group based privileges.
To make my question clear, consider a database where some users are not allowed to
update data and other are allowed to update. Will it be possible to create a group
that has got some privileges and whenever
-p without the passwd immediately following is not compatible with
input redirection.
Either add the password after the -p with NO space, or better yet,
create a .my.cnf file in the home directory of the user running the script
and have it contain the user and password settings.
Victor Spång
At 02:55 PM 10/11/2003, cppaddict wrote:
Hi,
I'm just starting out with mysql and would like to know if there are any good
database diagramming and development tools for mysql. Something that would
allow me to create a db and all the relationships graphically and then
have the
sql code
Hi! I'm going to use the fulltext index in an multilingual product and need to
modify/translate the stopword list. According to the documentation:
The stopword list can be loaded from the file specified by the ft_stopword_file
variable. See section 4.5.7.4 SHOW VARIABLES. Rebuild your FULLTEXT
That wouldn't work because for example:
GMT day for 2003-10-13 = '2003-10-13'
EDT day for 2003-10-13 = GMT '2003-10-12 20:00:00 - 2003-10-13
20:00:00'
I want the GROUP BY (adjusted to EDT) to show 2003-10-13, but it shows
2003-10-12 know what I mean?
I don't know how to work around this...
A group_id cannot be both 1 AND 3, but it can be 1 OR 3.
Try OR
Jouni Hartikainen wrote:
Hi.
how about:
select record.*
from link
where group_id='x'
left join record on record.archive_id=link.archive_id
?
The problem with this query is that with simple left join, I can
search only by
When I try to execute grant all on *.* to stw where stw is my user name, I get an
error 1045 (Access denied for user: '@127.0.0.1' (Using password: NO).
Is there a way to check for user datas ? Or how to resolve this problem ?
Stephan Wölfel
Stephan -
Connect to MySQL via a shell or command-line, change to the mysql
database with
use mysql;
...then query the user table:
select * from user
Also, to connect to the database server as a specific user, you'll need
to enter
mysql -u stw
or
mysql -u stw -p
...if you specified a
1. The command is not properly formed.
2. You don't have grant privileges.
3. Run this as the mysql root user.
Stephan Wölfel wrote:
When I try to execute grant all on *.* to stw where stw is my user name, I get an error
1045 (Access denied for user: '@127.0.0.1' (Using password: NO).
Is there a
I'm not clear on this. What happens to duplicates under the following
scenario?
MyISAM table with either (or both!) a primary key or a unique index.
Alter table my_table disable keys.
Import 200K records.
Alter table my_table enable keys.
But it turns out there are duplicate records. Does MySQL
Hi,
- Original Message -
From: [EMAIL PROTECTED]
To: Nitin [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Monday, October 13, 2003 5:52 AM
Subject: Re: Views in MYSQL
much cut
What about when the script uses persistent connections, these Temp
Tables
would never go away
Hi Jim,
thanks for the advise.
What you tell all works. But even after this I still get the same error 1045
when typing grant all on *.* to stw. Why ?
Stephan
- Original Message -
From: James Cradock [EMAIL PROTECTED]
To: Stephan Wölfel [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent:
Thanks for the advise.
However I have some additional questions:
ad 2) How can I check the grant privileges ?
ad 3) How can I run this as the mysql root user ?
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Stephan Wölfel [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent:
Stephan -
Gerald posted good instructions for doing proper privileges, but: Login
as root, and execute this command:
GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'yourpassword';
This will apply permissions for user stw from host 127.0.0.1. You'll
need a password to login. Run:
mysql
Hi.
I am trying to change the timezone for MySQL (version 3.23.56) but it does
not seem to work.
Currently the timezone is set to MDT (I think its the default for MySQL).
I added the following line to /etc/my.cnf at the [mysqld] section:
set-variable = timezone=CST
But when I try to stop and
Hi,
I am using these lines in my.cnf at [mysqld_safe] section.
[mysqld_safe]
timezone = GMT
It works fine for me.
Best regards,
Mikhail.
- Original Message -
From: Juan Antonio Ruiz Zwollo [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 13, 2003 5:38 PM
Subject: Setting
Thank you for the answer but it seems you didn't understand my question.
I was not asking about windows users.
I may reformulate my question as follows:
1. suppose you have a database that will be accessed by both students and
their teachers for different works
2. you understand that students
Stephan Wölfel wrote:
Thanks for the advise.
However I have some additional questions:
ad 2) How can I check the grant privileges ?
ad 3) How can I run this as the mysql root user ?
mysql -u root -p
enter the root password you set when you installed mysql
use mysql
enter the grant command.
At 17:56 +0200 10/13/03, Director General: NEFACOMP wrote:
Thank you for the answer but it seems you didn't understand my question.
The question is clear.
The answer is you cannot do that and the reason is because MySQL's
access control system doesn't work that way. There is the concept of
user
how to delete rows which table1.field=table2.field
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
bonjour,
nous souhaitons que des utilisateurs munient de pocket pc puissent accéder à une base de donnée mysql stocké sur un serveur en nos locaux. Pour cela nous souhaitons envoyé une commande à partir de Visual Basic (embedded).Existe-t-il des commandes adapter pour cela ?
Merci
Would that be are there mySQL drivers for use on packet pcs with VB?
- Original Message -
From: scr informatiques
To: [EMAIL PROTECTED]
Sent: Monday, October 13, 2003 4:57 PM
Subject: connexion avec un pocket pc
bonjour,
nous souhaitons que des utilisateurs
Hello everybody:
I have the following scenario:
I have a database of products, each of those products have a product number
(like 04543000). Now the first five digits represent the product number, and
the 2 following digits represent a differet color for the same product.
Bonjour Frédéric,
Ce liste est en anglais. Je crois que tu veux http://www.vbmysql.com . Mais le
site est en anglais. Il y a beaucoup de exemples de VB 6 et VB .net sur ce site.
En plus il existe un liste français à (mais il y a récemment beaucoup de silence) :
Liens utiles :
Poster un
SELECT DISTINCT(LEFT (product_number,5)) FROM products.
http://www.mysql.com/doc/en/String_functions.html
hth
Jeff
Personal
http://www.mysql.com/doc/en/DELETE.html
and from that page:
DELETE t1,t2 FROM t1,t2,t3 WHERE t1.id=t2.id AND t2.id=t3.id
or
DELETE FROM t1,t2 USING t1,t2,t3 WHERE t1.id=t2.id AND t2.id=t3.id
In the above case we delete matching rows just from tables t1 and t2.
From MySQL 4.0, you can specify
Thank you!!!
It works.
Hector
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 13, 2003 1:44 PM
To: Personal
Cc: [EMAIL PROTECTED]
Subject: Re: SELECT DISTINCT question
SELECT
How, in a sql script, do I gracefully fail an insert? For example, I
insert a record that has an primary key of 1, and it already exists. I
want my script to
Move down to the next record, not fail out. Thanks!
dan
At 13:44 -0500 10/13/03, dan orlic wrote:
How, in a sql script, do I gracefully fail an insert? For example, I
insert a record that has an primary key of 1, and it already exists. I
want my script to
Move down to the next record, not fail out. Thanks!
If you're executing the script with the
# if using perl and DBI pseudo code
die $ERROR if ($dbh-errstr() $dbh-errstr() !~ /Duplicate Error/);
If $dbh-errstr() =~ /Duplicate Error/
do your specified logic
Else
Return inserted id
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
-
Hi, I'm populating a dropdown with table names so the user can then choose the table
he/she wishes to
edit. However I just want to show the lookup tables. I tried show tables from DB
where table like 'lkp' ;
but got an error; I'm just wondering whether it can be done using show tables or
I'm currently writing a program that will make use of the SHOW CREATE TABLE
statement to verify that existing tables are correct (if not, it drops them
and recreates). Why is it though that the SHOW CREATE TABLE statement
returns the answer on multiple lines? Why not just one line? And is it
When I start MySQL with mysql -u root -p I get again the error 1045
(Access denied for user: '[EMAIL PROTECTED]' (Using password: YES).
What am I doing wrong ?
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Stephan Wölfel [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent:
You are not entering the right password.
If you did NOT set a password for root, then leave the -p option off.
Stephan Wölfel wrote:
When I start MySQL with mysql -u root -p I get again the error 1045
(Access denied for user: '[EMAIL PROTECTED]' (Using password: YES).
What am I doing wrong ?
At 14:48 -0500 10/13/03, Adam Clauss wrote:
I'm currently writing a program that will make use of the SHOW CREATE TABLE
statement to verify that existing tables are correct (if not, it drops them
and recreates). Why is it though that the SHOW CREATE TABLE statement
returns the answer on multiple
Robert Morgan [EMAIL PROTECTED] wrote:
Hi, I'm populating a dropdown with table names so the user can then choose the table
he/she wishes to
edit. However I just want to show the lookup tables. I tried show tables from DB
where table like 'lkp' ;
but got an error; I'm just wondering
Well the issue wasn't so much with my program at runtime, but at design time
(now). What I am doing is hardcoding the string that creates the table into
the program. Program then calls SHOW CREATE TABLE and compares the two
strings to see if they are the same. If not, it drops and recreates.
On 13 Oct 2003 at 16:59, Adam Clauss wrote:
Well the issue wasn't so much with my program at runtime, but at
design time (now). What I am doing is hardcoding the string that
creates the table into the program. Program then calls SHOW CREATE
TABLE and compares the two strings to see if they
Hi Peter,
I don't know what your multiple languages are, but remember that
full-text indexing doesn't currently work with multi-byte character
sets.
Anyway, the built in stopword list is in the myisam/ft_static.c file
of the source code. This is mentioned in the manual for SHOW VARIABLES:
Hi Randy,
Unique keys are not disabled with DISABLE KEYS -- so the unique
constraint isn't violated. From
http://www.mysql.com/doc/en/ALTER_TABLE.html
ALTER TABLE ... DISABLE KEYS makes MySQL to stop updating *non-unique*
indexes for MyISAM table.
Matt
- Original Message -
From:
cppaddict wrote:
Hi,
I'm just starting out with mysql and would like to know if there are any good
database diagramming and development tools for mysql. Something that would
allow me to create a db and all the relationships graphically and then have the
sql code automatically produced. Ideally
As an interesting note... I recently moved one of my legacy databases from
SQLSVER7 onto my production mySQL server.
It took 10min.
Well, ok, maybe a bit longer... but my buddy, wonderful godlike java geneous
that he is wrote an applet that will move all the data over from SS7 to
mySQL without
Hi,
Do you use version 4 or 3?
I am using version 4.0.14.
I thought that I need to use
set-variable = timezone = CST for it to work under MySQL 3.
MySQL docs:
...set-variable = variable=value
This is equivalent to --set-variable variable=value on the command-line.
Please note that
At 1:25 +0200 10/14/03, Mikhail Entaltsev wrote:
Hi,
Do you use version 4 or 3?
I am using version 4.0.14.
I thought that I need to use
set-variable = timezone = CST for it to work under MySQL 3.
MySQL docs:
...set-variable = variable=value
This is equivalent to --set-variable variable=value
[EMAIL PROTECTED] wrote:
how to delete rows which table1.field=table2.field
thanks
delete t1 from t1,t2 where t1.field=t2.field
at least, that's how I read the manual. Works for me.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I am running mysql through a pipe with flags
-s -n -R -r
which works fine except a pipe read hangs when there is no data for a query. I
tried many things, nothing works.
Running on Linux with version 3.23,53
Thanks
Matt Young
--
MySQL General Mailing List
For list archives:
The Uscript concept is worth a short look.
Recently I discussed a new lightweight middleware for the web called Uscript.
I have the system up and running with help and information pages at
http://12.234.12.151/cgi-bin
my home computer. I will try to keep the system up during the day for those
Pls help me guys.
what's wrong with this command ?
select a.siswa_id,a.nama,b.Nilai from Query_DataSiswa a left join ( select
siswa_id,Nilai,Tes_Id from Nilai_Harian where tes_id = 1 and pertemuan = 1 and
paket_id = 1 and tingkat = 1) b on a.siswa_id = b.siswa_id where a.paket_id = 1 and
Timotius Alfa wrote:
Pls help me guys.
what's wrong with this command ?
select a.siswa_id,a.nama,b.Nilai from Query_DataSiswa a left join ( select siswa_id,Nilai,Tes_Id from Nilai_Harian where tes_id = 1 and pertemuan = 1 and paket_id = 1 and tingkat = 1) b on a.siswa_id = b.siswa_id where
It works on small tables fine. However when entries grow somewhere over 20 000 it
stops (a rough estimate, did not test for
the exact number). When I have for say 80 000 and have a select returning 2 000
entries it still doesn't work right.
I don't quite understand the cardinality value, at
The manual says:
For example, if the library is installed in `/usr/local/mysql/lib', use
-L/usr/local/mysql/lib -lmysqlclient -lz on the link command.
But I found no z library?
Matt Young
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Is it possible to direct xml support for queryiing a SQL statement and
get the result in also in xml?
Prasad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I dont know about going in, but i wonder if there is an extension module to
do this for you. I currently have to use a class i built to extra the xml
from a query in php :\
Is it possible to direct xml support for queryiing a SQL statement and
get the result in also in xml?
Prasad
--
68 matches
Mail list logo