Does REPLACE INTO not work in your case?
|
|
|REPLACE| works exactly like |INSERT|, except that if an old record
in the table has the same value as a new record for a |PRIMARY KEY|
or a |UNIQUE| index, the old record is deleted before the new record
is inserted. See section 14.1.4
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I'm trying to move my Mambo (content management) database from one server into
another.
In the old server, the mysql version is 4.0.13, while in the new one it's
4.0.15.
The error was when restoring:
ERROR 1064 at line 141: You have an
Hi All,
How can we optimize MySQL queries, plz define easy method
comparing as well as better performance for data retrieval.
Regards:
aaziz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
try using explain
Hi All,
How can we optimize MySQL queries, plz define easy method
comparing as well as better performance for data retrieval.
Regards:
aaziz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Abdul Aziz [EMAIL PROTECTED] wrote:
How can we optimize MySQL queries, plz define easy method
comparing as well as better performance for data retrieval.
The following chapter of the manual will be helful to you:
http://dev.mysql.com/doc/mysql/en/Query_Speed.html
--
For
[EMAIL PROTECTED] wrote:
Hi, I am trying to use the foreign key constraints from InnoDB
and creating indexes is a requirement for foreign key.
The problem is that by creating index for my foreign key,
it does not allow my foreign key to have null or blank values which my records will have.
For eg.
[EMAIL PROTECTED] wrote:
Hi, I am trying to use the foreign key constraints from InnoDB
and creating indexes is a requirement for foreign key.
The problem is that by creating index for my foreign key,
it does not allow my foreign key to have null or blank values which my records will have.
For eg.
Fajar Priyanto [EMAIL PROTECTED] wrote:
Hi all,
I'm trying to move my Mambo (content management) database from one server into
another.
In the old server, the mysql version is 4.0.13, while in the new one it's
4.0.15.
The error was when restoring:
ERROR 1064 at line 141: You have an
Hi,
On Wednesday 26 May 2004 11:22 pm, [EMAIL PROTECTED] wrote:
Hi, I am trying to use the foreign key constraints from InnoDB
and creating indexes is a requirement for foreign key.
The problem is that by creating index for my foreign key,
it does not allow my foreign key to have null or
Hello,
I run into a problem after re-installing mySQL 4.1.1 today. When I
tried to start the service on my Windows2K, I got the following error:
040527 15:37:49 Fatal error: Can't open privilege tables: Table
'mysql.host' doesn't exist
Can some one tell me how to solve the
Carlos Sunden [EMAIL PROTECTED] wrote:
Installed the MySQL-server-4.0.20-0.i386.rpm on a RHL8 system
Initialized the grant tables and then did:
/usr/bin/mysqladmin -u rt password ACTUALPASSWORD
And got:
-bash: /usr/bin/mysqladmin: No such file or directory
What gives mates?
I had used
There is one instance in which it is *not* convenient to store in seperate
files: when you are exporting to another machine (maybe a sub set of data
from an internal server to an external web server) or doing replication.
j- k-
On Wednesday 19 May 2004 01:01 pm, Greg Willits said
I'm working on an add/edit form, illustrated by the
screehnshot at http://www.geoworld.org/addedit2.gif
I decided to arrange the rows by ID, rather than
alphabetically. So I opened the table in phpMyAdmin,
clicked Operations, then changed Order by from a
field named SCode to ID. When I clicked
Mauricio Pellegrini [EMAIL PROTECTED] wrote:
I'm using MySql 4.0.18 on Linux (SuSE 8.2)
and I'm getting this error
ERROR 2013: Lost connection to MySQL server during query
a few seconds after launching
the following command
LOAD DATA LOCAL INFILE '/root/hc.txt' into
Check permissions on the mysql\data directory and files/folders below
for the MySQL process/user (sorry for not knowing the right Windows
terminology, I'm not a Windows user).
HTH,
Robert J Taylor
[EMAIL PROTECTED]
michael_wu[§d§»¹F] wrote:
Hello,
I run into a problem after re-installing
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 27 May 2004 02:56 pm, Victoria Reznichenko wrote:
OPTION is a reserved word in MySQL:
http://dev.mysql.com/doc/mysql/en/Reserved_words.html
Use backticks to quote column names: `option`.
--
For technical support contracts,
I'm working on an add/edit form, illustrated by the
screehnshot at http://www.geoworld.org/addedit2.gif
I decided to arrange the rows by ID, rather than
alphabetically. So I opened the table in phpMyAdmin,
clicked Operations, then changed Order by from a
field named SCode to ID. When I clicked
Joshua J. Kugler wrote:
There is one instance in which it is *not* convenient to store in seperate
files: when you are exporting to another machine (maybe a sub set of data
from an internal server to an external web server) or doing replication.
Very true. We use MySQL to store our blobs for
Thanks for all the feedback. Here's my latest attempt:
SELECT @start:=NOW();
SELECT @date1:=DATE_SUB( CURDATE(), INTERVAL 1 MONTH);
SELECT @date2:=CURDATE();
LOCK TABLES rptPricingTEST READ, rptPricingTEST a READ;
CREATE TEMPORARY TABLE tmpLatestDates
SELECT
commodity,
Since the database I created was not critical, I could simply throw it away.
Therefore,
delete the whole MySql installation directory and unzip the alpha release
zip file again
to create the installation directory tree. However, the following error
persists:
Fatal error: Can't open
Did you change the permissions for the files to include
read/write/change for the user/account MySQL uses on your system? This
doesn't require deleting, as far as I recall Windows permissions...
Oh, can you verify that the file host under directory mysql DOES exist?
If so, it's really most
David Blomstrom wrote:
I'm working on an add/edit form, illustrated by the
screehnshot at http://www.geoworld.org/addedit2.gif
I decided to arrange the rows by ID, rather than
alphabetically. So I opened the table in phpMyAdmin,
clicked Operations, then changed Order by from a
field named SCode to
Only constant values are allowed as default values. If this is the first
timestamp column it will be updated on insert and with every update.
-Original Message-
From: Scott Haneda
To: MySql
Sent: 5/26/04 8:20 PM
Subject: Defaul of NOW()
I have a field in mysql 4, using InnoDB
Field is
You could create a special borrower account to signify that it is not
loaned out and assign that to the book. If this is for a library system
(multiple branches) you could create one account for each branch. That way
you would know where the book is at all times, borrowed or not ;-)
Shawn
Ok.
So far I got advises to install the MySQL-client package the mysql-devel RPM.
Will do that report back.
I wouldn't think all that was needed when the MySQL-server-rpm was installed. The
functionality to assign a password should be there.
I'm such a newbie at this, thanks to all again!
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 27 May 2004 03:00 am, Martijn Tonies wrote:
Why not? What's wrong with this:
BORROWER
BorrowerID
BOOKS
BookID
BorrowerID (nullable)
FK from Books.BorrowerID to Borrower.BorrowerID
I haven't checked, but this _should_ be
http://dev.mysql.com/doc/mysql/en/INSERT.html
INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name [(col_name,...)]
VALUES ({expr | DEFAULT},...),(...),...
[ ON DUPLICATE KEY UPDATE col_name=expr, ... ]
If you specify the ON
Hi,
Why not? What's wrong with this:
BORROWER
BorrowerID
BOOKS
BookID
BorrowerID (nullable)
FK from Books.BorrowerID to Borrower.BorrowerID
I haven't checked, but this _should_ be possible.
With regards,
Its a foreign key, you can not null foreign keys.. Thats the
I didn't think you could have a DEFAULT of NOW() because it's not a true
static value. Seems I read that in one of Paul DuBois' books.
Jim Winstead wrote:
On Wed, May 26, 2004 at 06:20:22PM -0700, Scott Haneda wrote:
I have a field in mysql 4, using InnoDB
Field is timestamp 14 and defualt is
I wished to use MySQL clustering for application development that is Windows-based.
Since the binaries aren't available as yet, I tried using the source distribution
(tried to build using cygwin) but it gave a number of errors.
Is there any other way of installing MySQL 4.1 with Windows ( that
Something I have done in the past (with another DB system) was to put
indexes on my temp tables. I have just gone over my copy of the MySQL docs
and I don't see where that is NOT allowed so I think its fair game to try
it.
You have two options to do this:
Create the temp tables then populate
Folks,
Following some advices, I have decided to give FreeBSD a shot. So, I got
one test machine (P4 2.0GHz, 512MB), installed FreeBSD 5.2.1 on one
disk, and OpenBSD 3.5 on the other (both 40GB 7200RPM IDE disks) -- so I
could compare the results.
MySQL (4.0.20) is compiled from source,
Hi,
I was running the test-select under the /usr/local/mysql/sql-bench dir and was
wondering if someone could help break it down for me ( Or at least the Testing big
selects on the table section ) Thanks :
[EMAIL PROTECTED] sql-bench]# perl test-select --password='d'
Hello
Libraries and header files RPM download at
http://dev.mysql.com/downloads/mysql/4.0.html
is the mysql-devel package, right?
Thanks!
Carlos
-
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger
In C API, after running mysql_query(), I want to stop
this query by mysql_kill(). But I can not get the
specific process (query) ID. How could I solve this
problem?
mysql_list_processes() return a list of all processes
(quries) running on the server. But it is possible
that different user may
On Tue, May 25, 2004 at 03:36:08PM -0600, Sarix wrote:
Cause when I do my web end to all this life
is easy cause I can do $name = $row['Name'] and it works for PHP so I
figured there has to be an API that would do that.. But I can't seem to find
it in the documention. Is there something that
Hi,
I included the following statement in my.ini:
log=c:\log.txt
I then executed some queries.
The file log.txt only shows the following:
MySql, Version: 4.0.13-nt-log, started with:
TCP Port: 3306, Named Pipe: MySQL
Time Id CommandArgument
040527 9:31:57 1
hi mark,
If you specify UTF-8 as the characterEncoding connection property, then
that is the transform that is used from client - server. The transform
that is used from server - client is whatever character set the column
in the table is set to when you created the table (or conversely if you
use
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
robert kuzelj wrote:
hi mark,
If you specify UTF-8 as the characterEncoding connection property, then
that is the transform that is used from client - server. The transform
that is used from server - client is whatever character set the column
Hi,
I am trying to add this info into a table and I know there is a way to do it without
using the insert command on every line of data.
201 200 NJ Jersey City
INSERT INTO categories VALUES ('201', '200', 'NJ', 'Jersey City');
there are way too many lines to do by manual inserts.
Any
Facing this new scenario, I am going to give Linux a shot --
definitively, this one is going to outperform OpenBSD. Using the same
hardware, and the same options (as possible).
Does anyone have a hint for this?
Again, thanks a lot!
Best regards,
RV Tec
I am a FreeBSD user, but
How is the data delimited? You may be able to use the LOAD DATA INFILE
command.
-Original Message-
From: Haplo
To: [EMAIL PROTECTED]
Cc: Paul
Sent: 5/27/04 12:23 PM
Subject: Textfile to table
Hi,
I am trying to add this info into a table and I know there is a way to
do it without using
I will try that.
Thanks.
- Original Message -
From: Victor Pendleton [EMAIL PROTECTED]
To: 'Haplo ' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: 'Paul ' [EMAIL PROTECTED]
Sent: Thursday, May 27, 2004 1:28 PM
Subject: RE: Textfile to table
How is the data delimited? You may be able to use
Hi,
Is it possible to write a SELECT statement that will select all columns but 1 or 2
certain ones?
I know I can do SELECT Col1,Col2,Col3 etc. but if there are a few columns, I would
like to be able to do somehting like SELECT * (NOT Col12,Col13), if that makes any
sense.
Thanks
JG,
I am a FreeBSD user, but after having run benchmarks for
the past 2 weeks, I think you'll be surprised when you see
the results from Linux.
Linux will outperform *BSD by nearly double when it comes to
MySQL.
That's what I expect and hope for. Although, I thought that FreeBSD
would
Hi,
I am sure all FreeBSD users are sick and tired of saying this. USE 4.10
Lots of people blindly follow version numbers but 5.x is a lot different than 4.x in
ways I don't yet feel comfortable with using on production machines. Only one of those
issues is with benchmark numbers, but that
MYSQL [EMAIL PROTECTED] wrote:
Is it possible to write a SELECT statement that will select all columns but 1 or 2
certain
ones?
Nope.
I know I can do SELECT Col1,Col2,Col3 etc. but if there are a few columns, I would
like to
be able to do somehting like SELECT * (NOT Col12,Col13), if
Eric,
I am sure all FreeBSD users are sick and tired of saying this. USE
4.10
Lots of people blindly follow version numbers but 5.x is a lot different
than 4.x in ways I don't yet feel comfortable with using on production
machines. Only one of those issues is with benchmark numbers,
hi mark,
What happens if you explicitly specify the table character set to be
'utf-8'? (i.e. you're relying on the database default character set to
take care of that for you right now)...
'CREATE TABLE foo CHARACTER SET utf8'
the same.
All I can say is that with the testcase I posted, it is shown
Err... I guess I owe Jeremy Zawodny an apology for mistyping his name. I
promise next time I won't type without reading.
His site is at http://jeremy.zawodny.com/. And I really recommend his
book High Performance MySQL.
Sorry for the typo, Zawodny!
RV Tec
--
MySQL General Mailing List
For
Robinson, Eric [EMAIL PROTECTED] wrote:
Hi,
I included the following statement in my.ini:
log=3Dc:\log.txt
I then executed some queries.
The file log.txt only shows the following:
MySql, Version: 4.0.13-nt-log, started with:
TCP Port: 3306, Named Pipe: MySQL
Time
At 11:02 AM 5/27/2004 -0700, you wrote:
Hi,
I am sure all FreeBSD users are sick and tired of saying this. USE 4.10
Lots of people blindly follow version numbers but 5.x is a lot different
than 4.x in ways I don't yet feel comfortable with using on production
machines. Only one of those
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.0.13, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.0.13 is a bugfix release for the production tree that is
suitable for use with any MySQL version including MySQL-4.1 or MySQL-5.0.
Dear All,
The mysql client mysql-devel packages did it.
Was able to change the password which I did with a
very easy one. Now when I want to change the existing
password it fails. It does not let me.
Thanks agaiN!
--- Carlos Sunden [EMAIL PROTECTED] wrote:
Ok.
So far I got advises to install
Well, my hack (which is sort of like what you suggest) is to change my
primary key from just an auto_increment 'id' field to a combination of two
other fields (mac/scanner_id) that I know must be unique. Then I rely upon
the fact that mySQL will not allow a duplicate PK. (I did say it was a
hack).
nevermind mates, it is.
--- Carlos Sunden [EMAIL PROTECTED] wrote:
Hello
Libraries and header files RPM download at
http://dev.mysql.com/downloads/mysql/4.0.html
is the mysql-devel package, right?
Thanks!
Carlos
-
Do you Yahoo!?
Friends.
I am going to use mysql_query() and want to find out if a certain
database exists. If mysql_real_connect() fails there are many errors
that could account for this. The database may exist , and I cant take
the error returned from the failed query to mean the db isnt there and
should be created.
Description:
make v3.77 (and same with 3.8) aborts with these errors
make[2]: Entering directory `/usr/local/mysql-4.0.20/readline'
rm -f libreadline.a
false cru libreadline.a readline.o funmap.o keymaps.o vi_mode.o parens.o rltty.o
complete.o bind.o isearch.o display.o signals.o util.o
Good evening all.
I'm facing a problem with a specific table and the uniques that it has.
I have a table, hosting data of peoples names.
Some of it's columns are, name_english, surname_english, name_original,
surname_original, name_greek, surname_greek.
I have as unique each combination of
hi all,
i'm building MySQL-4.0.20 from source on OSX 10.3.3
fwiw, my build env includes:
gcc (GCC) 3.3 20030304 (Apple Computer, Inc. build 1640)
autoconf --verautomake (GNU automake) 1.8.2
autoconf (GNU Autoconf) 2.59
ltmain.sh (GNU libtool) 1.5.6 (1.1220.2.94
fr0g wrote:
Good evening all.
I'm facing a problem with a specific table and the uniques that it has.
I have a table, hosting data of peoples names.
Some of it's columns are, name_english, surname_english,
name_original, surname_original, name_greek, surname_greek.
I have as unique each
If I understand the docs correctly, I can use a config file on my client machine for
the given mysql client apps such as the mysql command line tool.
What if I'm using a 3rd-party app? Will the libraries somehow know to read the config
file or would the app have to take manual steps to do it?
Ok, I found the cause which caused the problem. I wiped out the whole
installation directory but the c:\my.cnf file was modified incorrectly.
Sine I would like to use innoDB, I had to created database subdirectories
manually. I did that but I specified datadir by mistake:
datadir =
WOuld the following scenario be possible
I currently have about 1.2 Tb of data that i need to transform into
mysql and be able to server a very high amount of pages from a
discussion board. would i be able to place the mysql/data directory in a
main server with huge storage and then have
Description: Using the GRANT command causes the password to be
deleted until 'FLUSH PRIVILEGES' is executed. This is a security
problem.
How-To-Repeat:
New 4.1 BINARY install; installed as noted in instructions.
No users except root exist.
Execute MySQL GRANT SELECT ON bugg.* TO 'cwolf'@'%';
On Thu, May 27, 2004 at 03:59:46PM -0400, Bono, Saroj AA R62 wrote:
I am going to use mysql_query() and want to find out if a certain
database exists. If mysql_real_connect() fails there are many errors
that could account for this. The database may exist , and I cant take
the error returned
As most people already know, MySQL has FullText indexing built into it, so
why is mysql.com using MnoGoSearch? (There is an icon Powered by
MnoGoSearch on the search page.)
1) Is there something wrong with MySQL's FullText search for handling a lot
of data?
2) Is MnoGoSearch better?
3) Why
On May 27, 2004, at 10:17 PM, mos wrote:
As most people already know, MySQL has FullText indexing built into
it, so why is mysql.com using MnoGoSearch? (There is an icon Powered
by MnoGoSearch on the search page.)
1) Is there something wrong with MySQL's FullText search for handling
a lot of
68 matches
Mail list logo