created, and
vanishes when the connection closes.
PB
-
Gregory Machin wrote:
On 3/21/06, Addison, Mark [EMAIL PROTECTED] wrote:
-Original Message-
From: Gregory Machin [mailto:[EMAIL PROTECTED]
Sent: 21 March 2006 11:28
To: mysql@lists.mysql.com
Subject: mysql query and version
b2 WHERE b1.auto_id = b2.auto_id) AND auto_dealer_id = '3' AND
Bid_Status = '1';
How do I get this to work on version 4 ?
Many thanks
--
Gregory Machin
[EMAIL PROTECTED]
[EMAIL PROTECTED]
www.linuxpro.co.za
www.exponent.co.za
Web Hosting Solutions
Scalable Linux Solutions
www.iberry.info (support
-Original Message-
From: Gregory Machin [mailto:[EMAIL PROTECTED]
Sent: 21 March 2006 11:28
To: mysql@lists.mysql.com
Subject: mysql query and version problem Help!
Hi.
I have just found out that my hosting provider is using mysql
4 and I'm
using mysql 5 the one query I
On 3/21/06, Addison, Mark [EMAIL PROTECTED] wrote:
-Original Message-
From: Gregory Machin [mailto:[EMAIL PROTECTED]
Sent: 21 March 2006 11:28
To: mysql@lists.mysql.com
Subject: mysql query and version problem Help!
Hi.
I have just found out that my hosting provider
I am running mySQL database version 3.23.58, but I'm using mySQL
Administrator 1.1.9 for scheduled backups. When connecting to the database I
get a message saying that this version of database is not supported and I
might get unexpected behaviour.
Am I OK to use this version of mySQL
Hi MYSQL users.
I have just install SuSE Version 10 and need to start working with MYSQL
could someone help me out regarding
Documentation . Don't seem to be able to find any in the help files.
Andrew
.
--
George
- Original Message -
From: Andrew Burrows [EMAIL PROTECTED]
To: 'MYSQL General List' mysql@lists.mysql.com
Sent: Sunday, January 15, 2006 9:05 PM
Subject: Suse Version 10 Documentation for MYSQL.
Hi MYSQL users.
I have just install SuSE Version 10 and need to start
I have done various searches, and cannot locate the perl dbi for mysql 5.0.16.
I assume that the old one for mysql 4 will not work.
Can someone please provide me the url for mysql 5's perl dbd/dbi bundle?
Thanks, Connie
Connie Logg, Network Analyst
Stanford Linear Accelerator Center
ph:
Hello.
Follow instructions from:
http://dev.mysql.com/doc/refman/5.0/en/perl-support.html
Logg, Connie A. wrote:
I have done various searches, and cannot locate the perl dbi for mysql =
5.0.16.
I assume that the old one for mysql 4 will not work.
Can someone please
I need to run `mysqladmin version` from a remote host, on the same LAN, what
are the min permissions for a user I need to set up to get this data?
--
-
Scott HanedaTel: 415.898.2602
http://www.newgeo.com
At 16:33 -0800 12/9/05, Scott Haneda wrote:
I need to run `mysqladmin version` from a remote host, on the same LAN, what
are the min permissions for a user I need to set up to get this data?
No permissions are necessary, you just need an account that has no privileges.
The account needs only
I have a query that works perfectly in version 4.1.10a-nt however it fails in
version
4.0.24. If someone has any ideas on how to fix the query to run in 4.0.24,
I would really appreciate it! Thanks - code below:
Select
ibiBillMth,ibiBillYear,meter,ibiTotChg,id,userid
Michael Immerman [EMAIL PROTECTED] wrote on 11/25/2005 11:52:47 AM:
I have a query that works perfectly in version 4.1.10a-nt however it
fails in version
4.0.24. If someone has any ideas on how to fix the query to run
in 4.0.24, I would really appreciate it! Thanks - code below
Hello.
x86_64 x86_64 GNU/Linux
Linux AMD64 / Intel EM64T RPM (glibc-2.3, dynamic, gcc) downloads.
Logg, Connie A. wrote:
I have just received a new machine to install mysql on and I do not know =
how to tell which version of the rpm's I should use
[EMAIL PROTECTED] config
I have just received a new machine to install mysql on and I do not know how to
tell which version of the rpm's I should use
[EMAIL PROTECTED] config]# more /etc/redhat-release
Red Hat Enterprise Linux WS release 4 (Nahant Update 2)
[EMAIL PROTECTED] config]# uname -a
Linux snv1 2.6.9-22.ELsmp
Hi!
lu ming wrote:
Hi!
I tried to run the perl scripts in the windows platform yesterday,but
an error occured [[...]]
I can just repeat:
This script is still under construction, and adaptions are still needed
to make tests work correctly on Windows platforms.
If you run it, you are on
Hi, joerg
Thanks for your patient answer!
I hope that we will have the ability to run the test suite on windows
system early.
Best regards
luming
_
与联机的朋友进行交流,请使用 MSN Messenger: http://messenger.msn.com/cn
--
MySQL
Hi!
I tried to run the perl scripts in the windows platform yesterday,but
an error occured as following output info:
C:\MySQL\MySQLServer5\mysql-test\perl mysql-test-run.pl
mysql-test-run: *** ERROR: Could not find
C:/MySQL/MySQLServer5/scripts/mysql_fix_privilege_tables
I
lu ming [EMAIL PROTECTED] wrote on 10/14/2005 12:20:19 AM:
Hi, joerg
Thank you very much!
But i want to know more about this problem. I find a perl script
about
mysql server's test in the mysql-test
subdirectory(/mysql-test/mysql-test-run.pl). Is this the test script
written
Hi!
[EMAIL PROTECTED] wrote:
lu ming [EMAIL PROTECTED] wrote on 10/14/2005 12:20:19 AM:
Hi, joerg
Thank you very much!
But i want to know more about this problem. I find a perl script
about
mysql server's test in the mysql-test
subdirectory(/mysql-test/mysql-test-run.pl). Is this
environment, and the server must be compiled under Cygwin
environment. Actually, it doesn't test the MySQL Server's Windows version
because the Cygwin had make the running environment be equal to the Unix's
i think. Is my opinion right?
I want to know how to test the MySQL Server's Windows version
must use
the Cygwin environment, and the server must be compiled under Cygwin
environment. Actually, it doesn't test the MySQL Server's Windows
version because the Cygwin had make the running environment be equal to
the Unix's i think. Is my opinion right?
Well, this is a typical Windows problem
Hi, joerg
Thank you very much!
But i want to know more about this problem. I find a perl script about
mysql server's test in the mysql-test
subdirectory(/mysql-test/mysql-test-run.pl). Is this the test script
written by perl what could replace the shell
Sujay Koduri wrote:
I was connecting to MySQL 5.0.4 through the C API and it was workign fine.
But when I downgraded to MYSQL 4.1.13, the same code is giving the following
error.
Try rebuilding your program against the v4.1 APIs.
--
MySQL General Mailing List
For list archives:
hi,
I was connecting to MySQL 5.0.4 through the C API and it was workign fine.
But when I downgraded to MYSQL 4.1.13, the same code is giving the following
error.
mysql_stmt_bind_result() failed
Using unsupported buffer type: 0 (parameter: 1)
I tried uninstalling all the existing mysql
Hi,
COLLATE does not work in the way it is described on this page. I have mysql
version:
Ver 12.22 Distrib 4.0.21, for suse-linux (x86_64)
Is it possible that it is a version problem?
Thanx
Wolle
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
At 18:20 +0200 7/24/05, Christian Wollmann wrote:
Hi,
COLLATE does not work in the way it is described on this page. I have mysql
version:
Ver 12.22 Distrib 4.0.21, for suse-linux (x86_64)
Is it possible that it is a version problem?
Yes, you need 4.1. Please see the intro
I have PERL DBI/DBD installed.
What SQL do I issue to obtain list of all tables with PK for a given database?
What SQL do I issue to obtain the SQL source to (re)create all indexes for a
given database?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
server on ABC.
Option of installing later version of the
mysqlclient MySQL-client-4.1.12-1.i386.rpm (off of mysql.com)
does not exist.
Any idea to make mysql on XYZ to talk to mysql server on ABC?
Thanks,
Farid H.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
.
ABC is running 4.1 which has a new password format, so anything 4.0
and before can't authenticate.
Option of installing later version of the
mysqlclient MySQL-client-4.1.12-1.i386.rpm (off of mysql.com)
does not exist.
In that case start ABC with:
old-passwords
in the my.cnf file
Hello,
I want a solution to implement the views in mysql 4.12 version. It is urgent.
Earlier our database was oracle and our search of database is done using views.
I want to implement the same in mysql 4.12 version.
Does any one know how to do it. Please give me solutions at the earliest
On Monday 23 May 2005 02:01 pm, Dayakar wrote:
I want a solution to implement the views in mysql 4.12 version. It is
urgent. Earlier our database was oracle and our search of database is done
using views. I want to implement the same in mysql 4.12 version.
You need version 5.0.4..
http
At 0:31 +0530 5/24/05, Dayakar wrote:
Hello,
I want a solution to implement the views in mysql 4.12 version. It
is urgent. Earlier our database was oracle and our search of
database is done using views. I want to implement the same in mysql
4.12 version.
Does any one know how to do
) are implemented in the 5.0 version of MySQL
Server. Views are available in binary releases from 5.0.1 and up. See Chapter
21, Views.
Migrating, and then reading the documentation and trying to learn how things
work is usually a bad idea.
--
MySQL General Mailing List
For list archives: http
and i need to meet the solution as soon as possible.
4.1 does not support views. As documented in the online documentation:
Views (including updatable views) are implemented in the 5.0 version of
MySQL
Server. Views are available in binary releases from 5.0.1 and up. See Chapter
21, Views
After I upgraded from 4.0.16 to 4.1.11 I have found that the date fields are
being pre-formatted and are causing problems to back-ground programs. Is
there a configuration or session setting that will force the date formatting
to the standard in 4.0 and earlier to correct the program issues?
The default timestamp display format changed between mysql 4.0 and 4.1
The easy fix is to add + 0 to all timestamp fields in selects. Like
this: select my_ts + 0 from t;
You should always read the upgrade notes in the manual. This is very well
documented:
Hi,
in my table I have one varchar(20) column where I store version number.
Version looks like:
1.1.2
1.2.1
1.10.3
It is possible order this column in natural order (1.2 before 1.10)?
Stano.
--
Stanislav Paka
programtor, www skupina
KIOS s.r.o.
tel: 033 / 794 00 18
--
MySQL General Mailing List
Hi Stano,
there was a response by Michael Stassen on the list about a year ago on
this problem, which I hope he doesn't mind if I repeat below.
/Johan
Version numbers?
CREATE TABLE ss (version VARCHAR(13));
INSERT INTO ss VALUES ('1'),('1.1'),('1.2.1.2'),('1.10.1'),('1.2
@lists.mysql.com
Subject: order by version number
Hi,
in my table I have one varchar(20) column where I store version number.
Version looks like: 1.1.2 1.2.1 1.10.3 It is possible order this column
in natural order (1.2 before 1.10)?
Stano.
--
Stanislav Paka
programtor, www skupina
KIOS s.r.o.
tel
On Fri, 29 Apr 2005 08:20:58 +0200, Stano Paska [EMAIL PROTECTED]
wrote:
Hi,
in my table I have one varchar(20) column where I store version number.
Version looks like:
1.1.2
1.2.1
1.10.3
It is possible order this column in natural order (1.2 before 1.10)?
Stano.
Hello Stano,
What about divide 1
`=''
WHERE `id`='1' LIMIT 1;
I know active, and visible are sets, and that there is no value for active, but
I tried with active='0' and got the same warning.
Thanks in advance.
Kind regards
Andy
--
Registered Linux User Number 379093
-- ---BEGIN GEEK CODE BLOCK-
Version: 3.12
GAT/O/CM d
Hello I need to download a version of mySql v4, but I don't know which one
to download.
The Server I'm going to load the built database on to is running: Linux
2.4.19C13_v
As the server is mySql compatible they must already be running mySql on the
system.
So the catch is...
My home terminal
Drew Reid wrote:
Hello I need to download a version of mySql v4, but I don't know which one
to download.
As the server is mySql compatible they must already be running mySql on the
system.
Uh-oh -- not the perennial faceless they, again!?
Shouldn't you ask them what version is on the server so
Hello.
Hi, I am trying to install the latest version of MySQL(i am not sure
4.0.23?
Use 4.1.10a. See:
http://dev.mysql.com/downloads/
Hi, I am trying to install the latest version of MySQL(i am not sure
4.0.23? currently in the office). The RH9 comes with some 3.2.xx
version
Ankur G35 Saxena wrote:
All I had to do was rpm -Uvh --nodeps pkg_name
I have the MySQL AB RPMs running on Red Hat 9 just fine. I didn't have
to force them at all.
I suspect you had to force it because you had MySQL installed already.
The problem is, the Red Hat package is called mysql,
Hi, I am trying to install the latest version of MySQL(i am not sure
4.0.23? currently in the office). The RH9 comes with some 3.2.xx
version, I try to run rpm -U to upgrade but that doesnt work, I try to
install it doesnt work and I try to remove mysql that doesnt work
either. I went to Add
a matter of installing
everything in reverse. The module, then the server...
Hope I was helpful.
Bryan
On Tue, 15 Mar 2005 08:46:52 -0600, Ankur G35 Saxena [EMAIL PROTECTED]
wrote:
Hi, I am trying to install the latest version of MySQL(i am not sure
4.0.23? currently in the office
Daniel Kasak wrote:
Homam S.A. wrote:
In the documentation, it doesn't mention which version
of MySQL supports the CASE statement, but it refers to
stored procedures, so is it only supported for 5.x?
I can't get any example of a CASE statement work in
MySQL.
snipped
For example, I can execute
On Wednesday, March 09, 2005 07:49, Philippe Poelvoorde wrote:
Daniel Kasak wrote:
Homam S.A. wrote:
In the documentation, it doesn't mention which version
of MySQL supports the CASE statement, but it refers to
stored procedures, so is it only supported for 5.x?
I can't get any example
as
T-SQL with END and it worked fine.
Homam
--- Tom Crimmins [EMAIL PROTECTED] wrote:
On Wednesday, March 09, 2005 07:49, Philippe
Poelvoorde wrote:
Daniel Kasak wrote:
Homam S.A. wrote:
In the documentation, it doesn't mention which
version
of MySQL supports the CASE statement
Poelvoorde wrote:
Daniel Kasak wrote:
Homam S.A. wrote:
In the documentation, it doesn't mention which
version
of MySQL supports the CASE statement, but it
refers to
stored procedures, so is it only supported for
5.x?
I can't get any example of a CASE statement work
in MySQL
In the documentation, it doesn't mention which version
of MySQL supports the CASE statement, but it refers to
stored procedures, so is it only supported for 5.x?
I can't get any example of a CASE statement work in
MySQL.
The reason I'm asking is because in other SQL
dialects, such as T-SQL, you
Homam S.A. wrote:
In the documentation, it doesn't mention which version
of MySQL supports the CASE statement, but it refers to
stored procedures, so is it only supported for 5.x?
I can't get any example of a CASE statement work in
MySQL.
snipped
For example, I can execute the following in MS
Any idea 5.0.3 release date? There are many bugs fixed right now for 5.0.2!
Alejandro
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
Complete information about licensing policy you can receive
from [EMAIL PROTECTED]
shabanip [EMAIL PROTECTED] wrote:
what is the latest GPL licensed version of mysql?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored
what is the latest GPL licensed version of mysql?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Pete!
Am Mi, den 23.02.2005 schrieb Pete Lancashire um 4:43:
If I needed a brute force DB on an x86 platform would
using Version 3 vs 4 buy me any performance today ?
IMO, you should not start with version 3 any more - it is too old.
Probably, you should not even start with 4.0 but use 4.1
Hello.
Use the latest release (4.1.10 now). You'll get a huge speed up
using bulk inserts.
Pete Lancashire [EMAIL PROTECTED] wrote:
If I needed a brute force DB on an x86 platform would
using Version 3 vs 4 buy me any performance today ?
90% inserts, 5% simple selects, 5% other
If I needed a brute force DB on an x86 platform would
using Version 3 vs 4 buy me any performance today ?
90% inserts, 5% simple selects, 5% other.
Sorry if a lame question
-pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
-Original Message-
From: Will Merrell [mailto:[EMAIL PROTECTED]
Sent: 20 February 2005 14:00
To: Mysql Mailing list
Subject: How to Version Control a database
I have a project that involves several developers working on
their own machines. Each has a local copy
Hello.
I suggest you to use 4.1.10 (in 4.1.8 was fixed a bug #6784,
I haven't seen it in a changelist of 4.0.x branch). If
myisamchk -r *.MYI, myisamchk -o *.MYI doesn't solve the
problem, as the last chance, use USE_FRM mode of REPAIR
command. But you may lose some information about the
I have a project that involves several developers working on their own
machines. Each has a local copy of the database on their own machine. Since
we have some developers who develop while not connected to the network, we
cannot use a common database.
How can I version control the database so
The method employed by the company I work for is to maintain a version
controlled set of scripts, which can be used to create/update a database
(many of these scripts are objects such as UDFs, Stored Procedures and so
forth, which represent the 'software' layer within the database).
A bespoke
Try using MYdbPAL from www.it-map.com .
The product has complete schema version control, alowing you to track
changes and compare sche,as for diffrences. Its FREE to MySQL users.
Tim
-Original Message-
From: Will Merrell [mailto:[EMAIL PROTECTED]
Sent: 20 February 2005 14:00
To: Mysql
version (which I stopped updating after having some other issue, which I can
no longer remember). Where can I download it
Anyhow, with the errors, I get these in my application's log (mysql does not
log any errors):
Duplicate entry 'Some text here ---f' for key 3
Incorrect key
See:
http://downloads.mysql.com/archives.php
Thank you. Nice link to have around.
Key 3 is the FTS key. The others are a UNIQUE KEY (#1) and a KEY(#2).
Do you have the same values for full-text parameters (ft_mit_word_len
for example)?
Not at first. I had noticed that not long after I sent
version (which I stopped updating after having some other issue, which I can
no longer remember). Where can I download it
Anyhow, with the errors, I get these in my application's log (mysql does not
log any errors):
Duplicate entry 'Some text here ---f' for key 3
Incorrect key file for table
I'm having a problem with the default Win32 mysql client program running
in the Cygwin environment, in that it writes CRLF pairs out, causing
some Bash scripts that I'm running on both a Linux box and a Win2k box
to give garbled results. I wondered if there's a Cygwin compiled
version
box
to give garbled results. I wondered if there's a Cygwin compiled
version that outpouts with just line feeds.
I may be wrong about this, but aren't you in a *nix environment when
running inside Cygwin?
Well, sort of. It does some DOS to Unix text file translation, and
generally when you
[snip]
Having a hard time finding a server/host who supports MYSQL 4.1.3 or
above.
Does anyone know and can recommend a host who offers this?
[/snip]
http://www.phpwebhosting.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Eric Bergen wrote:
If you can use mysqldump to export the data from 3.23 with the -Q
switch to quote all db, table, and column names.
Thanks for the input, that has worked for me in the past, but it's on a hosted db server and I don't think I have rights to run mysqldump on it. I was hoping to
Hello,
I am trying to import a table structure from ver 3.23.52 to ver
4.1.7-max and I am getting an error:
--- error -
|#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'wish_list_id
Don Stefani wrote:
Hello,
I am trying to import a table structure from ver 3.23.52 to ver
4.1.7-max and I am getting an error:
--- error -
|#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
an error:
--- error -
|#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'wish_list_id` int(6) NOT NULL auto_increment,
`Client_Name` varchar(255) defau' at line 2
- end
Having a hard time finding a server/host who supports MYSQL 4.1.3 or
above.
Does anyone know and can recommend a host who offers this?
Thanks,
Lee
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
is going to run on Solaris.
The issue is that all developers run there own instance of MySQL server Linux
or Windows based and the same version 4.1.7. Also, each developer has the
database for their particular project so everything from their MySQL server
instance would be ported.
As we move
We have 2 distinct groups of developers - Windows vs. Linux. Our production
server is going to run on Solaris.
The issue is that all developers run there own instance of MySQL server Linux
or Windows based and the same version 4.1.7. Also, each developer has the
database for their particular
Acct wrote:
We have 2 distinct groups of developers - Windows vs. Linux. Our production
server is going to run on Solaris.
The issue is that all developers run there own instance of MySQL server Linux or Windows based and the same version 4.1.7. Also, each developer has the database
* FROM table WHERE one = 4;
would do the same thing.
See the manual for suggestions on rewriting subqueries as joins
http://dev.mysql.com/doc/mysql/en/Rewriting_subqueries.html.
Michael
N. Kavithashree wrote:
hello,
i m working on mysql version 4.0.18 .the documentation given for this
version
hello,
i m working on mysql version 4.0.18 .the documentation given for this
version will show subquries syntax which whill not work practically.
i urgently want help in this regard. can anybody mail me how can we write
the subquries in mysql version 4.0.18 ?
Eg. select * from table as t1
It is possible to copy the database of mysql-3.22.32 (/usr/local/mysql/var) on
version 4.0.20 (/usr/local/mysql_new/var)?
There is possibility that they work?
My O.S. is Solaris 8
Thank's
Alessio
P.S.
In that case I must use the function mysqlhotcopy? I don't have the
possibility to use
to copy the database of mysql-3.22.32 (/usr/local/mysql/var)
on version
4.0.20 (/usr/local/mysql_new/var)?
There is possibility that they work?
My O.S. is Solaris 8
Thank's
Alessio
P.S.
In that case I must use the function mysqlhotcopy? I don't have the
possibility to use
I use the following to extract the version number. But it throws an error on
newer version 5.xx. It works on version 4.0 and below.
SELECT SUBSTRING(VERSION(),1,LOCATE(-,VERSION())-1) AS VERSION
On version 5.0.1-alpha-nt-log I get an error...
Illegal mix of collations
(utf8_general_ci,IMPLICIT
- Original Message -
From: Fredrick Bartlett [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 29, 2004 12:08 PM
Subject: Extract MySQL Version
I use the following to extract the version number. But it throws an error
on
newer version 5.xx. It works on version 4.0
I use the following to extract the version number. But it throws an
error
on
newer version 5.xx. It works on version 4.0 and below.
SELECT SUBSTRING(VERSION(),1,LOCATE(-,VERSION())-1) AS VERSION
On version 5.0.1-alpha-nt-log I get an error...
Illegal mix of collations
Hi mysql-community!
I have a problem with mysql 3.23.49a:
If I try to use the statement 'LOAD DATA LOCAL INFILE
'/storage/hosting/uxclients/www.xxx.ch/transfer/golfclub.csv' INTO TABLE
test'
mysql replys: 'The used command is not allowed with this MySQL version'.
Why this error-message
Hi.
See
http://dev.mysql.com/doc/mysql/en/LOAD_DATA_LOCAL.html
Martin Rytz [EMAIL PROTECTED] wrote:
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __
, which is basicaly a patched
version of the normal v1.4.2 syslog daemon so it can write to MySQL.
It requires MySQL-shared in order to compile, and I thought this would
make it able to work with all versions of MySQL.
But after trying with v. 4.1.6 without luck I finaly revertet to 4.0.21
and lo
mysql INSERT INTO Employee.tblNiiEmployee (empEmail)
- SELECT b.Email_Address
- FROM Employee.tblNiiEmployee a LEFT OUTER JOIN UserDB.Corporate b
- ON(a.empUsrName = b.Unix_Username)
- WHERE b.Email_Address IS NOT NULL;
Since versions prior to 4.0.14 do not support using the same
[snip]
mysql INSERT INTO Employee.tblNiiEmployee (empEmail)
- SELECT b.Email_Address
- FROM Employee.tblNiiEmployee a LEFT OUTER JOIN UserDB.Corporate b
- ON(a.empUsrName = b.Unix_Username)
- WHERE b.Email_Address IS NOT NULL;
Since versions prior to 4.0.14 do not support using
You should keep threads on the list. That way, more people can help, and
more can benefit from the answers.
I've not looked at the code behind mysql_get_server_info(), but every
version of mysql I've seen has 3 parts to the version number. It seems
clear that the mysql version numbering
mysqladmin version
On Mon, 11 Oct 2004 10:36:54 -0400, Michael Stassen
[EMAIL PROTECTED] wrote:
You should keep threads on the list. That way, more people can help, and
more can benefit from the answers.
I've not looked at the code behind mysql_get_server_info(), but every
version
Will mysql_get_server_info() give you what you need?
http://dev.mysql.com/doc/mysql/en/mysql_get_server_info.html
Otherwise, I suppose you could
SELECT VERSION();
and parse the result.
Michael
Matthew Boehm wrote:
Hey guys,
I see there is a mailing list for all other API's except the built
or higher I
need to find out what the server's version is first.
Normally I could just check MYSQL_VERSION_ID and if it is greater or equal
to 40100 then I can use the prepared statements. But, in my case, I'm using
the 4.1 client libraries but the test server I'm connecting to is 3.23.50
which
Look forward in documentation at http://dev.mysql.com/doc/
for Replication and MySQL Cluster sections. Hopefully one
or both will be answer for you.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
Hi,
I'm trying to compile from the development source tree (bitkeeper)
version 4.1.3-beta, on a Mandrake 9.2 box. It keeps failing to compile
in ndb/src/kernel/ArrayPool.hpp. I am trying to compile it with cluster,
since that is what I need to test. I've done all the autoconf/etc steps
I've heard some recent rumblings that MySQL before 4.1 wasn't
multithreaded on OS X. However, in actual usage I see every
indication that is IS.
Does anyone have a definitive answer either way? Thanks!
- John
--
---
John
Hi
Configure run command:
./configure \
--prefix=${INSTALL_DIRECTORY} \
--exec-prefix=${INSTALL_DIRECTORY} \
--libexecdir=${INSTALL_DIRECTORY}/bin \
--disable-shared \
--enable-thread-safe-client \
--enable-local-infile \
Hello mysql,
Recently downloaded myODBC for use Win2k SP4
initially used EXE version (MySQL Connector/ODBC 3.51) when installed
Looking at its properties
myodbc3.dll shows that it 3.51.6 ??
Tried again with MSI install
MyODBC-standard-3.51.07-win.msi
myodbc3.dll also shows version 3.51.6
301 - 400 of 915 matches
Mail list logo