 | | | MySQL on Win32 | | Merry Xmas from Brazil to Every World...
and a Happy New Year...
----------
F?bio L?cio Meira
Coordenador - Sistemas de Informa??o
Centro Universit?rio S?o Camilo
Esp?rito Santo - (28) 3526.59Hello all
I am doing some post-conversion (Access- >MySQL) comparison and have
found a few classes of red flags most of which are expected or
harmless. One potentially troublesome class is flaHi!
http //bugs.mysql.com/bug.php?id 7496
A critical bug found if one uses the 4.1 my.cnf option
innodb_file_per_table
to create tables and some of the secondary index records are insertI am trying to read a large .SQL file generated by MySQLDump to selectively
use portions of it (as opposed to restoring the entire database) and am
encountering difficulties doing so from within a I install mysql-Server and Clients Version 4.0.23
after the installation I start winmysqladmin. The program environment message is "MyODBC-Not found driver 3.51 not found "!
Please do you can help mHi all
I want to create an SQL Statement but I need help. My table have
DateBegin DateEnding ScoreBegin and ScoreEnd. I want to select a
record which date between DateBegin and DateEnding and scHi!
InnoDB is the MySQL table type that supports transactions FOREIGN KEY
constraints row-level locking non-locking consistent reads and a non-free
Hot Backup utility.
Release 4.0.23 is At 10 18 AM 12/21/2004 Patrick Questembert wrote
>When I run large queries mysqlnt.exe gets to around 150MB of memory usage
>which brings my WinXP server to a near stand-still and other apps areHello all
I would like to ask you for help with this query. I use VB6 and MyODBC
3.51.10 connection. Problem is that return value from query
select min(date1) as MinDate max(date2) as MaxWhen I run large queries mysqlnt.exe gets to around 150MB of memory usage
which brings my WinXP server to a near stand-still and other apps are barely
able to run ...
This is on Windows XP MyS
Hello
I think that question was asked many times on the list but I searched
archives and found nothing suitable for me.
That 's my problem I need to select one (two three...) random recordsI have this SQL statement (see below).
It creates a table. notice the case in the name of the table.
On my Linux box the case is unchanged.
On my PC it is changed to lower case.
Why?
Where can I find documentation detailing
platform-specific limitiatons such as the maximum
memory utilized DB size maximum number of processors
supported etc. It 'd be nice to see platform
compHello this is my first mail to the list....
I?m using mysql since a month and I notice that during the
weekends the Databse shutdown.
When I left the computer on in the last friAt 09 46 17/12/2004 Mark Mchugh wrote
>seems not to be in my database when looking at it
>through the mysql control center i just see blanks
>but when i add a record then it will add NULL to tAt 09 39 17/12/2004 Mark Mchugh wrote
>Hi Everybody
>Just a quick one...... if i have a number of fields
>defined in a table and there is data in the table
>and i want a default of null is tHi Everybody
Just a quick one...... if i have a number of fields
defined in a table and there is data in the table
and i want a default of null is there any way to
change all empty values to nI have tried many times with alternative settings to get MySql Server
4.1 to run on an XPPro system. With no success. Tried to download the
latest no install files and only get 404 messages for v4.1Hi!
InnoDB is the MySQL table type that supports FOREIGN KEY constraints
row-level locking Oracle-style consistent non-locking SELECTs multiple
tablespaces and a non-free online hot backupHi
I have a problem with VB6 SP6 ADO2.8 and MySQL database version 4.1.7
and ODBC 3.51.10. i use Update function of the recordset and it raise
error when update the database. the error is
"QueryHi all
I 'm looking for information regarding the installation of MySQL (& php) on a
win 2000 sp3 server that already has MSSQL 7.0 (or 2000...not sure).
My question is
1 Can MySQL & MSSQL ruHi Everybody
Somebody knows how i can convert String to Double in MySQL 4.0?
Tks
Daniel
--
MySQL Windows Mailing List
For list archives http //lists.mysql.com/win32
To unsubscribWe have an app running on MySQL on a WinXP box that is experiencing
occasional lockups. When the lockups occur they also appear to take out
Firefox and cause the system to become unstable. To me tJan Theodore
The schemas and data-sample are attached.
I need view the last int_key row grouped by int_phonecall_key.
Tks
Daniel
----- Original Message -----
From "Jan TAn aditional information
this query
SELECT max(int_key)
FROM tbl_hlt_phonecall_historicaldata
GROUP by int_phonecall_key
Returns 2 rows
int_key
184
188
tks
Daniel
----- OriginaJan Theodore
This query don 't running too
SELECT *
FROM tbl_hlt_phonecall_historicaldata
WHERE int_key
(
SELECT max(int_key)
FROM tbl_hlt_phonecall_historicaldata
GROUP by int_phonecallPeople
How can I run this query in MySQL 4.0???
SELECT *
FROM `tbl_hlt_phonecall_historicaldata`
WHERE int_key in
(
select max(int_key)
from tbl_hlt_phonecall_historicaldata
group by iHi Sorry for my English
My configuration is
Win2000 SP4 Mysql server and clients alpha 5.0.1 MyOdbc 3.51.10
Well when I try to execute a simple SP like this
CREATE PROCEDURE `db01`.`SpSome other things to look at...
1) Unless you are using .NET technology you should be using either a DIM statement or a
Server.CreateObject(ADODB.Connection) statement not "New ADODB.Connection "Will MYSQL Server performance improve considerably when using a SCSI drive instead of IDE? What kind of performance are we looking at?
Greg
|
|
|
