MySQL Database Forum

Hello I have a table with an intger column called ID. I have an index on it. Now I want to get a result with all the rows whos ID values start with lets say 12....i.e. I want all the IDs with data - 12

I'm kind of new to MySql and I'm not aware all the softwares out there. I manage my DB on my local machine and update the server daily. Currently what I have to do is upload the entire DB in a .SQL file then execute. My updates are mainly additions, so this works. What I would like to do is process YesterdaysDB.SQL and TodaysDB.SQL to make...

I'm trying to do a lookup from a table where an ID number equals a name. But in selecting from three tables, I can't seem to figure out how to display the data in the fashion I need. In the first table (user_contact), I have contact info for each user and the user ID. In the second table (user_info), each user ID will have a primary genre,...

Good afternoon, I'm looking for information on good benchmarking implementations with which to test MySQL using multiple clients. The benchmark utilities included with MySQL are, as far as I understand, an implementation of the old Wisconsin Benchmark, and as such are designed to test only a single client sending queries to the database. ...

Hi, small but disturbing oddity, this. I have a simple table: CREATE TABLE musician ( musicianid int(10) unsigned NOT NULL auto_increment, name varchar(60) NOT NULL default '', PRIMARY KEY (musicianid) ) Type=MyISAM;

Good afternoon, I'm looking for information on good benchmarking implementations with which to test MySQL using multiple clients. The benchmark utilities included with MySQL are, as far as I understand, an implementation of the old Wisconsin Benchmark, and as such are designed to test only a single client sending queries to the database. ...

Since find_in_set only searches by a single string, like: find_in_set('a', 'a,b,c,d'); is there a way to achieve functionality like you would if find_in_set could search by multiple strings, such as: find_in_set('a,b,c', 'a,b,c,d'); This would return true if a OR b OR c were found in the set 'a,b,c,d'.

Hi, small but disturbing oddity, this. I have a simple table: CREATE TABLE musician ( musicianid int(10) unsigned NOT NULL auto_increment, name varchar(60) NOT NULL default '', PRIMARY KEY (musicianid) ) Type=MyISAM;

Since find_in_set only searches by a single string, like: find_in_set('a', 'a,b,c,d'); is there a way to achieve functionality like you would if find_in_set could search by multiple strings, such as: find_in_set('a,b,c', 'a,b,c,d'); This would return true if a OR b OR c were found in the set 'a,b,c,d'.

We've been using MySQLD for a few years now quite happily. It's amazing how well it performs. However, I have a minor issue, and I'm not sure how to deal with it. I've scoured the manual, searched list archives, the web, etc., and am coming up empty. Somehow, the server is recording the Binary log in the data directory. Each of these log...

I'm using Slackware GNU/Linux 9.0 on an Intel PII 266 machine that's SMP capable, but only with one CPU installed, and 64MB of RAM. It's basically a small test system that I play around with in some free time before installing things on my larger systems. I am trying to do a fresh install of MySQL 4.0.14 (I removed the previous 3.23.56...

We've been using MySQLD for a few years now quite happily. It's amazing how well it performs. However, I have a minor issue, and I'm not sure how to deal with it. I've scoured the manual, searched list archives, the web, etc., and am coming up empty. Somehow, the server is recording the Binary log in the data directory. Each of these log...

------=_NextPart_000_001C_01C355D3.9595F8C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable the configure command for courier-imap is the ff: ../configure --prefix=3D/usr/lib/courier-imap --with-authmysql = --without-pgsql --with-mysql-libs=3D/usr/local/mysql/lib =...

I'm using Slackware GNU/Linux 9.0 on an Intel PII 266 machine that's SMP capable, but only with one CPU installed, and 64MB of RAM. It's basically a small test system that I play around with in some free time before installing things on my larger systems. I am trying to do a fresh install of MySQL 4.0.14 (I removed the previous 3.23.56...

------=_NextPart_000_001C_01C355D3.9595F8C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable the configure command for courier-imap is the ff: ../configure --prefix=3D/usr/lib/courier-imap --with-authmysql = --without-pgsql --with-mysql-libs=3D/usr/local/mysql/lib =...

------=_NextPart_000_0011_01C355D2.C79798C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I installed the 4.1 alpha release, which I probably shouldn't have, but = I did because the 4.0 was giving me access denied error (before I found = your mailing list). However my problem got complicated...

------=_NextPart_000_0011_01C355D2.C79798C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I installed the 4.1 alpha release, which I probably shouldn't have, but = I did because the 4.0 was giving me access denied error (before I found = your mailing list). However my problem got complicated...

For the last four hours or so, I've been waiting for MySQL (4.0.12 on W2K) to complete a shutdown. The fast shutdown flag is not set (innodb_fast_shutdown=0), so I assume it is doing a purge and merge... but in the meantime, I don't have any access to the server -- clients simply can't connect. This is a real problem, since it renders the...

Hello, DB novice checking in here with a basic design question. I have a table called 'nms_apps' which stores information about all of our applications which we have developed/maintained for our client. One column which I would like to use is called 'used_by', which would store information about which business sections (Financial...

Hello, DB novice checking in here with a basic design question. I have a table called 'nms_apps' which stores information about all of our applications which we have developed/maintained for our client. One column which I would like to use is called 'used_by', which would store information about which business sections (Financial...

For the last four hours or so, I've been waiting for MySQL (4.0.12 on W2K) to complete a shutdown. The fast shutdown flag is not set (innodb_fast_shutdown=0), so I assume it is doing a purge and merge... but in the meantime, I don't have any access to the server -- clients simply can't connect. This is a real problem, since it renders the...

Hi, When installing the mysql4 binary it works fine. When installing the mysql max4 binary I get the following message when I try to run mysqld_safe. I am running linux redhat 9.1. Would anyone know why this is happening? 030728 23:54:57 mysqld started 030728 23:54:58 bdb: /usr/local/mysql/data/log.0000000001: Permission

------=_NextPart_000_0013_01C352C0.6B0A6E30 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi All, Is it possible in MySQL to use UPDATE to update fields in one table = with data from another table? For example, the following code seems to be the answer but fails with a syntax error in MySQL:

Hi, When installing the mysql4 binary it works fine. When installing the mysql max4 binary I get the following message when I try to run mysqld_safe. I am running linux redhat 9.1. Would anyone know why this is happening? 030728 23:54:57 mysqld started 030728 23:54:58 bdb: /usr/local/mysql/data/log.0000000001: Permission

Hi, i am really new to mysql so plz dont hit me if i am wrong. Here the problem: i have 2 tables. Voters(IP,Maprated) Maps(Name,Info)