I have got few duplicate record in my DB as follows.-
Let's say record_no is the unique id of duplicate records.
So I have fields ID, record_no , X and Y. (ID is a dif filed and is a
primary key)
To find duplicates I do following -
select record_no,count(record_no) from mytable group by record_n
I wish you all a very good and cherishable 'Thanks Giving' to all the people in
this list and and all the contributors to MySQL all over the World.
Once Again Thanks :)
Warm Regards,
Nikhil.
-Original Message-
From: Scott Hamm [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 24, 2004
At 21:53 -0600 11/24/04, tom miller wrote:
what is the maximum number of entries that table can hold?
i have been experimenting with php and mysql.
i created a script that records iipaddress, browser info and timestamp
once the table reaches 127 entries it stops, is there a way to
increase this num
what is the maximum number of entries that table can hold?
i have been experimenting with php and mysql.
i created a script that records iipaddress, browser info and timestamp
once the table reaches 127 entries it stops, is there a way to
increase this number?
i read thru the administrators guide
Michael Stassen wrote:
>
> You would increase your chances of getting a useful answer if you would
> take
> the time to reformat your query to be easily readable, as I have done for
> you below.
>
> > SELECT Product.Product,
> >AssignedToAgent.AgentName AS AssignedTo,
> >sum(Inqu
Geoffrey R. Thompson wrote:
I have an interesting problem that I cannot find any clues to in the MySQL
documentation. The following query works in 3.2.3, but does not work in
4.1.7:
You would increase your chances of getting a useful answer if you would take
the time to reformat your query to be
I am curious about doing something simular to this... does anyone have an idea
On Wed, 24 Nov 2004 00:43:32 -0500, list 123. wrote:
> Using mySQL 4.0, I would like to know how I can code a query that will change
> the value of Participants.Active from Y to N is for three or more CONSECUTIVE
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jon Drukman wrote:
> My master has two databases: channel and hardware. I'm only interested
> in replicating hardware, so I set up replicate-do-db=hardware on the slaves.
>
> However, I am having problems because of giant LOAD DATA operations
> pe
i probably should have mentioned: both master & slave are running 4.0.20
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
My master has two databases: channel and hardware. I'm only interested
in replicating hardware, so I set up replicate-do-db=hardware on the slaves.
However, I am having problems because of giant LOAD DATA operations
performed nightly on channel. Replication blows up with "max packet
exceeded
Carlos,
I asked you to post the COMPLETE .err log. Do NOT cut anything off.
Regards,
Heikki
- Original Message -
From: "Carlos Augusto" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, November 24, 2004 7:38 PM
Subject: Re: Innodb corrpution. Very Urgent
well i=B4
Well i didn´t change nothing at no config file. Any suggestions?
thanks.
Sorry all for those lots of questions... i´m new at mysql and I need
it very much at my job.
and sorry for the english too.
On Wed, 24 Nov 2004 16:20:57 -0200, Ronan Lucio <[EMAIL PROTECTED]> wrote:
> Carlos,
>
>
>
> >
Last week I got this message:
Cannot connect DBI:mysql:formmail;myhost.net: Host 'myhost.net' is
blocked because of many connection errors. Unblock with 'mysqladmin
flush-hosts'
I couldn't find the errors anywhere. Not in any of the apache logs and
not in the mysql error log:
041103 20:09:11
Carlos,
> 041124 14:13:18 Innodb: fatal error: cannot allocate 2147500032 bytes of
> innodb: memory with malloc! total allocated memory
> innodb: by inndodb 16975556 bytes. Operating system errno: 8
> innodb: Cannot continue operation!
> innodb: check if you should increase the swap file of ulimit
Hello.
> ERROR 2002: Can't connect to local MySQL server through socket
I guess you've got such error while executed mysql command line client program.
> The documentation had a little info. Tried all that; didn't work.
What did you tried exactly? Have you looked at:
http://dev.mysql.co
Hello.
Citing Egor Egorov as of http://lists.mysql.com/mysql/166245:
"Check that it's not max_allowed_packet or wait_timeout issue:
http://dev.mysql.com/doc/mysql/en/Gone_away.html";
> After that, when i tried to reconnect it, it's hang up
> !
Your Red Hat server machine hangs up?
Hello.
Have you tried official binaries?
"Willem Roos" <[EMAIL PROTECTED]> wrote:
>
> Hi list,
>
> We have apps that try to open > 700 simultaneous connections to our
> 4.0.20-max mysql server running on RH7 (Linux kernel 2.4.20). We get
> many 'Can't create a new thread (errno 11)'
Hello.
See:
http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
>How can I reset the permissions on my database? I have no clue when I did
>it (at least several months ago), haven't used it until today but I cannot
>for the life of me figure out how I can create a new user
Hello.
I think we may open a bug, but still we have to try to find at least
the command line options with which mysqld has been started. You should find
a place in your startup scripts where mysqld is invoked. Start it with
--log[=file] --log-error[=file] options. Some clues could be found in
Hello.
There is a list in which you can expect to have your question answered: [EMAIL
PROTECTED]
Hagen Hoepfner <[EMAIL PROTECTED]> wrote:
> Dear list,
>
> perhaps there is some one who can help me ;-) I currently try to
> understand the structure of .frm-Files. As I understood the
Hello,
The mysql sock file is used for Unix Domain Sockets communication.
In essence, it is used for interconnection between processes running
on the same system. They function just like ordinary-over-the-net
sockets. They are just faster for interprocess communication.
I am not sure I understan
Is the MySQL server running and you can not connect? Or are you not able
to start the MySQL server?
Morris, Andrew wrote:
../var/lib/mysql/mysql.sock.
I've been round the houses with this following the thread but I can't
get past this error despite all the chmod and chown modifications,
insta
../var/lib/mysql/mysql.sock.
I've been round the houses with this following the thread but I can't
get past this error despite all the chmod and chown modifications,
installed MySQL admin and it still won't start.
Am I best to chuck it in the bin or uninstall the lot and start again?
This is
well i´m having another problem now... I changed innodb_force_recovery
for 1 and mysql is not running due the following error:
041124 14:13:18 Innodb: fatal error: cannot allocate 2147500032 bytes of
innodb: memory with malloc! total allocated memory
innodb: by inndodb 16975556 bytes. Operating sy
Gents,
Upgrading to Mysql 4.1.7 from 4.0.18... I get the following error when
trying to start:
./bin/my_print_defaults: error while loading shared libraries:
libcprts.so.5: cannot open shared object file: No such file or directory
OS = Mandrake 9.2
Which RPM am I missing?
THANKS!
Wamp servers are an excellent windows install for It elimininates those
little hiccups
http://www.wampserver.com/en/index.php
Thanks
Donny Lairson
President
http://www.gunmuse.com
469 228 2183
-Original Message-
From: Danesh Daroui [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November
We are shortly to go live with a new set of databases (InnoDB).
The data in each database is identical in fields and types, the only
difference being in the relevance of the data - they are soccer leagues,
and each database represents information on the leagues/teams for a
single season. There
I wish everyone a good and fateenin' Thanksgiving from United States!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jay Blanchard wrote:
This is probably a better question for a PHP list.
Do you know of one? ;)
If you're running a rpm based distro (RedHat, Fedora, etc.), and you
have php installed by rpm, you should just need to install the php-mysql
rpm, and restart Apache.
--
John C. Nichel
ÜberGeek
KegWor
Things are pretty much the same for the Mac as any other Unix platform,
so there aren't too many sites out there that will give you Mac
specific stuff. Any instructions for Unix/Linux are pretty much the
same for the Mac, except for the darn path differences between Unix
platforms. You should b
Hello,
If you aim for for absolute control over the storage (the fileystem
nature is the limit), and speed, do not use an SQL system. Of course,
you would have to face all the trouble of writing your own
mini-engine/subsystem for the job. It all comes down to what your
needs are and how much time
[snip]
I have problem by using PHP and MySQL. I have installed MySQL Server
4.1.7 on a Linux machine with Apache. PHP interpreter has been
installed on it by default but I am not sure if PHP modules for MySQL
has been installed too or not. On MySQL download section there is only
some extension
You didn't say which Linux you were using and I am not sure about the rest,
but if you are using RedHat, you probably need to install php-mysql which
is "A module for PHP applications that use MySQL databases." If you can
use up2date, you can type in up2date php-mysql and that will let you run
Hi all,
I have problem by using PHP and MySQL. I have installed MySQL Server
4.1.7 on a Linux machine with Apache. PHP interpreter has been
installed on it by default but I am not sure if PHP modules for MySQL
has been installed too or not. On MySQL download section there is only
some extensio
A little off topic, sorry, but I am wondering if anyone has any good
Mac Web Dev resourses that i may find useful. Right now I am trying to
figure out how to install mySQL to get my local dev setup and any
pointers would be appreciated.
Thanks
Wikki
--
MySQL General Mailing List
For list archiv
Rhino wrote:
- Original Message -
From: "Martin Rytz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 24, 2004 8:47 AM
Subject: Multiple table count in one sql-query
Hello People
I should have the count from 3 tables in one query; something like this:
select count(*)
How about:
select (@CNT:=count(*)) FROM table1
union
select (@CNT:[EMAIL PROTECTED](*)) from table2
union
select (@CNT:[EMAIL PROTECTED](*)) from table3;
If you want only the sum:
(select (@CNT:=count(*)) FROM table1)
union
(select (@CNT:[EMAIL PROTECTED](*)) from table2)
union
(select (@
On Wednesday 24 November 2004 07:32 am, Hristo Chernev wrote:
> How to upgrade from 3.23.58 to 4.1.7? Which is the easiest way with minimal
> risk and downtime?
Yeah right.. ;)
> Background: Heavy loaded mysql server, only one database but it is huge -
> 5GB.The database is replicated to another
On Wednesday 24 November 2004 04:02 am, Heikki Tuuri wrote:
> > Only two ways to make copies of innodb.. mysqlhotcopy (its not free)
>
> mysqlhotcopy is free, but it works only for MyISAM.
>
> See:
> http://dev.mysql.com/doc/mysql/en/Backing_up.html
Sorry, I meant the hot backup tool for innodb.
RTFL. THIS HAS BEEN ASKED AND ANSWERED TWICE BEFORE. If you have problems
with the answers, address the answers. Stop re-posting!!!
1. http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html
2. The physical sequencing of the records on disk is out of the
administrator's control.
3. http
- Original Message -
From: "Martin Rytz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 24, 2004 8:47 AM
Subject: Multiple table count in one sql-query
> Hello People
>
> I should have the count from 3 tables in one query; something like this:
>
> select count(*)
I have three questions about mysql.
1.
mysql> CREATE TABLE board (
-> boardid char(6) binary NOT NULL,
-> title varchar(128) binary NOT NULL,
-> ) ENGINE=MYISAM;
Query OK, 0 rows affected, 0 warning (0.00 sec)
mysql> desc board;
+--+--+--+-+-+---+
| Field |
Using mySQL 4.0, I would like to know how I can code a query that will change
the value of Participants.Active from Y to N is for three or more CONSECUTIVE
sessions they have Attendance.Present = 'No'?
The Attendance Table has Attendance.Session which coresponds to
Sessions.SessionID and Attend
Is there a reason you aren't using the mysql client that comes with the
server? I am on a W2K machine and I can connect and interact with every
MySQL server on our network from it. A useful by-product of setting this
up is that you can have your own MySQL server on your machine. That has
been g
This is MySQL 4.1.5-gamma-max on Darwin Kernel Version 7.6.0 (OS X
v10.3.6), installed via the Mac OS X installer.
mysql> select gid, fbin from fdata where gid = 3557 order by fbin;
+--+--+
| gid | fbin |
+--+--+
| 3557 | 1000.007086 |
| 3557 | 1.0007
Hi
> I am new to VC++ but getting better indeed. I need help on how to connect
to
> MySQL server.
This is a big topic and as you say not really appropriate here. Join this
MSVC list and I'll help you there:
http://peach.ease.lsoft.com/archives/msvc.html
Regards
Paul
Paul Grenyer
email: [EMAIL
I need to store huge data series using MySQL with InnoDB as storage
engine. The data type of the parameters can be double, float, int,
smallint, mediumint, tinyint So, I've thought to store them in
the following way:
Table Parameter:
Parameter ID - small int
Parameter Name - varchar(8)
Parame
just to save your time..
C:>root/to/mysql/dir/bin/mysql.exe -h HOST_NAME_HERE -u USERNAME -p
you will be promt for password.
- Original Message -
From: "Scott Hamm" <[EMAIL PROTECTED]>
To: "'Ferhat BINGOL'" <[EMAIL PROTECTED]>; "Scott Hamm"
<[EMAIL PROTECTED]>; "'Mysql ' (E-mail)" <[EMA
You may have noticed that Monty & I have spoken out against software
patents regularly. We have actually been fighting them since way before
MySQL! For example David joined the LPF (see lpf.ai.mit.edu) in 89/90.
We believe that software patents will work against software developers
by enabling the
http://dev.mysql.com/doc/administrator/en/mysql-administrator-menus-tools-mysql-command-line-client.html
this may cheer you up than...
- Original Message -
From: "Scott Hamm" <[EMAIL PROTECTED]>
To: "'Ferhat BINGOL'" <[EMAIL PROTECTED]>; "Scott Hamm"
<[EMAIL PROTECTED]>; "'Mysql ' (E-ma
Hello People
I should have the count from 3 tables in one query; something like this:
select count(*) from table1 union select count(*) from table2 union select
count(*) from table3 union;
The Problem ist, that the query gives 3 results back (the count from table1,
table2 and table3) BUT I sh
Isn't there any text-based program like telnet.exe or putty.exe that allows
me to use similiar to 'cmd'?
-Original Message-
From: Ferhat BINGOL [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 24, 2004 8:47 AM
To: Scott Hamm; 'Mysql ' (E-mail)
Subject: Re: Client program
Hi,
I use th
Hi,
I use those 2...
MySQL Control Center
http://www.mysql.com/products/mysqlcc/
PHPMyAdmin
http://www.phpmyadmin.net/home_page/
Cheers...
- Original Message -
From: "Scott Hamm" <[EMAIL PROTECTED]>
To: "'Mysql ' (E-mail)" <[EMAIL PROTECTED]>
Sent: Wednesday, November 24, 2004 2:38
Hi,
I know this is not the exact topic of the list but I am sure some people
from this list spend some time on it.
I am new to VC++ but getting better indeed. I need help on how to connect to
MySQL server.
I need a connector and an example. It must be free because this is a student
project :)
S
What is the best client program that I can use to get connected to MySQL
remotely? I'm running Windows 2000...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to upgrade from 3.23.58 to 4.1.7? Which is the easiest way with minimal
risk and downtime?
Background: Heavy loaded mysql server, only one database but it is huge -
5GB.The database is replicated to another server.Mysql 3.23.58.Linux OS.
Here is the my plan, please correct me if there is a be
On 23 Nov 2004 at 22:36, Tim Trice wrote:
> How can I reset the permissions on my database? I have no clue when I did
> it (at least several months ago), haven't used it until today but I cannot
> for the life of me figure out how I can create a new user with all
> permissions. The only user I h
Titus, Jeff,
- Original Message -
From: "Jeff Smelser" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, November 23, 2004 11:24 PM
Subject: Re: I need to understand INNO better.
--nextPart3014813.KeZKZSIgGj
Content-Type: text/plain;
charset="iso-8859-1"
Content-Tra
In article <[EMAIL PROTECTED]>,
dan orlic <[EMAIL PROTECTED]> writes:
> i have an question about ordering a set of records...
> ab c d
> -
> 1Tax 120001.33
> 1Tax 115002.5
Andy,
Thanks a lot for the response. We are using Linux OS. Is there any
configuration parameter that enables more frequent flush or a parameter
that enables direct write to disk and any idea about performance
implications.
Thanks once again,
Ravi
-Original Message-
From: andy thoma
i have mysql server located in in machine that used Red Hat 8.0
and my mysql server version was 3.23.58. I am trying to connect
using my machine..And currently i used Red Hat Fedora...But when
i am trying to connect to mysql server i got this error
message.
"ERROR 2013: Lost connection to MyS
> Do you know what is differnet between command
> mysql_connect and
> mysql_pconnect
>
> Thankx
>
This is a PHP question. This should've been the first
place you looked:
http://us2.php.net/manual/en/index.php
mysql_connect
http://us2.php.net/manual/en/function.mysql-connect.php
mysql_pconnec
62 matches
Mail list logo
