MySQL Database Forum

------=_NextPart_000_0019_01C2D0F9.BFBD6610 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hello There, I try to compiling Mysql V4.0 in the Alpha/Tru64 Unix V5.1a. I have installed in the Alpha C++ and C version 6.5, and gcc 3.3 and GNU MAKE 3.8.

------_=_NextPart_001_01C34A15.850E4CF5 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Does mysqlhotcopy work with innoDB? I only get it to work with MyISAM tables... For innoDB only the structure is saved but not the data =20 Thanks for some answers, Moritz

------=_NextPart_000_0019_01C2D0F9.BFBD6610 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hello There, I try to compiling Mysql V4.0 in the Alpha/Tru64 Unix V5.1a. I have installed in the Alpha C++ and C version 6.5, and gcc 3.3 and GNU MAKE 3.8.

Hello all, Is it possible to LEFT JOIN a table to itself? I want to see all records in a table where the year of the sales date is 2003 and where the salesman sold an item to a customer to which he did not sell that item to in 2002. The following is an example table (SALES):

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!

Hello all, Is it possible to LEFT JOIN a table to itself? I want to see all records in a table where the year of the sales date is 2003 and where the salesman sold an item to a customer to which he did not sell that item to in 2002. The following is an example table (SALES):

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 |