| |
thread by: julio |
last post Jul 19 '05 by: julio
------=_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.
|
thread by: Moritz Steiner |
last post Jul 19 '05 by: Moritz Steiner
------_=_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
|
thread by: julio |
last post Jul 19 '05 by: julio
------=_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.
|
thread by: Charles Haven |
last post Jul 19 '05 by: Charles Haven
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):
|
thread by: Michael roedig |
last post Jul 19 '05 by: Michael roedig
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!
|
thread by: Charles Haven |
last post Jul 19 '05 by: Charles Haven
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):
|
thread by: Michael roedig |
last post Jul 19 '05 by: Michael roedig
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!
|
| |
thread by: Daniel Schneller |
last post Jul 19 '05 by: Daniel Schneller
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...
|
thread by: Leo Genyuk |
last post Jul 19 '05 by: Leo Genyuk
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,
|
thread by: Daniel Schneller |
last post Jul 19 '05 by: Daniel Schneller
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...
|
thread by: Leo Genyuk |
last post Jul 19 '05 by: Leo Genyuk
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,
|
thread by: Niels |
last post Jul 19 '05 by: Niels
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...
|
thread by: Niels |
last post Jul 19 '05 by: Niels
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...
|
thread by: Jim McAtee |
last post Jul 19 '05 by: Jim McAtee
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...
|
thread by: Alex82 |
last post Jul 19 '05 by: Alex82
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"...
|
| |
thread by: Alex82 |
last post Jul 19 '05 by: Alex82
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"...
|
thread by: Michael G. Tracey |
last post Jul 19 '05 by: Michael G. Tracey
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
|
thread by: Michael G. Tracey |
last post Jul 19 '05 by: Michael G. Tracey
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
|
thread by: renniw one |
last post Jul 19 '05 by: renniw one
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...
|
thread by: renniw one |
last post Jul 19 '05 by: renniw one
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...
|
thread by: Ittay Freiman |
last post Jul 19 '05 by: 2metre
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;
+----+
|
thread by: M. Cohen |
last post Jul 19 '05 by: M. Cohen
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
|
thread by: Prem Soman |
last post Jul 19 '05 by: Prem Soman
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
|
| |
thread by: Tom Roos |
last post Jul 19 '05 by: Tom Roos
------_=_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
|
thread by: Vikram Vaswani |
last post Jul 19 '05 by: Vikram Vaswani
Hi guys,
I need some help with this. I have the following 3 tables.
+------+-------+
| uid | name |
+------+-------+
| 100 | sue |
| 102 | harry |
| 104 | louis |
|