Hi!
It is a bug in the FOREIGN KEY syntax parser. It is confused by the column
name
e_foreigncurrency
The bug appears if the string 'foreign' is succeeded by a non-space
character in a CREATE TABLE statement.
Workaround: change the column name to e_currencyforeign, for example.
Fixed in
Hi,
I have 2 Tables one with the data (lets call the Table Data) and one with Category
information (let's call it Category). I have a third Table (dat2cat)
with FK_Data and FK_Category that i use to assign up to n categorys to each Dataset in
Data.
I now want to get a list of datasets with
Oh sorry,
in my posted version of the Query i forgot a Group by clause. the Query that i have
used is:
select data.name from data, dat2cat where data.pk_data =
dat2cat.fk_data and (dat2cat.fk_category=44 or dat2cat.fk_category = 18)
group by data.name having count(data.name) 1;
Simon
Hi there.
Just recently I have started to investigate a possible future use of
mySql at my company. As part of this investigation I have come across
one seemingly trivial obstacle, but an obstacle very important for me.
What I wonder is if there is no means of renaming a column in a sql
select
Hi,
after ./configure, make, make install of Version 4.0.1-alpha I executed the
mysql_install_db script to finish the installation of mysql.
The script says I should execute the commands
$/mysql/bin/mysqladmin -u root password 'mypass'
$/mysql/bin/mysqladmin -u root -h admin08-1 password
Hi,
How to update data in table with data from other table in single SQL
command (without using loop)?
Sommai,
--
Please be informed that all e-mail which are addressing to
thaithanakit.co.th will need to be changed to
Jason,
Friday, February 15, 2002, 9:33:14 PM, you wrote:
JGE what affects the rows in the host table of database mysql? is it when a
JGE particular host logs in the server's mysql console? or is it when a user
JGE browses a web file that launches a script to access a database? or both?
Table
Soory its not possible.
Here a User Comment from the Commented MySqlDoc (Chapter UPDATE Systax)
--
Comments:
Michael Holopainen: I was looking for info on how-to UPDATE with data retrived from
another table. aka. UPDATE with JOIN.
I noticed many other people were asking the same
Sorry its not possible.
Here a User Comment from the commented MySql Doc (Chapter UPDATE Systax)
--
Comments:
Michael Holopainen: I was looking for info on how-to UPDATE with data retrived from
another table. aka. UPDATE with JOIN.
I noticed many other people were asking the same
HI
Hi,
How to update data in table with data from other table in single SQL
command (without using loop)?
Sommai,
insert into table1 select * from table2
Kittiphum Worachat,MT.
www.hatyailab.com
-
Before posting,
Mikaela Holmberg a écrit :
Hi there.
Just recently I have started to investigate a possible future use of
mySql at my company. As part of this investigation I have come across
one seemingly trivial obstacle, but an obstacle very important for me.
What I wonder is if there is no means of
Thanks for all the answers, you all seemed very surprised by the
seemingly easy answer
SELECT old_name as new_name FROM ...
which made me feel rather at ease. I realized the problem wasn't with
mySQL - for it certainly did work as it should. even my way - without
the as. Problem was with darn
I want to update existing data not insert new data.
sommai
At 16:52 15/2/2002 +0700, Kittiphum Worachat wrote:
HI
Hi,
How to update data in table with data from other table in single SQL
command (without using loop)?
Sommai,
insert into table1 select * from table2
Kittiphum
thank you very much. I have to used loop for this solution, did I?
sommai
At 04:53 15/2/2002 -0500, [EMAIL PROTECTED] wrote:
Sorry its not possible.
Here a User Comment from the commented MySql Doc (Chapter UPDATE Systax)
--
Comments:
Michael Holopainen: I was looking for info on
System,
Friday, February 15, 2002, 5:38:51 AM, you wrote:
jr i made the mistake of changing my root password manually in the mysql
jr database. after doing so, i 'flushed privileges'.
jr now i'm unable to log on using the root. i've tried to log on using the new
jr password a number of
Yeah, for me also find error.
--
mysql create table X1(name varchar(10));
Query OK, 0 rows affected (0.00 sec)
mysql insert into X1 values(5);
Query OK, 1 row affected (0.01 sec)
mysql RENAME
I am afraid it's not a bug, rather a syntax error.
please follow the syntax to rename the table:
mysql alter table X1 rename as X2;
Regards,
~ SubbaReddy .M
- Original Message -
From: SubbaReddy M [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, February 15,
Hi
Currently, I maintain two mysql server, hosted by separate ISPs, and
keep them synchronised using standard MySQL replication.
Server A is master+slave to server B, and likewise server B is master
+slave to server A.
This allows both servers to receive inserts/updates/deletes and
Hi!
On a site I'm developing I need to conduct boolean searches. I use a
piece of code I found on:
http://www.evolt.org/article/comment/18/15665/http://www.evolt.org/art
icle/comment/18/15665/
and I've got to say it works really well.
The problem is I cannot search for one specific word
Someone in the list posted the following links. I went with the second one
and it worked.
NOBBY
http://www.convert-in.com/acc2sqlp.htm
http://ultradev.buzzinet.co.uk/mysql/tutorials/converting_data/index.asp
http://www.winmysql.com/
- Original Message -
From: Fabio Amura [EMAIL
Okay is not a reply for myself :) is only for add a question... :)
I read that mysql 4 will fix this, but mysql 4 is stable? I mean i'm on
production, i'm not selling mysql :) I mean I have a big projet in test
using mysql.. so if it crash it will be very bad for me... someone had test
mysql 4?
* Egor Egorov
FL = Fred Lovine
FL CREATE TABLE X1 (x smallint);
FL insert into X1 values(5);
FL RENAME TABLE X1 TO X2;
FL is producing the following error:
FL 7 - Error on rename '.\db\X1.MY1' to '.\db\X2.MYI' (Errcode: 13)
FL The problem seems to be caused by using uppercase table
Brent,
What Rick said is absolutely correct and you probably are obsessing about
something that doesn't matter. But I would venture you are using an
auto-number field as the primary key when you could easily change it to a
function something similar to: set ID = MAX(ID) + 1.
Keith,
Once tables are CREATEd, the name is listed in SHOW tables using lower case
characters, regardless of the case
used in the CREATE command.
Using upper case table names in RENAME results in the error.
Workaround: Using lower case equivalent table names works, regardless of the case used
in the
SubbaReddy M
I am afraid it's not a bug, rather a syntax error.
please follow the syntax to rename the table:
mysql alter table X1 rename as X2;
Why do you say this?
Manual entry:
6.5.5 RENAME TABLE Syntax
RENAME TABLE tbl_name TO new_table_name[, tbl_name2 TO new_table_name2,...]
...
Egor,
Yours/this arrived in my InBox whilst I was addressing the original msg - please see
my other reply/ies.
Error still occurs when running as Administrator on WinNT and root under MySQL
- definitely no access/permission issues.
Lower case works (please see earlier reply).
If I/my NT PC can
Kedryna, Bartosz writes:
In mysqldump.c there is // in 2 places, older compilers don't like it,
changing to /* */ fixes the problem.
Bart Kedryna
Software Engineer
Online Support
[EMAIL PROTECTED]
(215) 386 0100 x1470
ISI
3501 Market Street
Philadelphia, PA 19104
Thank you, this
Hi,
this has to be a bug. It seems on windows RENAME TABLE old TO new only
works for uppercase table names _after_ an ALTER TABLE old RENAME AS
new _or_ if you first rename the table using lower case letters:
mysql create table U1 (id int);
Query OK, 0 rows affected (0.04 sec)
mysql insert
Roger,
Friday, February 15, 2002, 1:32:13 PM, you wrote:
RB * Egor Egorov
FL = Fred Lovine
FL CREATE TABLE X1 (x smallint);
FL insert into X1 values(5);
FL RENAME TABLE X1 TO X2;
FL is producing the following error:
FL 7 - Error on rename '.\db\X1.MY1' to '.\db\X2.MYI' (Errcode: 13)
* Joao Verde
The problem is I cannot search for one specific word because, even
though the word exists on several records, MySQL never returns any
rows.
The word I can't look for is portaria. Any other word works just
fine. I have tried every word I could think of and it works... except
Hi Brumpton,
From the webserver, try to connect to port 3306 with telnet
Example:
telnet 10.0.0.2 3306
You should see someting like: 3.23.47♥hAJ3\Y+e☻
This means that the right ports are open on the firewall to connect to
Mysql.
-Original Message-
From: Victoria Reznichenko
Hello mysql,
I dropped an entire database but I have the frm, myd and myi files
in a backup.
What are the complete steps to restoring this database?
Thank you for the help.
--
Best regards,
Paul mailto:[EMAIL PROTECTED]
Hi,
I've got query like this:
select count(ID) from TABLE where (TABLE.A + TABLE.B + TABLE.C + TABLE.D)
0
A,B,C,D are decimal values.
There are over 1 records where A is greater than 0,
about 1000 where B is greater than 0,
about 500 where C is greater than 0,
and about 300 where D is
* Przemyslaw Popielarski
I've got query like this:
select count(ID) from TABLE where (TABLE.A + TABLE.B + TABLE.C +
TABLE.D) 0
A,B,C,D are decimal values.
There are over 1 records where A is greater than 0,
about 1000 where B is greater than 0,
about 500 where C is greater than
Just copy the backup files into the database dir and the database should be
back.
Lars
At 08:22 AM 2/15/2002 -0500, Paul wrote:
Hello mysql,
I dropped an entire database but I have the frm, myd and myi files
in a backup.
What are the complete steps to restoring this database?
Hi mysql list members,
We use the following statements to setup users and rigts for a mysql
server which is accessible locally and via internet:
INSERT INTO mysql.user VALUES
('%','xyz00',PASSWORD('...'),
'N','N','N','N','N','N','N','N','N','N','N','N','N','N');
INSERT INTO mysql.db VALUES
Friday, February 15, 2002, 2:23:52 AM, Lars Heidieker wrote:
Just copy the backup files into the database dir and the database should be
back.
Are you sure that it's not need to CREATE it first ?
At 08:22 AM 2/15/2002 -0500, Paul wrote:
Hello mysql,
I dropped an entire database but I
I've got query like this:
select count(ID) from TABLE where (TABLE.A + TABLE.B + TABLE.C +
TABLE.D) 0
A,B,C,D are decimal values.
The problem is, I think, with NULL columns. Often B,C and D don't
have decimal value, but NULL.
I thought, that this should be counted like zero. Am
Michael Hoennig [EMAIL PROTECTED] wrote:
Hi mysql list members,
We use the following statements to setup users and rigts for a mysql
server which is accessible locally and via internet:
INSERT INTO mysql.user VALUES
('%','xyz00',PASSWORD('...'),
Hi Dimitry,
But we can NOT connect locally by host:port:
local-system mysql -h 66.70.34.150 -O 3307 -u xyz00 -p
= ERROR 1045: Access denied for user: 'xyz00@localhost' (Using
password: YES)
On a mysqld which is accessible only locally the both INSERT
statements above
Description:
When trying to install MySQLi 3.23.47 and 3.23.48 on FreeBSD 4.5, We get the
following errors
during the mysql_install_db.
/usr/local/bin/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
The RENAME syntax is correct, please see the following documentation:
http://www.mysql.com/doc/R/E/RENAME_TABLE.html
-Original Message-
From: SubbaReddy M [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 5:23 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Suspected
Hi
I see:
local-system mysql -h 66.70.34.150 -O 3307 -u xyz00 -p
hmm.
I always use:
mysql -u xyz -p -h ... -P 3306
Is the -O option in the right place. Maybe it sould be -P like PORT. Isn't
??
Regards.
I. Piasecki - webmaster www.b-c.pl
- Original Message -
From:
* IvanLatysh
I've got query like this:
select count(ID) from TABLE where (TABLE.A + TABLE.B + TABLE.C +
TABLE.D) 0
A,B,C,D are decimal values.
The problem is, I think, with NULL columns. Often B,C and D don't
have decimal value, but NULL.
I thought, that this should be
Hi Ireneusz,
Hi
I see:
local-system mysql -h 66.70.34.150 -O 3307 -u xyz00 -p
hmm.
I always use:
mysql -u xyz -p -h ... -P 3306
Is the -O option in the right place. Maybe it sould be -P like PORT.
Isn't??
sorry, typo in my mail. -P of course.
Alles Gute wünscht
I think there are a couple of bugs here:
First, per the documentation, 6.1.3 Case Sensitivity in Names
(http://www.mysql.com/doc/N/a/Name_case_sensitivity.html), the Windows
mysqld is starting with -O lower_case_table_names=1 by default, so all
filenames should be converted to lowercase
Hello,
Well, for my project at work, I've done some small benchmarking
of different table types for relatively small sizes (some tens
or hundreds of thousands rows - small enough so that key buffer size
and other memory factors should not limit performance) and lots of
very simple operations. I
Michael Hoennig [EMAIL PROTECTED] wrote:
But we can NOT connect locally by host:port:
local-system mysql -h 66.70.34.150 -O 3307 -u xyz00 -p
= ERROR 1045: Access denied for user: 'xyz00@localhost' (Using
password: YES)
On a mysqld which is accessible only locally the both
According to the online manual the regex man page contributed by Henry
Spencer is included in the source distribution of MySQL. I'm hesitant to
download
and install a source distribution just to get a man page. Is it found
anywhere else?
thanks,
Joseph Polanik
Hello,
I'm encountering a serious program fault at using MySQL Win32 client library
LIBMYSQL.DLL.
I found LIBMYSQL.DLL not thread-safe. When 10 threads are launched to run
the following two blocks of C statements, very quickly a program fault
window pops up to LIBMYSQL.DLL.
block #1
Joe,
you can find it here:
http://arglist.com/regex/
Peter
On Fri, 15 Feb 2002, Joe Polanik wrote:
According to the online manual the regex man page contributed by Henry
Spencer is included in the source distribution of MySQL. I'm hesitant to
download
and install a source distribution
Hi everybody,
This seems to be a definite defect in MySql. While inserting a String into
a MySql attribute defined as VARCHAR or VARCHAR BINARY, etc., if a '\' is
present in the String, it is simply disregarded, and the remaining part of the
String gets inserted. For inserting a '\', we
http://www.google.com/search?q=regex+man+page
-Original Message-
From: Joe Polanik [mailto:[EMAIL PROTECTED]]
Sent: Friday, 15 February 2002 3 12
To: [EMAIL PROTECTED]
Subject: Regex man page
According to the online manual the regex man page contributed by Henry
Spencer is
Bryan,
I apologise, did I mistakenly call you Brent earlier!?
Indeed. I have a relatively large (few dozen) number
of tables that are accessed via PHP and a web
interface. The script pulls information from these
tables to generate pull-down menus. It would be nice
if these pull-down menus
Hello everyone
I've read about replication mechanism in MySQL, but I've still got some
reservations regarding transactions.
In the manual thay say that in case of a transaction, all update
instructions are hold in a cache, and on commit they are written to the
binary transaction log. After the
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:
Hei
I think we have found a bug in mysql replication.
We have some programs that are working against a master DB and that use
temporary tables. The hole system works without problems until we run a
flush master/slave. Then the replication in the slave DB stops working
because of this.
How
How would you do:
set field='Jim said, that's crazy.'
you would have to escape the quote somehow. The '\' is the escaper
character.
set field='Jim said, that\'s crazy.'
That means hat the escape character must also be escaped.
Check the manual for the section on special characters.
Most
On Fri, Feb 15, 2002 at 12:16:01PM +0200, Egor Egorov wrote:
System,
Friday, February 15, 2002, 5:38:51 AM, you wrote:
jr i made the mistake of changing my root password manually in the mysql
jr database. after doing so, i 'flushed privileges'.
jr now i'm unable to log on using the
Hi,
Could you tell me about your TABLE-definition and
version number of your JDBC Driver?
I will check that problem.
"Stancescu, Catalina" wrote:
I have a servlet in which I connect through a mysql driver to the
database. The servlet has a string that represents the date in the
Hi,
we're using myodbc2.50.36 with W2k and W98 to connect to our mysql-server
(Linux Kernel 2.2.18 - MySQL Version 3.23.38) in the internet. When we send
or receive larger amounts of data (we're using Visual Foxpro 7.0 as
frontend) we get the aborted connections-Message in the mysql errorlog
Spoiler: Venu's Suggestion about Dynamic Cursor is the answer
On Thu, 2002-02-14 at 20:34, Venu wrote:
MyODBC, as compiled today, uses mysql_store_result to get records. This
is fine for reasonably sized tables. However, if the table has millions
of records, writing the results to a
Dear Sir/Madam
I'm fifth year student from Poland. I'm studying at Academy of Minnig and Metalurgy in
Cracow (major Electrical Engineering). At the present I'm writing my master thesis. I
consider how processors with embedded interface TCP/IP can be used in distributed
system data collecting.
Hello all,
I searched the archives and found no similar problems, so here goes...
Using an almost straight out of the manual example, I am unable to
do a fulltext search using IN BOOLEAN MODE
using the following SQL statement:
SELECT * FROM parts
WHERE MATCH (description)
AGAINST (+brake +pad
Hello All,
I am new to this list and hope that someone could answer this
question for me.
I am running on a fresh install of Redhat 7.2 and am trying to
connect to MySQL from a program that I have to test the connections,
but am getting error messages saying that the host in not allowed to
Hi Gurus,
I downloaded and installed MySql successfully, on a Windows 2000 O/S. I want
to locate the my-example.cnf file, copy it to my root directory and rename
it my.cnf. However, the my-example.cnf file I locate is a shortcut,
pointing to no physical target. As a result, after going through
Whenever I try to issue a query which has a left join for two tables and a
where clause for a column in the second table that is a varchar the query
runs indefinitely. If I change the where clause to search on a numeric type
column the query runs and returns expected values.
Does anyone know
does your test app connect with root as the user?
-Original Message-
From: Lonnie Cumberland [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 12:12 PM
To: [EMAIL PROTECTED]
Subject: connections to MySQL
Hello All,
I am new to this list and hope that someone could answer this
Show us your table structure, some table values and the SELECT statement
that works and the one that doesn't
-Original Message-
From: Miretsky, Anya [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 12:13 PM
To: '[EMAIL PROTECTED]'
Subject: Left Join problem - Please Help
Hi all,
If one uses the timestamp data type for a column inside a table, when
executing an update query on said table on a spesific record, will the
timestamp column be updated as well or will it retain its first value?
Thanks for any info in advance,
George
mysql, query, sql
timestamp is automatically updated
-Original Message-
From: George Labuschagne [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 1:20 PM
To: [EMAIL PROTECTED]
Subject: When does the timestamp field gets updated?
Hi all,
If one uses the timestamp data type for a column inside
Only the first TIMESTAMP field gets updated when an updat to a record is
made, so if you want to maintain the time a record was created, and when it
was updated, use two timestamp fields, the first field will be the time
updated, but to do this you must initialize the second timestamp field
Hi Darrin,
This is very starnge as I just installed two FreeBSD 4.5 machines
this week and had no problems! I installed on SMP based machines,
with very few changes from the GENERIC kernel. Is this a fresh
install of FreeBSD 4.5? If not can you run a 'make world' and 'make
kernel' again?
ADO supports ODBC drivers and all ODBC functionality as well as the newer
ADO/OLEDB interfaces. You should be fine with the ODBC.
Michele Harlass
DBA
AbcEd.com, Inc
-Original Message-
From: Guy Davis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002 1:29 PM
To: [EMAIL
Bonjour Jean-françois,
Le DESC qui utilise l'INDEX est un fonction de MySQL 4.0. Il y a
un bug en la version 4.0.1 (Quelque fois il n'utilise pas l'index
descendre ) mais pour la plus part ça marche bien. En autre il y a un
forum de MySQL en français à:
Liens utils :
Poster un message:
I don't think it's hanging. I think it's going through the process of
determining joint criteria for 11,900 table entries multiplied by 88,000
other table entries, then doing a text search on the result, which is much
slower than an integer search.
I'm posting this back to the mysql list to see
possibly
-Original Message-
From: Miretsky, Anya [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 2:32 PM
To: 'Rick Emery'
Subject: RE: Left Join problem - Please Help
When I do this without specifying a left join with just :select biblio.*
from biblio,keyword where
Hello,
I am having trouble with Mysqld unexpectedly crashing.
I am running mysqld in a situation where there is a nearly constant
load on 6 databases, each with about 20 open connections (mostly
inserts and selects, occasionally a delete). Once every 3-4 days, at
seemingly random points (i.e.
I have a written a Windows client that accesses a MySQL server (Linux)
via the MySQL C API. Stored in the MySQL database are large files
(larger than a Mbyte). The C API makes it very easy for the client to
query and alter the database. However, I have some special needs that
don't appear to
I need some help here. Let's see if I can clearly describe it.
I have a database containing news stories. Each story is assigned a
rating (1 thru 5) indicating its importance. (A story with a rating of 5
is more important than a story with rating of 1.)
Now, lets say that there are ten
Description:
The errors and crashes herein are related to the use of a software
package called Phorums... version 3.2.11... The query that was crashed
on here, is made against the phorums3211 database.
Log errors as follows:
--
020209 13:52:17 Aborted
How about
SELECT * FROM news WHERE rating = 4
ORDER BY rating DESC, RAND() LIMIT 1;
Michael
On Fri, 15 Feb 2002, Brent Macnaughton wrote:
I need some help here. Let's see if I can clearly describe it.
I have a database containing news stories. Each story is assigned a
rating (1
At 13:35 15/02/2002 -0500, Juwon Aikulola wrote:
Hi!
Hi Gurus,
I downloaded and installed MySql successfully, on a Windows 2000 O/S. I
want to locate the my-example.cnf file, copy it to my root directory and
rename it my.cnf. However, the my-example.cnf file I locate is a
shortcut, pointing to
Hi,
I am trying to install run MySQL version 3.23.43-pc-linux-gnu-i686. When
I try to run it to finish installation and set up users, i get the
following error:
/usr/local/mysql# mysql start
su: mysql: command not found
I have also tried running MySQL with the mysqld start, mysqld, and mysql
Prefix it with the path:
/usr/local/mysql/mysqld start
or whatever.
On Friday 15 February 2002 3:16 pm, Mark M Jervis Jr. wrote:
Hi,
I am trying to install run MySQL version 3.23.43-pc-linux-gnu-i686. When
I try to run it to finish installation and set up users, i get the
following
* Miretsky, Anya
Select distinct
biblio.* from biblio left join keyword on
biblio.p_biblio=keyword.fk_biblio
where keyword=SOMESTRING;
Try swapping the tables:
Select distinct
biblio.* from keyword left join biblio on
biblio.p_biblio=keyword.fk_biblio
where keyword=SOMESTRING;
The left
Hi there,
I'm having som difficulties trying to figure out MySQL's unique indexes
and primary keys.
Case:
mysql create table flaf (lala varchar(20) not null, unique(lala));
Query OK, 0 rows affected (0.00 sec)
mysql insert into flaf VALUES ('hest');
Query OK, 1 row affected (0.00 sec)
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `' and `').
SEND-PR:
From: pengzhao
To: [EMAIL PROTECTED]
Subject: Msql-Mysql-modules-1.2219 fails in the test, on Itanium machine
Description:
Hi List,
I am new to the MySql C++ API and I am compiling one file it gives me error
saying
Error E2303 ..\..\include\sqlplus\resiter1.hh 56: Type name expected
Error E2275 ..\..\include\sqlplus\resiter1.hh 56: { expected
Error E2275 ..\..\include\sqlplus\resiter1.hh 56: { expected
and many
George/Rick, a quick addition.
It is not clear from the question: do you want to have the timestamp updated, or do
you want to leave it be?
RTFM:
6.2.2.2 The DATETIME, DATE, and TIMESTAMP Types
...
The TIMESTAMP column type provides a type that you can use to automatically mark
INSERT or
On Tuesday 12 February 2002 09:23 pm, you wrote:
Sasha,
I compressed it first, 'cause it was nearly 400MB in size. It's on
the FTP site as mysqld.core.bz2.
Jeremy - in case you are wondering why it is taking me so long to reply -
we've made a mess on our Linux build machine before the
I see people speaking about mysql 4.0.2... but where you get it? they write
some thing about it on web page but 4.0.2 is not in the download list...
maybe someone can say if mysql 4 is stable? I mean if I can use it without
100 crash in 1 hour :)
Sorry for bad english :)
Jean-Francois Dionne
On Fri, Feb 15, 2002 at 08:03:19PM -0500, Jean-Francois Dionne wrote:
I see people speaking about mysql 4.0.2... but where you get it?
they write some thing about it on web page but 4.0.2 is not in the
download list...
It's from the MySQL source tree. See this url:
So it's better using 4.0.1 of 4.0.2?
Jean-Francois Dionne
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Jean-Francois Dionne [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, February 15, 2002 8:12 PM
Subject: Re: information on mysql 4.0.2
On Fri, Feb 15, 2002
Hi,
No problem so far with mysql 4.0.x, no crash at all on a production server
with a really high load.
If you want to use mysql 4.0.2, take a look here :
http://www.mysql.com/doc/I/n/Installing_source_tree.html
Best Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From:
Hi Andreas,
On Sat, 2002-02-16 at 08:52, Andreas Frøsting wrote:
Why does MySQL have this strange behavoir, treating unique indexes
case-insensitive?
Can anyone explain MySQL's behaviour and how I do a workaround making
unique indexes and primary keys case sensitive?
I've been over the
Wouldn't replace change all the entries in your table row, same effect as update?
I believe the question is how to test which entry in a form has a new value and
replace/update only that value in the table.
If I have a form...
__
|Employee Record Update|
|
or you can try...
/usr/local/mysql# ./mysql start
Christopher Thompson wrote:
Prefix it with the path:
/usr/local/mysql/mysqld start
or whatever.
On Friday 15 February 2002 3:16 pm, Mark M Jervis Jr. wrote:
Hi,
I am trying to install run MySQL version 3.23.43-pc-linux-gnu-i686. When
I
Hi John,
On Sat, 2002-02-16 at 06:52, John D Siirola wrote:
I am having trouble with Mysqld unexpectedly crashing.
How-To-Repeat:
Unfortunately, I do not know how to consistently cause the
crash to repeat.
Yeah, that's always a bit tricky; and can make it very hard for the
In Callbacks or External Procedures?, [EMAIL PROTECTED] wrote:
Is there _any_ way to do something like Oracle's OCI callback functions?
What I need to do:
Whenever my MySQL database changes data (inserts, updates, whatever) I need
to call some of my own code.
Any ideas?
You don't specify if
1 - 100 of 109 matches
Mail list logo