MySQL Database Forum

I need to query multiple (15) tables to build a data entry screen. Is better to create 15 separate SELECT statements and query each table independently or create 1 large SELECT and query one time? Thanks!

Hi , i am reading 1000 Elements from a database (500.000 all together). The problem is reading the data takes only a few miliseconds but closing the ResultSet takes another 22 seconds. My Hard Disk tells me that the ResultSet is probably running to the end of my table row by row. Is there a way to tell mysql not to do this ? Statement...

I am getting the following error after trying to flush the master: mysql> flush master; ERROR 1186: Binlog closed, cannot RESET MASTER I am using mysql Ver 12.20 Distrib 4.0.13, for sun-solaris2.9 (sparc) Does anyone know what this might be? Thank you in advance,

Hi , i am reading 1000 Elements from a database (500.000 all together). The problem is reading the data takes only a few miliseconds but closing the ResultSet takes another 22 seconds. My Hard Disk tells me that the ResultSet is probably running to the end of my table row by row. Is there a way to tell mysql not to do this ? Statement...

I am getting the following error after trying to flush the master: mysql> flush master; ERROR 1186: Binlog closed, cannot RESET MASTER I am using mysql Ver 12.20 Distrib 4.0.13, for sun-solaris2.9 (sparc) Does anyone know what this might be? Thank you in advance,

Hi folks I have a strange problem. My server load goes up to 100 and I don´t know why. What I know, if I shot down the site, the server calms down and it works again. I have figured out that i have a mysql problem but I can t figure it out. Is it possible to log all MySql Statements which are running on my database ? If the server goes...

Hi folks I have a strange problem. My server load goes up to 100 and I don´t know why. What I know, if I shot down the site, the server calms down and it works again. I have figured out that i have a mysql problem but I can t figure it out. Is it possible to log all MySql Statements which are running on my database ? If the server goes...

What's wrong with the following query? The application used to use Access via ODBC, now running MySQL 3.23.xx, MyISAM table, accessed via MyODBC 3.51.01. // Return last 20 searches SELECT TOP 20 h.historyid, h.searchstring, h.serverid, s.shortname FROM history h INNER JOIN servers s ON h.serverid = s.serverid WHERE h.employeeid = 9 ORDER...

I can't use it....for example i have to create a column that accept values between 1 to 120...i can't enumerate all of them....or i have to accept a value different from NULL if an other column has a certain values, otherwise the first must be NULL, it's impossible to use enum to do this! ----- Original Message ----- From: "Michael Brunson"...

I can't use it....for example i have to create a column that accept values between 1 to 120...i can't enumerate all of them....or i have to accept a value different from NULL if an other column has a certain values, otherwise the first must be NULL, it's impossible to use enum to do this! ----- Original Message ----- From: "Michael Brunson"...

Quick one... is this program just for Linux? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@freebsd.csie.nctu.edu.tw

Quick one... is this program just for Linux? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@freebsd.csie.nctu.edu.tw

Hi, Can anyone point me to a resource which details the process of compiling mysql server with openssl support on windows using VC++ preferable? If not, maybe someone has run across this problem and can provide a solution. I have added HAVE_OPENSSL and HAVE_VIO to the preprocessor definitions and added the libeay32.lib and ssleay32.lib to the...

Hi, Can anyone point me to a resource which details the process of compiling mysql server with openssl support on windows using VC++ preferable? If not, maybe someone has run across this problem and can provide a solution. I have added HAVE_OPENSSL and HAVE_VIO to the preprocessor definitions and added the libeay32.lib and ssleay32.lib to the...

i cannot set auto_increment to start from anything other than 1: mysql> create table test (id int unsigned not null auto_increment primary key); mysql> alter table test auto_increment=2; mysql> insert into test() values(); mysql> select * from test; +----+

Im trying to install snort and the installation calls for the location of the mysql.h header file. Ive tried what I think are the default locations, and if I run a locate nothing turns up. I have rh9 with the mysql package installed, and im trying to compile snort 2.0 thanks

i want to update every row in the mysql table that matches a part of each row in it. ie. for example if a table contains the following rows : Pid: 21577 PPid: 21174 Uid: 501

------_=_NextPart_001_01C34AA5.FB3F7C7A Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi listers i've upgraded my mysql env from 3.23.53 to 4.0.13. also, i changed os = from m$ to rh 7.3. what did not change was h/ware.=20

Hi guys, I need some help with this. I have the following 3 tables. +------+-------+ | uid | name | +------+-------+ | 100 | sue | | 102 | harry | | 104 | louis |

Database mysql running on localhost Error The additional Features for working with linked Tables have been deactivated. To find out why click here. -> Database mysql running on localhost PMA Database ... not OK General relation features Disabled

Hi all, I have run into a bit of a problem. I recently setup mysql to run on a Debian Linux box I setup. I am by no means an expert on either linux or mysql. I know enough to just be dangerous. =) I had it set up so I could read and write to the database through my perl code, connect with phpmyadmin, etc. Not one to be happy I attempted...

Database mysql running on localhost Error The additional Features for working with linked Tables have been deactivated. To find out why click here. -> Database mysql running on localhost PMA Database ... not OK General relation features Disabled

The sales team are down ? I'm trying to order MySQL-PRO licences and the team not return my emails... i trying with sales@mysql.com and gerardo@sales.com gerardo is out ? this is my contact in MySQL AB :((((

Hi, I need some advice. I've a program running on a local machine which automatically pushes images from a camera to our webserver (linux/mysql) through FTP. I want to store those images in the database so I think I need some perlscript running as a deamon that looks for new incoming images. I tried to find a script which does the job but...

We've recently enabled slow query logging on a server and it's proving interesting seeing which queries are bogging things down. This one is puzzling me a little: SELECT articleid, type, authorid, authorname, text, posted FROM comments WHERE status = 'normal' ORDER BY posted DESC LIMIT 5; The purpose of this query is to list the five...