Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: Joel Rees [EMAIL PROTECTED]
===
I know I'm
Subject: MS Access and mySQL
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: MS Access and mySQL
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: MS Access and mySQL
From: =?iso-8859-1?q?Jonathan=20Coleman?= [EMAIL PROTECTED]
===
Hi.
I have a
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: Dean Ellis [EMAIL PROTECTED]
===
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 27 August 2002 09:51 pm, Will French wrote:
accepting
Subject: MS Access and mySQL
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: MS Access and mySQL
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: MS Access and mySQL
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: MS Access
Steven,
I assume you are running on Linux, since you were able to resolve the stack
traces. Which distro: rpm or .tar.gz?
I am right now running all my stress tests on 4.0.3 on the .tar.gz distro on
a 4-way Linux-2.4.16-64GB-SMP, and it seems to work.
Your bug is probably query- or
Hi,
I'm happy to know I'm not the only one which have this segfault problem.
Do you have any idea of what kind of queries causes those segfault ? (I
unfortunatly have also a nil pointer)
Thanks and regards,
Jocelyn
- Original Message -
From: Steven Roussey [EMAIL PROTECTED]
To:
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: Dean Ellis [EMAIL PROTECTED]
===
Subject: MS Access and mySQL
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: MS Access and mySQL
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: MS Access and mySQL
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: MS Access
Subject: Re: 4.0.3 crashes every 5 seconds.
From: Heikki Tuuri [EMAIL PROTECTED]
===
Steven,
I assume you are running on Linux, since you were able to resolve the stack
traces. Which distro: rpm or .tar.gz?
I am right now running all my stress tests on 4.0.3 on the .tar.gz distro on
a 4-way
Subject: Re: 4.0.3 crashes every 5 seconds.
From: Jocelyn Fournier [EMAIL PROTECTED]
===
Hi,
I'm happy to know I'm not the only one which have this segfault problem.
Do you have any idea of what kind of queries causes those segfault ? (I
unfortunatly have also a nil pointer)
Thanks and
On Wed, 2002-08-28 at 03:35, nflorez wrote:
I am trying to run Mysql for the first time and it fail.
--
#mysql -u root -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
-
I'm new to this list so I
Does anyone have any preference regarding the use of Connector/J version 2+
or version 3?
I am confused after reading the mySQL website as to whether some of the
following features are new as of version 2 or version 3 of the driver:
1. 50-100% faster than previous version.
2. Supports prepared
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup
Subject: synopsis of the problem (one line)
From: root [EMAIL PROTECTED]
===
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup
Hi!
InnoDB is a table type which adds transactions, row level locking, and
foreign key constraints to MySQL.
InnoDB is included in all distributions of MySQL-4.0, both in the plain and
the -Max release.
InnoDB in the stable MySQL-Max-3.23 branch is now frozen except for bug
fixes. New InnoDB
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wednesday 28 August 2002 05:02, Steven Roussey wrote:
I downloaded a copy of 4.0.3 from the download page and it crashes every
five seconds! Resolving the stack trace gives:
0x806ebdb handle_segfault__Fi + 447
0x8261718
Hi,
I was following the example in the manual (the menagerie database) but I
can not load a file into the table, i get the following error:
mysql LOAD DATA LOCAL INFILE ~/testmysql/pet.txt INTO TABLE pet;
ERROR 1148: The used command is not allowed with this MySQL version
I searched the
Have you tried the command : EXPLAIN SELECT select_options
(http://www.mysql.com/doc/en/EXPLAIN.html). Maybe it can help you to see
what Indexes are used ...
Stephan
-Original Message-
From: David Bordas [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 27, 2002 5:16 PM
To: Mikhail
Check out full-text indexing:
http://www.mysql.com/doc/en/Fulltext_Search.html
I don't think there's any other way to improve searching in
unstructured text using MySQL
-steve
At 3:58 PM -0700 8/27/02, Sanny Sun wrote:
Hi there,
I have a big table which has 25
BS Have you tried the command : EXPLAIN SELECT select_options
BS (http://www.mysql.com/doc/en/EXPLAIN.html). Maybe it can help you to see
BS what Indexes are used ...
Yep i do that but varchar and text fields aren't index so ...
I'm also having a look to FULLTEXT index, but i think that the
What do you mean varchar and text fields are not index?
alter table mytable add index (myvarchar, mytext(100))
One last resort that may work for you is to try the regexp instead of
LIKE. The functionality of regexps for me has at best been
unpredictable, sometimes it is faster, sometimes at
David,
| | As I understand...after removing Field5 LIKE '%John'
| | condition the query works much faster.
|
| Nop, sorry i'm not clear, the query works mush slower ...
This will be fast if you have the right index--
field5 like 'John%'
These will NOT be fast
From: Shashank Tripathi [EMAIL PROTECTED]
This will be fast if you have the right index--
field5 like 'John%'
These will NOT be fast --
field5 like '%John%'
field5 like '%John'
Putting a wildcard character (%) before the term will avoid the index.
Yep, and it's for that point that
Hi David,
| Why not regexp but this is not i mean, in fact
| where CONTENT like '%word1%'
| or CONTENT like '%word2%'
| or CONTENT like '%word3%'
| shoud be :
| where CONTENT1 like '%word%'
| or
Subject: job database with invoicing
Date: Tue, 27 Aug 2002 22:05:43 +0200
From: Kai Vermehr [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
I'm building a job database with simple invoicing. I have one table called
JOBS and one called INVOICES. In INVOICES there's a foreign key
From: Shashank Tripathi [EMAIL PROTECTED]
| Why not regexp but this is not i mean, in fact
| where CONTENT like '%word1%'
| or CONTENT like '%word2%'
| or CONTENT like '%word3%'
| shoud be :
| where CONTENT1
Hi,
- Original Message -
From: Shashank Tripathi [EMAIL PROTECTED]
To: 'David Bordas' [EMAIL PROTECTED]; 'BRACHET,STEPHAN
(Non-HP-France,ex1)' [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, August 28, 2002 12:25 PM
Subject: RE: Slow select query, need some clues to speed it
- Original Message -
From: Supriya Shiyekar [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 27, 2002 10:59 PM
Subject: MySql performance problem
Hi,
We are having strange performance problem with mysql on Solaris.Our
application makes JDBC calls to mysql
Hi Armer,
thanks a lot for your help ... it was very usefull!!! After understanding
the principles I wonder why I didn't think it up myself ... but then
solutions often appear obvious after a problem is solved.
Also I like your remarks on testing queries on paper first -- I'll see if I
can use
hii,
I am trying to learn how to use mysql with php on windows..
Can you help me to find some tutorial , e-book or any helpfull url ...?
By
the way, I am new at this .. so I need something covering the basic
informations...
thanks a lot
Meltem
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jonathan,
If you are going to be completely converting the Access db to MySQL,
and just using Access as the frontend, you will need to download
MyODBC:
http://www.mysql.com/downloads/api-myodbc.html
You can download either the stable or
Two ideas:
1)
Mysql is not running, so try:
/etc/rc.d/init.d/mysqld start
If you get an error, that it is already running, than you can be sure that
it really is running.
2)
When mysql is installed, than the root account is without password. Just log
into your linux as root and run mysql.
You
Are there any documents on how to performance tune mySQL 4.x?
sean.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
Hello,
I have implemented replication between 2 tables in MySQL since then,
once in a while
I see this error in the error log files
Error reading packet from server: Lost connection to MySQL server
during query (read_errno 134,server_errno=2013)
Any ideas?
Thanks..
Hi,
I'm trying to figure out how to implement an embedded mySQL database in
my application, but seems to have stumbled on something strange. The
documentation and on the web everyone seems to refer to a
method/function called 'mysql_server_init()' however, my compiler
complained about that it
Hello,
Yes, there are lots of good documentation:
First, the official MySQL Technical Reference, Section 5 at
http://www.mysql.com/doc/en/index.html
Then scroll down to 5 MySQL Optimisation and read those.
Also, check this:
http://www.devshed.com/Server_Side/MySQL/Optimize/page1.html
It's a bit
Cams Ismael writes:
Description:
A time ago I reported next bug:
The ALTER TABLE command behaves very strange when stopping and
restarting the MySQL server afterwards. I noticed this after having
rebooted my PC (which means that the MySql server is stopped
neal wrote:
Does anyone have any preference regarding the use of Connector/J version 2+
or version 3?
I am confused after reading the mySQL website as to whether some of the
following features are new as of version 2 or version 3 of the driver:
1. 50-100% faster than previous version.
Okay,
This is getting very nasty. There is no need for harsh words. Let's take a step back
and look at the problem a bit differently. The story, as I understand it, is this;
Will made a decision some time ago to develop applications on MySQL. Will based his
decision at least partially on the
In the Ziff Daveis eWeek benchmark
http://www.eweek.com/article/0,3658,s=708a=23115,00.asp )I noticed the
following:
MySQL's great performance was due mostly to our use of an in-memory query
results cache that is new in MySQL 4.0.1. When we tested without this cache,
MySQL's performance fell
From: Joel Rees [EMAIL PROTECTED]
To: Will French [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Info on 4.0.x release date
Date: 28 Aug 2002 14:41:51 +0900
I know I'm not really involved here, but I would like to suggest a few
things.
Obviously you don't agree with me and
Hi,
how can I do sql command like this:
update sekce set pocet = count(*) from odkaz where odkaz.sekce_id = sekce.id
Thanks for answer
j.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
mysql ,
My dear,
Good day, I wish to introduce myself to you. I am Lt. Col. James Kadeh, (rtd.).
I am the personal assistant to President Laurent Kabila of Democratic Rep. of Congo.
I got your contact information from your country's information directory over the
internet during my
you cant update from is NOT supported
-Original Message-
From: Jakub Mach [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 9:15 AM
To: Mysql
Subject: SQL - Update problem
Hi,
how can I do sql command like this:
update sekce set pocet = count(*) from odkaz where
I have been there done that with old access data, but no forms. Your
plans should be focused around what you know and what your systems are
tied to. Since its an NT box you could go with pretty much any language
ie java/vb/c++. VB would be the obvious choice for ease of transfering
the Access VBA
Description:
The following sequence corrupts the table with MySQL 4.0.3-beta.
It works fine with 3.23.51.
LOCK TABLES t WRITE;
DELETE FROM t;
OPTIMIZE TABLE t;
How to reproduce:
-
mysql SELECT version();
++
| version() |
++
| 4.0.3-beta
wow...do you think this is real.we could all be rich!...:-P
- Original Message -
From: James Kadeh [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 28, 2002 3:34 PM
Subject: JAMES KADEH mysql !
mysql ,
My dear,
Good day, I wish to introduce myself
On Wed, 28 Aug 2002, Sean Hager wrote:
In the Ziff Daveis eWeek benchmark
http://www.eweek.com/article/0,3658,s=708a=23115,00.asp )I noticed the
following:
MySQL's great performance was due mostly to our use of an in-memory query
results cache that is new in MySQL 4.0.1. When we tested
Mertens,
Wednesday, August 28, 2002, 10:54:12 AM, you wrote:
MB I was following the example in the manual (the menagerie database) but I
MB can not load a file into the table, i get the following error:
MB mysql LOAD DATA LOCAL INFILE ~/testmysql/pet.txt INTO TABLE pet;
MB ERROR 1148: The used
Vaso,
Wednesday, August 28, 2002, 4:09:56 PM, you wrote:
VK I have implemented replication between 2 tables in MySQL since then,
VK once in a while
VK I see this error in the error log files
VK Error reading packet from server: Lost connection to MySQL server
VK during query (read_errno
Markus,
Wednesday, August 28, 2002, 3:48:42 PM, you wrote:
MR we are using mysql 3.23... for our webservices.=20
MR the following question about grant:
MR granting grant option to a user has the consequence, that this user can grant to
other users - even if this other user doesn't exist!!
MR
Harald,
thank you for reminding. I forgot to add this to the changelog of
InnoDB-3.23.52:
a.. Aligned some buffers used in reading and writing to data files. This
allows using unbuffered raw devices as data files in Linux.
I am grateful if someone has time to test this.
Regards,
Heikki
the join syntax is what is differnt between Access and MYSQL.
in MS-SQL = indexs will be used on tables mentioned in the JOIN clause
and they will not in MYSQL
-Original Message-
From: Nicholas Stuart [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 9:40 AM
To: [EMAIL
I reported him already... to [EMAIL PROTECTED]
[EMAIL PROTECTED]
and several others..
also wrote back and asked if he thought I was a complete idiot...
-Original Message-
From: John Wards [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 9:49 AM
To: [EMAIL PROTECTED]
In the last episode (Aug 28), Harald Fuchs said:
I think there's something missing in the changelog. About a month
ago, someone named Christian Jaeger from ETH Zurich asked about
unbuffered raw device support for Linux. You replied immediately
with two sets of patches for 3.23.x (regaring
Hmm .. isn't there any workaround for this .. Maybe something like:
select count(*) into :somerVar FROM table;
update sekce set pocet = :someVar WHERE ... blabla;
I've seen things like this in other databas servers but haven't been able to
find out if it's supported by MySQL,
That and Access also uses sub-selects and some other mutlitable features
that MySQL does not yet implement. Aslo, most of the internal functions
are different as well such as: To get only the top row of a query in
Access you use SELECT TOP 1 blah blah, but in MySQL you use SELECT blah
blah LIMIT
Jakub,
Wednesday, August 28, 2002, 5:15:01 PM, you wrote:
JM how can I do sql command like this:
JM update sekce set pocet = count(*) from odkaz where odkaz.sekce_id = sekce.id
First: multi-table updates is supported only since 4.0.2
Second: even on 4.0.2 you can't do it with above query
--
I would strongly urg you not to use Access as the front end. The biggest
problem is that the Jet Engine/Access backend is pretty much completly
different then MySQL and you will run into problems with table structure
and the like. Also, using access as the front end has been extremly slow
when
Description:
innodb table types introduce dependancies on one table by another.
Thus the order of table loading is important. If a table is loaded
before one it depends on an error is triggered.
mysqldump will dump tables in the wrong order, it seems to dump
Dan,
- Original Message -
From: Dan Nelson [EMAIL PROTECTED]
To: Harald Fuchs [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, August 28, 2002 6:10 PM
Subject: Re: MySQL/InnoDB-4.0.3 is released
In the last episode (Aug 28), Harald Fuchs said:
I think
Hi,
...adding a new query and using variable:
SET @a:=0; --initialize variable a;
select @:=COUNT(*) from odkaz where odkaz.sekce_id = sekce.id;
update sekce set pocet = @a where odkaz.sekce_id = sekce.id;
Regards,
Gelu
_
G.NET SOFTWARE
Hi,
From what i know , embedded MySQL is implemented begin with version 4.0.x.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original
Hi,
after upgrading, I had two problems:
/usr/local/mysql/bin/mysqld: ERROR: unknown variable 'query_buffer_size=32M'
I had to comment out this variable, it seems it got renamed. I have to
figure out what's the new name.
020828 17:30:12 mysqld started
020828 17:30:12 Can't find
Can connector/J coexist with mm.mysql on the same tomcat? I'd like to
upgrade one site at a time rather than then all the sites at once.
On Wed, 28 Aug 2002, Mark Matthews wrote:
Date: Wed, 28 Aug 2002 08:59:33 -0500
From: Mark Matthews [EMAIL PROTECTED]
To: neal [EMAIL PROTECTED]
Cc:
Other companies require you to sign up for a Beta program before you can
even look at it.
The public doesn't even hear about it until the Beta is through, and the
product is ready.
You probably will never know how long the Beta cycle lasted.
You are privileded to be given such early access to
On Wed, 2002-08-28 at 16:51, Egor Egorov wrote:
Put into my.cnf file :
[mysql]
local-infile=1
or start mysql client with --local-infile=1 option.
I tried the first option and it works when use the following command to
load the data-file:
mysql LOAD DATA LOCAL INFILE
William R. Mussatto wrote:
Can connector/J coexist with mm.mysql on the same tomcat? I'd like to
upgrade one site at a time rather than then all the sites at once.
No, because there are classname clashes. If you remove the org
subdirectory from the .jar file, it might work okay.
burger17,
Tuesday, August 27, 2002, 7:07:45 PM, you wrote:
b In dos-prompt, I type at c:\mysql\binmysql for testing to see if mysql is
b connected successful but
b the error is : Error 2003: Can't connect to MySQL server on 'localhost'
b 10061
b How to solve this problem?
b Hope to hear from
Mary Stickney wrote:
the join syntax is what is differnt between Access and MYSQL.
in MS-SQL = indexs will be used on tables mentioned in the JOIN clause
and they will not in MYSQL
This is not true. MySQL uses indexes in joins, if you've put them in the
right columns, just as in MS-SQL.
also wrote back and asked if he thought I was a complete idiot...
Unfortunately, you may be.
Now he has your e-mail address.
As my father always sez, smooth move Ex-Lax
-Original Message-
From: Mary Stickney [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 10:12 AM
To:
Hi,
I can confirm this on Linux i386 with official binaries on MyISAM
tables:
mysql check table blast;
DELETE FROM ++---+--+--+
| Table | Op| Msg_type | Msg_text |
++---+--+--+
| test_mmo.blast | check |
Or you could just use the libmySQL.dll and handle everything yourself
through VB.
You will however need to download the MyODBC driver if you wish to access
MySQL through VB.
-Nick
-
Before posting, please check:
I have used the mysql password(\$pass \) function in the past to encrypt
passwords into the db. but can not decrypt them if needed. I know this is
not something new.
Is there a better way to protect passwords in the db and then decrypt them
if needed ?
Thanks
Mark
Hi,
Egor has right and i didn't read very carefully you e-mail.Sorry
You can try this :
SET @a:=0;
SET @b:=0;
SELECT @a:=COUNT(*),@b:=sekce.id FROM odkaz,sekce WHERE odkaz.sekce_id =
sekce.id;
UPDATE sekce SET pocet = @a WHERE id= @b;
Now...i think it's corect...
Regards,
Gelu
see my message re--- index problem
ok when I do explain in this , it is not using an index for the
AdminCoverage_writingagents table...
SELECT admincoverage_writingagents.WritingAgentID,
admincoverage_writingagents.WritingAgentSlot, ProducerID, TaxID,
(ModalPremium * BillModeID *
At 17:48 +0200 8/28/02, Martin MOKREJ· wrote:
Hi,
after upgrading, I had two problems:
/usr/local/mysql/bin/mysqld: ERROR: unknown variable 'query_buffer_size=32M'
I had to comment out this variable, it seems it got renamed. I have to
figure out what's the new name.
It's no longer used,
Joel, you obviously put some thought into his response and I very much
appreciate the insight. All in all, I feel you make some good points. I
did find a couple of things that I want to rebut.
Well, as a bystander, I think you've shot a little wide.
When you say bystander, are you referring
HOW does one use this to confirm a record set? for instance,
if mysql_store_result() = 0 then
do nothing
end if
where mysql_store_result() returns an empty set on a select statement.
any help obtained would be WONDERFUL!!! sorry, i'm new to this, the
syntaxtual information is quite
Hi,
About query_buffer_size, you can find in the changelog :
- Removed unused variable query_buffer_size.
Regards,
Jocelyn
- Original Message -
From: Martin MOKREJ [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 28, 2002 5:48 PM
Subject: First thoughts on
True you could, but then that way you will loose portability if Jon (for
whatever reason) decides to move to another type of DB. Never used
libmySQL so I dont know how the speed is, but assume its as fast if not
faster then ODBC.
ODBC has the plus of being user friendly and of being an M$
I wrote Ironically, the fact that I pay no license fees to MySQL AB is
based upon...
Dean Ellis wrote Ahhh, I see. So, you are _completely irrelevant_.
My relevance stems from the fact that I am a very good prospect to a company
that has a stated interest in growing their community of
HE ALREADY DID FROM PREVIOUS EMAILS TO MY ACCOUNT... I HAVE A WEB PAGE AND
THEY
ARE MINING EMAIL ADDRESSES.. DUH
SAME BACK AT YOU
-Original Message-
From: Kenneth Hylton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 11:29 AM
To: 'Mary Stickney'; John Wards; [EMAIL
Hi,
I'm using version 3.23.49 on RH7.3.
I'm following the menagerie example and have added some lines to the
pet tabel using the LOAD DATA LOCAL INFILE... construction.
I have created a file pet.txt like the manual suggests and have added \N
in some fields to include NULL values.
However when
I doubt mysql as access to /home/M8ram/testmysql/pet.txt.
Mertens Bram wrote:
On Wed, 2002-08-28 at 16:51, Egor Egorov wrote:
Put into my.cnf file :
[mysql]
local-infile=1
or start mysql client with --local-infile=1 option.
I tried the first option and it works when use the following
If I understand you correctly, then you are trying to figure out how to
distinguish between an empty result set vs. no result set (i.e. an error if
statement was a SELECT).
In the case of an error (or a not result set returning statement like
INSERT), mysql_store_result will return null.
In the
On Wed, 2002-08-28 at 20:02, Gerald Clark wrote:
I doubt mysql as access to /home/M8ram/testmysql/pet.txt.
Sorry, I don't understand: why would mysql have access to a file when I
run LOAD DATA LOCAL... and not when I run it without the LOCAL?
If I run it with LOCAL the data is added to the
Hi,
Using directly libmysql.dll ?How ?
On http://www.a1vbcode.com/app.asp?ID=1764 is gmysql.zip.TypeLibrary for VB
and work with libmysql ver 4.xCan be an alternative.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address :
I dont know if it helps, but I dont decrypt, instead, I compare the crypted
value on the DB against the output of the function PASSWORD() filled with
the pwd I get from the user... It works for me (and I'm using APACHE and
MySQL all in plain ANSI C). Leonardo Javier Belén. AFIP-AR
- Original
You didn't mention whether they are planning on keeping the NT box, but I
assume that they are, and that what you want to do is leave the Access app
working, but point it to the Linux-MySQL QUBE. I have been there and done
that (well, except for the QUBE part -- I run Mandrake 8 on an old P-233.
Thanks to all that reply to my help request.
Yes, mysqld was not running.
Thanks again,
Nestor :-)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
That has not been my experience, in fact my experience has been completely
the opposite. As my first test case I ported the Northwind sample database
to MySQL. I had to make a few changes here and there, most notably to some
queries, but also including (and I forgot to mention this in my previous
Description:
I am porting MySQL to Linux/Alpha. On some occasions
the CREATE TABLE statement adds ZEROFILL for int(11)
fields. If you don't know this problem, let me know
so I can try to fix it. If you know the problem please
let me know what to do (I don't
You can also use
TRUNCATE TABLE table_name;
this recreates the table, instead if just removing all data from it. To get
to know more about the table structure, you may want to use:
SHOW CREATE TABLE table_name;
It shows you the create table statement of the table.
-Oorspronkelijk
On 28 Aug 2002, at 19:49, Mertens Bram wrote:
Here are a few lines from the pet.txt:
flufyyharold cat f 1993-02-04 \n
Chirpy\n bird\n \n \n
[snip]
What am I doing wrong?
Not paying attention to case. As you said earlier, the code for
Hello.
On Wed 2002-08-28 at 09:19:46 -0500, [EMAIL PROTECTED] wrote:
[...]
serious. It becomes harmful to MySQL in general when a release that was
once predicted in 2001, becomes no where in sight in late 2002.
Do you (all) realize you can only complain about this (falling so far
from their
I was given the task of finding out what is need it to set a our Mysql DB on
separate server from our webserver.
The OS is will be RH7.3
There will be a lot of transactions accessing this serverMysql.
My questions are:
1) What is the recommended ram and hard Drives for a server that will be
1 - 100 of 156 matches
Mail list logo