MySQL Database Forum

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...

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

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"...

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"...

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...

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,

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 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):

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!

------=_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_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_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

Hello group, For everyone who thinks about moving from MySQL to PostgreSQL I have a realy bad news - It's not worth. Why, You may ask... A few days ago I have installed and tested PostgreSQL, becouse I realy need UTF-8 support and subselects. I thought that PostgreSQL will be as good as MySQL but also will give me that features, which aren't...

------_=_NextPart_001_01C34A01.33763174 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable The MySQL manual mentions that one could specify the column and value = separators and the end of file marker explicitly in the LOAD DATA = statement. =20 I'm looking for the syntax of this statement to...

Hello group, For everyone who thinks about moving from MySQL to PostgreSQL I have a realy bad news - It's not worth. Why, You may ask... A few days ago I have installed and tested PostgreSQL, becouse I realy need UTF-8 support and subselects. I thought that PostgreSQL will be as good as MySQL but also will give me that features, which aren't...

------_=_NextPart_001_01C34A01.33763174 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable The MySQL manual mentions that one could specify the column and value = separators and the end of file marker explicitly in the LOAD DATA = statement. =20 I'm looking for the syntax of this statement to...

------_=_NextPart_001_01C349FB.3DE177A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable g'day listers i run a mysql 4.0.13 master and slave on linux rh 7.3 servers. every now = and then i get a error on the slave. the error is that it cannot insert = data into a table that does not exist. the...