Jurgen--
Strange thing is, I had been able to build MySQL 4.0 - up until 3 days
ago - without any problem. All from the same Mysql development tree.
At some point, the whole thing just fell apart after a source update.
Also, there's no problem building v3.23 on the same box!
It actually looks
Sorry for the confusion. I have not checked www.MySQL.org in such a
long time.
I was referring to the period of time when NuSphere (Progress) had owned
MySQL.org and appeared to be falsely representing themselves as the
MySQL developers.
I'm sure you now know what I intended.
Regards,
Splitting a table is not realy difficult, you could use:
Create table user_info select fieldname1,fieldname2,... from
large_table_name;
But you'll probably want a connection between the new tables.
you could add a ID-record first by doing:
alter table large_table add ID int unsigned
hello friends,
mysql ..
i just want to move my database from one computer to
another ... no lan ... can be taken on a cd ...
how to plz tell me
thanx a lot
Lalit Nagpal
__
Do You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th!
Hi
there's a 'data' directory in your mysql directory. This one contains one
subdirectory for each of your databases. Just copy the one you need to your
cd and place it in the data directory on the othe computer.
markus
-Ursprüngliche Nachricht-
Von: Lalit Nagpal [SMTP:[EMAIL
Hi!!
I want to convert all the data in o2 database to
mysql...pls. can anyone guide me on that??
Thanx...
Regards,
Ritu Singla
For live cricket scores download Yahoo! Score Tracker
at:
Hi!!
I used BACKUP TABLE command to take the backup of a
table...but when i say
RESTORE TABLE, i get the following ::
mysql restore table rs from '/tmp';
+---+-+--+--+
| Table | Op | Msg_type | Msg_text
|
if it's an imposterer, its a fairly decent looking mirror :)
-bobby
- Original Message -
From: Ryan Hatch [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, May 09, 2002 10:31 PM
Subject: Re: newbie help
bd...
Two things here:
1.) Mysql.org is an
Hi,
Trying to get replication going between to W2K machines and getting the
following errors in the Slave log file.
MySql: ready for connections
020509 18:58:52 Slave thread: error connecting to master:Can't connect to
MySQL server on '' (10049)(0), retry in 60 sec
020509 18:59:54 Slave
I think a simple way is to export your o2 data into text file
then load the text files into MySQL
is it too hard?
Borus
- Original Message -
寄件者: ritu singla [EMAIL PROTECTED]
收件者: [EMAIL PROTECTED]
傳送日期: 2002年5月10日 PM 05:10
主旨: O2 to MySQL.
Hi!!
I want to convert all the data
How dangerous is OPTIMIZE TABLE?
I have been reading through the FAQ, and came to the section on OPTIMIZE
TABLE.
http://www.mysql.com/doc/O/P/OPTIMIZE_TABLE.html
That has my interest, as my MySQL XOVER database will expire articles ever
so often. But then I read a comment there that OPTIMIZE
Gartside,
Friday, May 10, 2002, 3:45:07 AM, you wrote:
G Windows 2K MySQL V ? (recent). Sorry, I'm not at my own machine at present,
G can't check actual version number.
G Installed, running and everything is ok, except I created a database called
G 'xyz' as a test then decided to delete it.
G
jk,
Thursday, May 09, 2002, 7:57:49 PM, you wrote:
jDescription:
j i installed the binaries of mysql 3.23.49 (tried both tar.gz and rpm) but cannot
execute any (neither the deamon mysqld nor the monitor mysql). i can execute scripts
but they will fail as they are
j calling mysqld
What error
Lalit,
Friday, May 10, 2002, 11:10:52 AM, you wrote:
LN i just want to move my database from one computer to
LN another ... no lan ... can be taken on a cd ...
LN how to plz tell me
You should use mysqldump utility for database backup. Some useful info
about backup and mysqldump you can find
David,
Thursday, May 09, 2002, 11:39:32 PM, you wrote:
DS MySQL is running as a Service in Windows 2000, as one might expect. Tried to
DS get the logs up and running with a my.cnf file in multiple locations,
DS including C:/ and DATADIR\my.cnf
my.cnf must be located in the root dir on C: drive!
Greetings,
Using the semi-static linux binaries to connect to localhost mysqld/mysql 3.23.47.
Can connect to the database with mysql -u -p. ODBC also OK
But I keep getting the following with the GUI:
Can't connect to local MySQL server through socket (111)
or if I specifiy IP rather than
Hi
I don't know if this is of any interrest etc, but atleast it is a small
little issue from the big, big world.
-- Forwarded message --
Date: 10 May 2002 08:41:19 -
From: PHP Bug Database [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Bug #17126 Updated:
Hi Raymond,
That's an interesting message you're getting. Obviously there is an issue with IP
address not getting to mysqld. The only thing that can make any sense to me in this
one is double check the name and location of the my.cnf file.
See ya,
Terrence
- Original Message -
From:
btw, things look much prettier if you use show slave status\G
the replicant user, and host ip address does not match your my.cnf on the
slave
master-host=20.0.0.54
master-user=echo
| Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos |
| | test| 3306
actually you may want to change [MYSQLD] to [mysqld] and restart your slave
server
I don't think it has read your my.cnf file correctly ( that means the other
settings will not have taken affect either, like password and server ID)
-Original Message-
From: Raymond Brighenti
On Fri, 10 May 2002, Jon Lochner wrote:
Greetings,
Using the semi-static linux binaries to connect to localhost mysqld/mysql 3.23.47.
Can connect to the database with mysql -u -p. ODBC also OK
But I keep getting the following with the GUI:
Can't connect to local MySQL server through
Hi,
I tried using a FreeBSD box with MySQL as the Master and W2K as the slave
and it works fine. I then swapped it so the W2K was master and I get the
following from the Unix box.
020510 14:14:22 mysqld started
/usr/local/libexec/mysqld: ready for connections
020510 14:14:22 Slave: connected
Let's see your my.cnf file.
- Original Message -
From: Azhar Khan [EMAIL PROTECTED]
Date: Wed, 8 May 2002 17:49:55 -0400
To: [EMAIL PROTECTED]
Subject: re: replication
During the replication process
hi all,
I'm in trouble trying to create a sql query to get the prev next value not
null starting from a specified point ... I mean:
table_a
id
23
24
56
62
starting from id 56, I need the id 24 the id 62 ... I've trying several
way mysql funct to do this job but w/o success :(
anyone
It should be 'username'@'localhost'
Mark Shade wrote:
Yep...
I am in as root, so I should have rights to everything.
Yep, I have confirmed that the dbname is right, but doublechecking it
multiple times. Plus, this happens even on db that I did the same thing to
only a week ago. The *
max a écrit :
hi all,
I'm in trouble trying to create a sql query to get the prev next value not
null starting from a specified point ... I mean:
table_a
id
23
24
56
62
starting from id 56, I need the id 24 the id 62 ... I've trying several
way mysql funct to do this
I need to connect to a MySQL database from a remote machine but it seems
that when the mysql was setup, that it was only setup with localhost, and
not it's hostname. IE: When I try these commands:
'mysqladmin -h ren2 --port=3306 version'
I get the following :
mysqladmin: connect to server at
mysql show slave status
- ;
+-+-+-+---+--+-+
---+-+-++---
-+--+
| Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos |
I use Perl, Php, mysql for my applications. I have a great manual for php
for mysql processes. But i do not know any manual for perl yet. Does
anyone know any manual about for perl-mysql? Better if would be .chm
version. Thanks.
-Onder
Richard Idalski a écrit :
I need to connect to a MySQL database from a remote machine but it seems
that when the mysql was setup, that it was only setup with localhost, and
not it's hostname. IE: When I try these commands:
'mysqladmin -h ren2 --port=3306 version'
I get the following :
Hello,
I have a question:
We want to real-time synchronize a MySQL database part with a distant
database.
We have a central database containing all the data. This database must share
several parts (records) with the local databases.
All transactions made in the central database must be
Hello,
I had written last week because I tried to send a mail to
[EMAIL PROTECTED] about MySQL transactions without success.
[EMAIL PROTECTED] answered me, but I can't send a mail to him.
Using set autocommit=0; doesn't fix the problem...
My problem was :
We have 2 threads using sql
through a servlet i insert my form data into my table
(primary key is auto-incremented) and then i throw
another query which is
select last_insert_id() from mytable limit 1
through my statement.executeQuery method. when i ask
for the data through
myresultset.getString(1) i get null
[snip]
My VB application has a log-in screen with two fields, userID and
userPassword.
When these are correctly filled in, MySQL logs me in and the application
opens.
But, I can also log in (as myself) if I leave both fields blank. And the
plot
thickens when considering the following VB code
This is too weird; I can quote until I see blew in the face, but I cannot
seem to make MySQL understand that the name 'group-name' is valid to select.
It keeps blabbing You have an error in your SQL syntax. I mean, what is
the purpose of its own quote function if it can not even quote properly?
[snip]
This is too weird; I can quote until I see blew in the face, but I cannot
seem to make MySQL understand that the name 'group-name' is valid to select.
It keeps blabbing You have an error in your SQL syntax. I mean, what is
the purpose of its own quote function if it can not even quote
Hi see perldoc DBI and perldoc DBD::mysql
(search.cpan.org)
Onder Hazaroglu wrote:
I use Perl, Php, mysql for my applications. I have a great manual for php
for mysql processes. But i do not know any manual for perl yet. Does
anyone know any manual about for perl-mysql? Better if would be
At 17:26 +0200 5/10/02, Mark wrote:
This is too weird; I can quote until I see blew in the face, but I cannot
seem to make MySQL understand that the name 'group-name' is valid to select.
It keeps blabbing You have an error in your SQL syntax. I mean, what is
the purpose of its own quote function
This is too weird; I can quote until I see blew in the face, but I cannot
seem to make MySQL understand that the name 'group-name' is valid to
select. It keeps blabbing You have an error in your SQL syntax. I mean,
what is the purpose of its own quote function if it can not even quote
[snip]
$sth = $dbh - prepare (SELECT expiration from newsgroups WHERE
newsgroup='$group');
$sth - execute;
$group is a newsgroup name; all queries go fine, except one that has a dash
in it. I have tried quoting $group, like:
$newsgroup = $dbh - quote ($group);
$group, btw, where it goes wrong,
On Fri, May 10, 2002 at 05:49:12PM +0200, Mark wrote:
: This is too weird; I can quote until I see blew in the face, but I cannot
: seem to make MySQL understand that the name 'group-name' is valid to
: select. It keeps blabbing You have an error in your SQL syntax. I mean,
: what is the
- Original Message -
From: Philip Molter [EMAIL PROTECTED]
To: Mark [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, May 10, 2002 6:01 PM
Subject: Re: Qoute
Try:
$sth = $dbh-prepare( 'SELECT expiration FROM newsgroups WHERE
newsgroup=?' );
$sth-execute( $group );
...
- Original Message -
From: Jay Blanchard [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 10, 2002 6:01 PM
Subject: RE: Qoute
Have you tried double-quotes? '$group' ?
Jay
I do not see how that can be done; when I do that, Perl complains of a dozen
of syntax errors because
At 17:49 +0200 5/10/02, Mark wrote:
This is too weird; I can quote until I see blew in the face, but I cannot
seem to make MySQL understand that the name 'group-name' is valid to
select. It keeps blabbing You have an error in your SQL syntax. I mean,
what is the purpose of its own quote
Hi,
I'm trying to compile mysql 3.23.49 on a compaq DS10 box running
Tru64 Unix 5.1 . The binary for ev6 doesn't seem to work on this
architecture (Alpha 21264 processor) and so I'm compiling using
the compaq c and c++ compilers (v6.2) from source.
Compaq 'make' doesn't work so I'm using 'GNU
Maybe I'm misreading what you did, but $dbh-quote($group) adds the single
quotes around the string, so using it followed by ...WHERE
newsgroup='$group' gets you
WHERE newsgroup=''name.of.group''
Also, your example sets $newsgroup using quote, but uses $group in the
query, which is a problem,
Mark,
Thursday, May 09, 2002, 7:31:28 PM, you wrote:
MS I am trying to grant rights to a new db to a new user.
MS I am issuing the following commands (with obvious substitutions):
MS mysql GRANT ALL
MS - ON dbname.*
MS - TO username@localhost
MS - IDENTIFIED BY 'password';
MS I
crashke [EMAIL PROTECTED] writes:
Hi Vadim, I don't know but have you read the instructions on the
Mysql-website?
gcc 2.96RH is a known good and stable compiler, no matter what FUD the
site might claim. The below looks like broken code, plain and simple:
Lack of declarations.
--
Trond
Well... This seems to be a typical tricky-goute-on-qoute thing...
I recommend you to test your query in mysql client directly
(if you havn't already done that).
And THEN take the battle with perls quoting mechanism...
Another tip is to just print the query before executing
so You can see
At 16:52 + 5/10/02, [EMAIL PROTECTED] wrote:
Well... This seems to be a typical tricky-goute-on-qoute thing...
I recommend you to test your query in mysql client directly
(if you havn't already done that).
There really are no tricky quote-on-quote things, except when people
try to mess
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Mark [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, May 10, 2002 6:09 PM
Subject: Re: Qoute
$group is a newsgroup name; all queries go fine, except one that has
a dash in it. I have tried quoting $group, like:
I created a table with a field define as NULL, however when I insert
values NULL , Mysql puts 0 instead of nothing ,
I don't understand why I have this trouble ,
Thanks
-
Before posting, please check:
Hey guys,
did you spot this problem?
mysql select truncate(199.20,2);
++
| truncate(199.20,2) |
++
| 199.19 |
++
1 row in set (0.00 sec)
Bug?
Mihail Manolov
Government Liquidation, LLC
202 467 6868 x.227
[EMAIL
raphael k wrote :
I created a table with a field define as NULL, however when I insert
values NULL , Mysql puts 0 instead of nothing ,
I don't understand why I have this trouble ,
Thanks
Hi,
If you don't show us your query, it will be hard to help you ...
Regards
--
Joseph
I created a table with a field define as NULL, however when I insert
values NULL , Mysql puts 0 instead of nothing ,
I don't understand why I have this trouble ,
Thanks
-
Before posting, please check:
On Thu, May 09, 2002 at 11:18:35AM -0400, Ken Menzel wrote:
Gunnar, This sounds very interesting! I will have to try this and
see if I cannot aggravate the problem with large cache values.
Thank you for sharing this information. Jeremy I hope you will
share something if you can reproduce
On Fri, May 10, 2002 at 12:55:39PM +0200, Mark wrote:
How dangerous is OPTIMIZE TABLE?
I have been reading through the FAQ, and came to the section on OPTIMIZE
TABLE.
http://www.mysql.com/doc/O/P/OPTIMIZE_TABLE.html
That has my interest, as my MySQL XOVER database will expire
articles
Hello,
I develop threaded mysql client in c++ that uses connection
pool.
The program coredumps during vio_read (called from my_net_read).
I'm using libmysqlclient_r and keep all rules from How to make
threaded client section. Thread-pool is implemented with
CommonC++ class Thread.
I have found that I can NOT do this:
$null = NULL or even $null = NULL than put that into a statement like this:
UPDATE games SET game_id = '$null';
can't do it like this either
UPDATE games SET game_id = $null;
I have to do it like this:
UPDATE games SET game_id = NULL;
NO QUOTES of any kind.
Basic Question
I'm programmatically open a dataset using this select statement
- SELECT SOD_TAG_DET.*, TAG_MSTR.TAG_NUM
FROM SOD_TAG_DET, TAG_MSTR
WHERE (SOD_TAG_DET.TAG_ID = TAG_MSTR.TAG_ID) AND
(SOD_TAG_DET.SODMstrID = 20)
ORDER BY TAG_MSTR.TAG_NUM
however
On Fri, May 10, 2002 at 10:12:15AM +0100, ritu singla wrote:
Hi!!
I used BACKUP TABLE command to take the backup of a
table...but when i say
RESTORE TABLE, i get the following ::
mysql restore table rs from '/tmp';
+---+-+--+--+
| Table |
I've made a few config changes (examples below) in the my.ini except the
server constantly utilizes 66 meg of memory total (Including OS) and I
never see mysql memory usage go any higher than 12-13 meg of memory
usage no matter how much strain I put on the machine. I do not believe
these new
At 13:11 -0500 5/10/02, Steve Buehler wrote:
I have found that I can NOT do this:
$null = NULL or even $null = NULL than put that into a statement like this:
UPDATE games SET game_id = '$null';
can't do it like this either
UPDATE games SET game_id = $null;
I have to do it like this:
UPDATE games
On Wed, May 08, 2002 at 10:12:10AM -0400, adam nelson wrote:
I am not having any troubles on 4.5 using plain mysql. Our
transaction is lower than some (but certainly higher than others) at
4 queries/sec avg.
It seems to be unrelated to load. I've seen this happen on a relatively
lightly
At 14:22 -0400 5/10/02, Andrew Kuebler wrote:
I've made a few config changes (examples below) in the my.ini except the
server constantly utilizes 66 meg of memory total (Including OS) and I
never see mysql memory usage go any higher than 12-13 meg of memory
usage no matter how much strain I put
On Fri, May 10, 2002 at 10:23:30AM +0100, Raymond Brighenti wrote:
Hi,
Trying to get replication going between to W2K machines and getting the
following errors in the Slave log file.
MySql: ready for connections
020509 18:58:52 Slave thread: error connecting to master:Can't connect to
On Fri, May 10, 2002 at 02:22:18PM -0400, Andrew Kuebler wrote:
Is there another way to load the new settings without taking the
server down?
Not yet. There's talk of that happening in a future release of MySQL
(4.x maybe?).
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo -
I am beginning to learn mysql.
How to add a column to table in mysql database.
Thanks
Tang
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
At 01:22 PM 5/10/2002, Paul DuBois wrote:
At 13:11 -0500 5/10/02, Steve Buehler wrote:
I have found that I can NOT do this:
$null = NULL or even $null = NULL than put that into a statement like this:
UPDATE games SET game_id = '$null';
can't do it like this either
UPDATE games SET game_id =
Look up the ALTER TABLE statement.
On Friday 10 May 2002 12:52 pm, Tang Ngo wrote:
I am beginning to learn mysql.
How to add a column to table in mysql database.
Thanks
Tang
-
Before posting, please check:
Hi Folks,
Can I do the following:
LOAD DATA INFILE 'persondata.txt'
INTO TABLE persondata p, jobdata j (p.lname,j.jobtitle,...);
Mysql the spam filter.
Andrew Hazen, O.C.P.
E-Commerce Developer
Jatech Solutions Inc.
www.jatech.ca
Specializing in OSCOMMERCE applications and PHP/MySQL
Mysql problem
Regards.
--Azhar Khan
On Fri, 10 May 2002 [EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you
sql, query
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to this message, and include the entire text of it in the
[snip]
I am beginning to learn mysql.
How to add a column to table in mysql database.
Thanks
Tang
[/snip]
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi,
What versions of mysql support innodb tables? What about 3.23.45 or 3.23.47?
Thank u very much,
Edilson.
Edilson Vasconcelos de Melo Junior
www.jrsoftwares.com.br
[EMAIL PROTECTED]
Fone: (19) 3256-3577
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system
Hi,
Using the C API, does the sql parameter in the mysql_query function a length
limit?
Thank u very much,
Edilson.
Edilson Vasconcelos de Melo Junior
www.jrsoftwares.com.br
[EMAIL PROTECTED]
Fone: (19) 3256-3577
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system
At 17:26 -0300 5/10/02, Edilson Vasconcelos de Melo Junior wrote:
Hi,
What versions of mysql support innodb tables? What about 3.23.45 or 3.23.47?
Both versions, but only if you
- Compile from source using the --with-innodb option when you configure MySQL
- Use a -max distribution, if you use a
At 15:08 -0400 5/10/02, Andrew Hazen wrote:
Hi Folks,
Can I do the following:
LOAD DATA INFILE 'persondata.txt'
INTO TABLE persondata p, jobdata j (p.lname,j.jobtitle,...);
No.
You could extract the columns you need from the file for each table
into two separate files, then run two
The real answer, yes. It has a limit of several GB, depending on your OS.
It can take a huge string containing MBytes of BLOB data.
Just for grins, I loaded several MB of image data this way just to prove to
myself that you could do it.
The practical answer is then pretty much no. (Probably
At 13:59 -0500 5/10/02, Steve Buehler wrote:
At 01:22 PM 5/10/2002, Paul DuBois wrote:
At 13:11 -0500 5/10/02, Steve Buehler wrote:
I have found that I can NOT do this:
$null = NULL or even $null = NULL than put that into a statement
like this:
UPDATE games SET game_id = '$null';
can't do it
At 20:45 + 5/10/02, John Doe wrote:
ok I have (for now) three tables all with the same ID, however I want
to be able to change the ID if I need to. But I don't want to do it
with 3 statements (ie, update table01 set id=2 where id=3;update
table02 set id=2 where id=3;update table03 set id=2
Hi,
The server is not mine :( How do i know if the source was compiled
with --with-innodb option?
Thank u very much,
Edilson.
-Mensagem original-
De: Paul DuBois [mailto:[EMAIL PROTECTED]]
Enviada em: sexta-feira, 10 de maio de 2002 17:47
Para: Edilson Vasconcelos de Melo Junior; MYSQL
what is the simplest way to delete duplicate occurences of a specific
field in mysql?
thanks,
augey
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
At 17:16 -0400 5/10/02, Augey Mikus wrote:
what is the simplest way to delete duplicate occurences of a
specific field in mysql?
thanks,
augey
Your question is a bit ambiguous. You could do this by using ALTER
TABLE to remove the column itself from the table, for example, but
I'm guessing
mysqladmin variables
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Edilson Vasconcelos de Melo Junior
[mailto:[EMAIL PROTECTED]]
Sent: Friday, May 10, 2002 4:04 PM
To: Paul DuBois; MYSQL
Subject: RES: Innodb
Hi,
The server
At 8:17 -0700 5/10/02, Lalit Nagpal wrote:
through a servlet i insert my form data into my table
(primary key is auto-incremented) and then i throw
another query which is
select last_insert_id() from mytable limit 1
through my statement.executeQuery method. when i ask
for the data through
At 14:29 +0200 5/10/02, Stian Skjelstad wrote:
Hi
I don't know if this is of any interrest etc, but atleast it is a small
little issue from the big, big world.
This is easily solved by using mysql_connect() rather than
mysql_pconnect(). Then the connection won't stay open if
the script dies or
I've had simmilar problems.
I had something like this...
String blah = myResultSet.getString(BLAHBLAH);
if(!myResultSet.wasNull()){
if(blah.equals(something)){ ...boom nullPointer exception
I'm not sure why the null value wasn't caught by wasNull(). Anyway I
worked around it by adding an
what i meant is deleting duplicate occurences of records of a certain
field. ...sorry...
Paul DuBois wrote:
At 17:16 -0400 5/10/02, Augey Mikus wrote:
what is the simplest way to delete duplicate occurences of a specific
field in mysql?
thanks,
augey
Your question is a bit
when running
select count(distinct value) from table;
on a table with more than 19 million records i got the error:
got error 27 from table handler (or something like that)
i looked up the error in mysql perror which gave me file too large
does this have to do with my file size in linux or a
At 17:54 -0400 5/10/02, Augey Mikus wrote:
what i meant is deleting duplicate occurences of records of a
certain field. ...sorry...
Ah.
One thing you can do is add a unique index on that field with
ALTER IGNORE TABLE tbl_name ADD UNIQUE (col_name)
or
ALTER IGNORE TABLE tbl_name ADD PRIMARY KEY
is there a way for me to do it in a mysql delete statement? just out of
curiosity, for instance, if i wanted to add duplicates later for
whatever reason.
Paul DuBois wrote:
At 17:54 -0400 5/10/02, Augey Mikus wrote:
what i meant is deleting duplicate occurences of records of a certain
At 18:00 -0400 5/10/02, Augey Mikus wrote:
is there a way for me to do it in a mysql delete statement? just
out of curiosity, for instance, if i wanted to add duplicates later
for whatever reason.
Okay, let's suppose you have 3947 instances of abc.
You can use LIMIT for this:
DELETE FROM
On Fri, May 10, 2002 at 04:51:15PM +0200, Christophe Demange wrote:
Hello,
I have a question:
We want to real-time synchronize a MySQL database part with a
distant database. We have a central database containing all the
data. This database must share several parts (records) with the
thanks :-)
Paul DuBois wrote:
At 18:00 -0400 5/10/02, Augey Mikus wrote:
is there a way for me to do it in a mysql delete statement? just out
of curiosity, for instance, if i wanted to add duplicates later for
whatever reason.
Okay, let's suppose you have 3947 instances of abc.
On Thu, May 09, 2002 at 09:21:12AM -0400, Darrell A. Sullivan, II wrote:
I am considering porting our applications that currently use an
in-house database schema to MySQL. I need to setup a test system to
try this out and I am needing a few pointers.
Excellent.
First, what type of
so i suppose an automatic delete of every duplicate record is out of the
question :-)
Paul DuBois wrote:
At 18:00 -0400 5/10/02, Augey Mikus wrote:
is there a way for me to do it in a mysql delete statement? just out
of curiosity, for instance, if i wanted to add duplicates later for
At 14:59 -0500 5/9/02, Bob Ryan wrote:
I think you have to use a forward slash in your path instead of a backslash.
C:/ as opposed to C:\
even in windows operating environments I believe you need to use /.
That's correct. Or you can use doubled backslashes, but / is preferred.
-Original
At 18:13 -0400 5/10/02, Augey Mikus wrote:
so i suppose an automatic delete of every duplicate record is out of
the question :-)
Sounds like you're trying to have it both ways.
Paul DuBois wrote:
At 18:00 -0400 5/10/02, Augey Mikus wrote:
is there a way for me to do it in a mysql delete
I suppose the i could always remove the unique constraint once the alter
statement has removed the duplicates.
ok
Paul DuBois wrote:
At 18:13 -0400 5/10/02, Augey Mikus wrote:
so i suppose an automatic delete of every duplicate record is out of
the question :-)
Sounds like you're
1 - 100 of 115 matches
Mail list logo
