Underscore functions as a wildcard ?

the question: is this correct or is this something that should not be? Kind regards, Jeroen Bosch

'ERROR 1045 (28000): Access denied' when trying to LOAD DATA INFILE.

I do/am I doing wrong? [EMAIL PROTECTED] jeroen]$ uname -rs Linux 2.4.21-4.EL [EMAIL PROTECTED] jeroen]$ ssh [EMAIL PROTECTED] Password: [EMAIL PROTECTED] ~> uname -rs FreeBSD 5.3-RELEASE [EMAIL PROTECTED] ~> mysql -V mysql Ver 14.7 Distrib 4.1.10, for portbld-freebsd5.3 (i386)

removing duplicates and giving average of other field.

Hi again, thanks for the quick reply on my previous question, the solution given by Michael Stassen worked like a charm. But now I've again run into a situation where I'm stuck with my limited knowledge of MySQL. Given the table: mysql> select * from g2d; +---+--+--+--

combining information from 4 tables into a fifth.

Hey all, I've three tables (g2d, dgp and pocus), with a gene-name, a score and some other information: mysql> select * from dgp; ++---+--+--+++ | chr| start | stop | gene_name | score

Need help with indexing !

Using mysql 3.23.53, i have a table with approx 1.000.000 records, and only 3 columns. One of these (called 'value') is usually between 50 and 150 characters, but occasionally jumps to a current maximum of 570 characters, so I figured I had to go for the TEXT type. now I tried to add an index o

Indexing a TEXT column

Using mysql 3.23.53, i have a table with approx 1.000.000 records, and only 3 columns. One of these (called 'value') is usually between 50 and 150 characters, but occasionally jumps to a current maximum of 570 characters, so I figured I had to go for the TEXT type. now I tried to add an index o

placing the OMIM database locally

you point me to a place where I can find this information? Thanks in advance, Jeroen Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- MySQL General M

RE: PHP + MySQL, how to get total rows matched when using LIMIT 0, 10?

et without the limit OR make use of count(*) and parse the result of count. Since it only returns 10, it's correct the the total matched rows is 10. sql query Regards, Jeroen Geusebroek - Before posting, please chec

RE: phpmyadmin

If you are worried about security, don't run IIS! Now, that's insecure! Use Apache, this also runs fine on windows. PHP is as insecure as own programming is. If you program securely then so is PHP. My 2 cents. -Original Message- From: John Chang [mailto:johnec@;umich.edu] Sent: vrijdag

RE: Mysql Innodb performance slow

why the isam table takes about 100 seconds for inserting 160K rows, while innodb takes 700 seconds. (using individual inserts) Thanks, Jeroen > -Original Message- > From: Jeroen Geusebroek [mailto:j.geusebroek@;infraxs.com] > Sent: Friday, October 25, 2002 3:11 AM > To

RE: Performance over a network

client or the other way around and see what the transfer rates are. Jeroen -Original Message- From: Brent Baisley [mailto:brent@;landover.com.] Sent: Friday, October 25, 2002 9:20 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Performance over a network It would be helpful to

Mysql Innodb performance slow

thing I should keep in mind when migrating? Kind regards, Jeroen Geusebroek - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: need urgent help recovering after renistall (pleeeease !)

y that errno 13 means a permission issue. a straight sudo chown -R mysql /usr/local/mysql/* solved everything. - Original Message - From: "jeroen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, October 06, 2002 9:23 AM Subject: need urgent help

Re: need urgent help recovering after renistall (pleeeease !)

Okay, I'm very sorry for bothering you all with this. If I had not panicked, I probably would have found it myself. - Original Message - From: "jeroen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, October 06, 2002 9:23 AM Subject: need u

need urgent help recovering after renistall (pleeeease !)

R 1017: Can't find file: './ETL/reeksen.frm' (errno: 13) even though the file is there : [juturnas-Computer:mysql/data/ETL] jeroen% ls -l total 200 -rwxrwxrwx 1 mysql wheel 476 Jul 8 16:27 auteurs.MYD -rwxrwxrwx 1 mysql wheel 2048 Jul 8 16:27 auteurs.MYI -rwxrwxrwx 1 mysql

lowercase table names on win2000 platform / uppercase on linux platform

win2000 platform, but on the linux platform it is. My question to the list is: Is there an easier way to change the table names back to uppercase then just do it manually. For the dump I used: mysqldump --opt > dump.sql And for the reload: mysql < dump.sql Regards, Jeroen van

libmysqld

Hi, Can anyone tell me how i get a win32 mysql embedded library? Thanks, Jeroen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

RE: Fulltext again

Hi, >May be because your LIKE query finds also >'something will not shed any light on this!!!' That's what i though just after posting this to the list. When is the phrase support planned to be inserted in MySQL 4? That would be a very nice featu

Fulltext again

dex word less then 2 characters, instead of the standard 4 characters. The fulltext index is up-to-date. What could be the problem? Thanks, Jeroen - Before posting, please check: http://www.mysql.com/manual.php (the manual

Fulltext question

uot;'+this +is +a +test'");" but this returns, all records which have "this" "is" etc. but not the phrase. Thanks for the advice, Jeroen - Before posting, please check: http://www.mysql

Re: The opposite of where column_name LIKE "%string%"

ect * from table_name where column_name like "%my_string%". try this: select * from table_name where column_name NOT like "%my_string%" hth, Jeroen - Before posting, please check: http://www.mysql.com/man

Sudden performance drop on insert/update operations

ccurs again... Is mysql doing some automatic maintenance or something else? Help in giving an explanation for this behaviour is much appriciated. Greetings, Jeroen. - Before posting, please check: http://www.mysql.com/manua

Re: Building/installing MySQL under Mac OS X 10.03

PS : here's my versionnnumber : mysql> SHOW VARIABLES LIKE "version"; +---+-+ | Variable_name | Value | +---+-+ | version | 3.23.37 | +---+-+ 1 row in set (0.00 sec) --

Re: Building/installing MySQL under Mac OS X 10.03

I don't understand how yuo can have so much trouble building it ! I just downloaded the latest stable release, unzipped it, and did ./configure make make install mysql_install_db safe_mysqld & and it went hoopla running ! (after almost half an hour compiling that is) --

newbie Q : importing with accents

Hi all I'm using mySQL/PHP on a macOSX machine and found myslf in trouble while trying to import data from our filemaker pro database. I export from filepaker as comma delimited and then import using the LOAD DATA INFILE. This works like a charm, but all the accents get imported incorrectly.