This is kind of a silly question is there an easy way to ...
SELECT Status, rating, COUNT(*) FROM song GROUP BY pldupldqd, rating ORDER BY
Status, rating DESC
This gives me all the information I need ...
What I would like to do is something... like
SELECT rating, count(WHERE pldupldqd = 0), co
hi,
I installed MySQL 4.0.16-nt on a Win2000 Pro platform.
I want to implement a multi-table delete, so i type
following SQL statement:
Delete from tablea, tableb using tablea, tableb
where tableb.number=2 and tableb.number=3;
the server down and generate following message:
`Mysql-nt has gener
Theresa,
> Knowing that MySQL is an open source software I'm in favour of this
> application and wldlike to try out this product, wonder why I can
> download this application for my necessary practice for both
> Client/Server application.
I assume you mean "How can I download the Mysql server a
On 19 Nov 2003 at 23:12, r.schacht wrote:
> Hi,
>
> I'm new to MySQL. I want to try to create a new database, but I type in
> the same commands all the time.
>
> What I want to be able to do is type the commands into text files, then
> run them from inside MySQL. This way if I want to change som
I'm completely stumped trying to create any index MySQL will use at all
for my SELECT.
I've got a table with four columns describing the upper-right and
lower-left coordinates of a rectangle - RIGHT, LEFT (max X, min X), TOP,
BOTTOM (max Y, min Y). I have an X, Y coordinate and I want to select
Hi,
I'm new to MySQL. I want to try to create a new database, but I type in the
same commands all the time.
What I want to be able to do is type the commands into text files, then run
them from inside MySQL. This way if I want to change something I can just
drop the database and recreate.
Any he
To whom it may concern,
Knowing that MySQL is an open source software I'm in favour of this
application and wld
like to try out this product, wonder why I can download this application
for my necessary
practice for both Client/Server application.
Tks.
***
hi,
i am using linux redhat 8 to power mysql. i installed mysql version 4.0.13
using rpm package. by default, the data file of mysql is alocated at
/var/lib/mysql, but i have a limited of diskspace of /var dir (it is about
1G), so, it was easily full loaded with data. now, i want to archive the
da
Matt, thanks for your suggestions.
The index on content_id was for deletes. You're right...I could get rid of
the C.id field...it has not been useful.
To avoid making too many changes at once, I created a UNIQUE index on
stem_word_id and content_id. Now EXPLAIN says it's using the UNIQUE index,
b
> Mark Wilson <[EMAIL PROTECTED]> wrote:
>> Two related questions.
>> 1. I have a table with a "date" field. (Ex: '04/13/2002'). I want to get
>> a list
>> of all UNIQUE values for that field (many entries from the same day),
>> i.e., all
>> days with entries.
>> ***
Hi Mike,
Those tables aren't that big for what you're doing (which is about how
I'd do it if I wasn't using built-in full-text :-)).
How many results are your searches returning? How long are the queries
taking?
The C table: Do you need the index on content_id? For deletes or
something? Doesn't
Hi Yves,
http://www.mysql.com/doc/en/JOIN.html
table_reference [INNER | CROSS] JOIN table_reference [join_condition]
The [ ... ] means that "INNER" is optional -- in MySQL at least, not
sure about the SQL standard.
Hope that helps.
Matt
- Original Message -
From: "Yves Goergen"
Sen
Hi Richard,
As I think Gerald Clark said, you could run DELETEs with LIMITs (like
1000-1, etc. at a time) in a loop until rows all rows are deleted.
This won't make the deletes any faster (probably slightly slower total,
actually), but will allow other clients to use the table in between.
Hav
Thanks again Aman
I think I will uninstall it and start afresh.
I will let you know how I did.
mo toufali
[EMAIL PROTECTED]
-Original Message-
From: aman raheja [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 19, 2003 5:54 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: R
Hi Arnaud,
A disk-based temp table is used if you're SELECTing a column [that can
be] longer than 255 characters (BLOB/TEXT to MySQL). This is because the
in memory HEAP tables don't currently support variable length rows.
Using something like LEFT(text_col, 255), if feasible, will get around
this
Hi Jon,
The -log suffix is added when you're running with logging (log or
log-bin in my.cnf/my.ini). log-bin may be being used for replication, so
be careful about removing it. And if one server isn't using logging, you
probably don't need it.
Hope that helps.
Matt
- Original Message --
How do I perform checkpoint in MySQL.
kp
-
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
i run the same configuration .
I have the following settings in my /etc/my.cnf file
innodb_log_archive=0
innodb_flush_log_at_trx_commit=0
#log-update = /export/disk1/mysql/logs/snow
once you have the first set to 0, the other 2 may not matter.
"Arnoldus Th.J. Koeleman" wrote:
>
> I am u
Hi all,
How can I see the temporary tables in a database?
Is there something like SHOW TEMPORARY TABLES?
Thanks,
Hector
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm running mysql on a redhat system starting it from a script in
/etc/init.d/ as is the default with the rpm install. I can't seem to
set the timezone environmental variable to change nomatter what I put in
the /etc/my.cnf file.
Can anyone help me with this?
Jeff
> -Original Message-
>
Do check the ownership on /var/lib/mysql
if not right, then
chown -R mysql /var/lib/mysql
I am getting out of ideas here. Would recommend to uninstall all the
mysql packages - mysql-server, mysql-client and other you have installed
and start afresh.
Aman Raheja
AGF Technologies
http://www.agftec
Okay, here's an interesting one. Here's the query:
SELECT distinct date_format(auditdate, "%Y%M" ) as listUrl, date_format(
auditdate, "%Y%m" ) as blank
FROM quality_history
WHERE auditdate <> Now()
ORDER BY listUrl desc
LIMIT 6
auditdate is a DATE datatype
When I run thi
Héctor Villafuerte D. wrote:
Hi all,
I know how to do this query with subqueries like this:
select * from traf_oper where
rutasalien in
(select ruta_salid from rutas where codigo_ope = 0)
and
rutaentran in
(select ruta_salid from rutas where codigo_ope > 0)
--
Thanks Paul for your reply, I extend a little more my question and try to be more specific:
There is a command or function to call a shell script through a mysql server on a linux box using odbc as client?
---Mensaje original---
De: Paul DuBois
Fecha: martes 18 de noviembre de
I'd like to know your opinion on monetary calculations.
For accurate representation of monetary (euro) values I use DECIMAL fields
(12,5).
Now: how to do safe calculations?
Are these commands safe?
1) SELECT SUM(price) FROM ...
2) SELECT SUM(price * 1.2) FROM ...
3) SELECT SUM(price) * 1.2 FROM
Right, I've a linux box running apache and another running mysql both on my private lan and I want to connect from internet through a firewall, to do that I'm using nat and forward with iptables.
First I try setup it for apache (just for test) and things go right, all it's ok; but with mysq
I have two servers replicating. Server one to server two.
If I do a show variables on server one it show the timezone as EST, on
server two it shows it as GMT. Where is this set and how can I change
server one to GMT?
The linux box itself, that mysql server one runs on is set for GMT
Thank
> what would the syntax be to delete all the data in a column for every
> record but still maintain the column? In other words, I don't want to
> delete the column, just the data in it.
I would use an UPDATE and set it to '' or NULL, depending on your column.
> Second, is there a way I can LOAD
Hello,
I am following the advice of the manual when bulk loading a large table by turning off
index builds before LOAD DATA INFILE. The load ends normally (73 GB). The mysamchk
build of the indices fails:
myisamchk: warning: Can't change size of indexfile, error: 22
myisamchk: error: 22 for r
Hello Santino,
I tried to formulate my query as you suggested. According to EXPLAIN, MySQL
seems to process it the same way as my first query, working first on table C
and using where, temporary, and filesort.
Thanks,
Mike.
-Original Message-
From: Santino [mailto:[EMAIL PROTECTED]
Sent:
On Wed, 2003-11-19 at 15:08, Dan Greene wrote:
> one more idea:
>
> try:
> mysql --skip-column-names --raw < test1 | tar xf -
no output,
mysql --skip-column-names --raw < test1 | more
./test1
>
>
> > -Original Message-
> > From: Denis Mercier [mailto:[EMAIL PROTECTED]
> > Sent: Wedn
well, thanks for that link, but I don't know what it wants to tell me.
13 = permission denied -- that's absolutely impossible, I have set no
permission restictions on anything concerning this. any why should a server
restart resolve a perm denied error??
127 = record file crashed -- also, REPAIR/
On Wed, 2003-11-19 at 15:00, Dan Greene wrote:
> ok... try this:
>
> mysql --skip-column-names < test1 > mytestoutput.tar
the content does get redirected into mytestoutput.tar
>
> tar xvf mytestoutput.tar
tar: This does not look like a tar archive
tar: Skipping to next header
tar: Error exit
one more idea:
try:
mysql --skip-column-names --raw < test1 | tar xf -
> -Original Message-
> From: Denis Mercier [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 19, 2003 2:41 PM
> To: [EMAIL PROTECTED]
> Subject: Re: piping blob into shell command (tar)
>
>
> On Wed, 2003-11-19
Andre,
- Original Message -
From: "Andre Charbonneau" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, November 17, 2003 5:11 PM
Subject: row-level locking question...
> Hi,
>
> Let say that I have the following transaction:
>
> 1. Read value v1 from table t1.
> 2.
I have gotten several of these errors over the last couple of months. This
has happened on two different servers. (Both are running MySQL 4.0.16 on
Red Hat 7.3)
It mainly happens in one particular table, but has happened in another one.
I have tried dropping and recreating the table, but that do
ok... try this:
mysql --skip-column-names < test1 > mytestoutput.tar
tar xvf mytestoutput.tar
and if it works, try
cat mytestoutput.tar | tar xf -
to see if it works
> -Original Message-
> From: Denis Mercier [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 19, 2003 2:41 PM
I just compiled 4.0.16 and installed it over top of 4.0.4 beta.
After stopping and restarting mysqld_safe, I went into mysql and issued
a "status" command. I got back the following:
mysql> status
--
mysql Ver 12.22 Distrib 4.0.16, for pc-linux (i686)
Connection id: 35
C
On Wed, 2003-11-19 at 14:03, Dan Greene wrote:
> This may be simplistic, but is mysql putting any text before / after blob content,
> such as column name, '1 row processed OK', that may be 'corrupting' the tar data?
>
> using a very small tar file, and run your command, piping to more instead of
Hello -
what would the syntax be to delete all the data in a column for every
record but still maintain the column? In other words, I don't want to
delete the column, just the data in it.
Second, is there a way I can LOAD a file of plain text passwords into a
mysql database and encrypt them d
On Wed, 2003-11-19 at 14:02, Paul DuBois wrote:
> At 13:55 -0500 11/19/03, Denis Mercier wrote:
> >On Wed, 2003-11-19 at 12:26, Paul DuBois wrote:
> >> At 11:03 -0500 11/19/03, Denis Mercier wrote:
> >>
> >> > > >> >i also tried:
> >> >> >> >use my_db;
> >> >> >> >select * from my_table;
We were unsuccessful getting the MySQL AMD64 rpms to work on RHEL3 AS.
I downloaded the source rpm and rebuilt the rpms on our Opteron server
and they have mostly worked, only one crash so far which we are in the
process of reporting to the MySQL support group.
Of course, we are experiencing s
What if one is using rpm - should just use the --upgrade option
rpm -U
Is this ok to do?
Thanks
Aman Raheja
AGF Technologies
http://www.agftech.com
[EMAIL PROTECTED] wrote:
On Wed, 19 Nov 2003, Mark Marshall wrote:
Hi, everyone.
I have a 4.0.4 beta install of Mysql on Red Hat 7.3. I want t
Do try ps -ef | grep mysqld
to check the server is currently running.
If not then do
/etc/init.d/mysqld start
Let know if there's an error at this point. Also show your my.cnf
Did you use rpm or source to install mysql?
Aman Raheja
AGF Technologies
http://www.agftech.com
[EMAIL PROTECTED] wrote:
Check this out:
http://www.mysql.com/doc/en/Repair.html
-will
- Original Message -
From: "Yves Goergen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 19, 2003 11:12 AM
Subject: Re: error 13
> I just received another error message I don't know what to do with:
>
Hello
I would firstly like to say that you are sending emails to me personally
by hitting Reply - instead use Reply All next time so that others can
view the problem too. I myself am *NOT* a guru in the field and so
expect better advice from an expert.
Anyway.
Firstly - the error seems like w
You could either use mysqldump or just copy the data directory to a safe
place.
Also, if you do not need any special build flags, you should use the
official MySQL binaries, either the RPM or tarball. They optimized the
binaries.
-will
- Original Message -
From: "Thomas Spahni" <[EMAIL
I just received another error message I don't know what to do with:
Got error 127 from table handler
I tried to alter a table's structure. A restart of MySQL did help. A table
CHECK showed no errors with that table.
--
Yves Goergen
[EMAIL PROTECTED]
Please don't CC me (causes double mails)
At 13:55 -0500 11/19/03, Denis Mercier wrote:
On Wed, 2003-11-19 at 12:26, Paul DuBois wrote:
At 11:03 -0500 11/19/03, Denis Mercier wrote:
> > >> >i also tried:
>> >> >use my_db;
>> >> >select * from my_table;
>> >> >
>> >> >so when i try shell> mysql --pager < test1 | tar x
>>
This may be simplistic, but is mysql putting any text before / after blob content,
such as column name, '1 row processed OK', that may be 'corrupting' the tar data?
using a very small tar file, and run your command, piping to more instead of tar to
see if there is any extra text that mysql is ad
Have You tryed:
SELECT A.id, COUNT(A.id), A.category FROM A, C WHERE
C.content_id=A.id AND A.status='Active' AND (C.stem_word_id IN (10,20,30))
GROUP BY A.id
Santino
At 13:08 -0500 19-11-2003, Mike Boone wrote:
Hi all,
I have used PHP and MySQL for years but have never tackled the amount of
data
On Wed, 2003-11-19 at 12:26, Paul DuBois wrote:
> At 11:03 -0500 11/19/03, Denis Mercier wrote:
>
> > > >> >i also tried:
> >> >> >use my_db;
> >> >> >select * from my_table;
> >> >> >
> >> >> >so when i try shell> mysql --pager < test1 | tar x
> >> >> >
> >> >> >the tar file does no
Hi,
I keep getting the following error in mysql error file. Could anyone tell me
what's going on and how to avoid this kind of error?
031117 2:44:37 Error reading packet from server: Lost connection to MySQL
server during query (server_errno=2013)
031117 2:44:37 Slave: Failed reading log even
On Wed, 19 Nov 2003, Mark Marshall wrote:
> Hi, everyone.
>
> I have a 4.0.4 beta install of Mysql on Red Hat 7.3. I want to upgrade
> it to 4.0.16, and keep all the data intact. Do I just dump the
> databases (just in case), stop the server, then "./configure, make, make
> install" over top of
Hi all,
I have used PHP and MySQL for years but have never tackled the amount of
data that I now have (and it's expected to grow considerably). My queries
run OK when the server is not busy but they just about kill the DB when
traffic picks up.
My apologies if this is common knowledge...I've had
I am finding the documentation located at
http://www.mysql.com/doc/en/C_API_Prepared_statement_datatypes.html on
the C API Prepared Statement Interface to be a bit unclear.
In the MYSQL_BIND datatype, when using mysql_bind_param() and
mysql_excute() to pass parameters to a prepared statment, how
We'd like to set up replication in a simple master/single slave setup, but
I can't figure out a way around an issue we'll have with multi table
updates.
The master will hold a set of databases, all of them will be replicated to
the slave.
The slave will hold the replicated databases plus a set of
Is this a production server?
THIS IS not a good advice but If not then just step down to a lower init
level turning off the network services and then come back into level 3/5
whatever you are using, depending on platform.
Then try to start the server. If you would tell what platform you are
run
IN order to access a database say with a name "data_db" you have to
grant permissions to a remote user by doing the following on the server
GRANT ALL ON data_db.* TO [EMAIL PROTECTED] identified by 'password'
Few things to remember.
- Not a good idea to give access to root from remote clients
- O
At 11:03 -0500 11/19/03, Denis Mercier wrote:
> >> >i also tried:
>> >use my_db;
>> >select * from my_table;
>> >
>> >so when i try shell> mysql --pager < test1 | tar x
>> >
>> >the tar file does not get written to /usr/local/test1 but i still dont
>> >get my untared files? write p
At 10:00 -0200 11/19/03, Fernando Gomes Bernardino wrote:
Hi eveybody,
The mysql_fix_privilege tables can be undone? I have already
re-install mysql server and nothing
Why do you want to undo it?
You can undo it by restoring the grant tables from your most recent
backup. But without knowing
Hello All
I can't run the pack_isam binary on Linux and HP-UX for mysql 4.0.15 version.
But it works fine for mysql 3.23.54a.
===
Error on HP-UX (both 11.22 and 11.23) :
# pack_isam --join=/var/mysql/testdb/employee2 /var/mysql/testdb/emp
Hi all,
I know how to do this query with subqueries like this:
select * from traf_oper where
rutasalien in
(select ruta_salid from rutas where codigo_ope = 0)
and
rutaentran in
(select ruta_salid from rutas where codigo_ope > 0)
Hi, everyone.
I have a 4.0.4 beta install of Mysql on Red Hat 7.3. I want to upgrade
it to 4.0.16, and keep all the data intact. Do I just dump the
databases (just in case), stop the server, then "./configure, make, make
install" over top of the old server and start it up again and see what
hap
On Tue, 2003-11-18 at 18:32, Paul DuBois wrote:
> Please reply to the list, not to me personally, so that
> others can follow this discussion.
that was my intention, sorry, I just used reply from my e-mail client
and realized too late that it did not default to the mysql list.
>
> At 17:05 -0500
Perhaps you could add a limit to the delete, pause, and re-run until done.
[EMAIL PROTECTED] wrote:
snip
mysql> delete quick from datatable where acttime < '2003-11-14 09:39:49';
or
mysql> delete from datatable where acttime < '2003-11-14 09:39:49';
...takes forever. I killed it after 2
Hi,
Did anyone get the 4.0.16 binary to work on RedHat 3 Enterprise for IA64?
I read that the same happens on RH3AS for AMD64.
"This was thoroughly tested with our production team and it works truly
just fine. " according to MySQL support :-\
031102 22:07:17 mysqld started
mysqld got signal 11;
did you try netstat and see if something else is using the port.
Aman Raheja
AGF Technologies
http://www.agftech.com
[EMAIL PROTECTED] wrote:
I am sure that this problem has already been answered but some how I can't
figure it out.
When I try to start the mysqld I get the error 2002 can't start s
Can someone tell me the difference between a JOIN and an INNER JOIN of two
tables, please? I can't find the "JOIN" alone documented in the MySQL
manual.
--
Yves Goergen
[EMAIL PROTECTED]
Please don't CC me (causes double mails)
--
MySQL General Mailing List
For list archives: http://lists.mysq
"Fernando Gomes Bernardino" <[EMAIL PROTECTED]> wrote:
>
> The mysql_fix_privilege tables can be undone? I have already re-install mysql server
> and nothing
>
Why do you want to do it?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored
Hi all ,
I want to design a table, say
T_PRODUCT { PRD_ID, NAME, DESCRIPTION, PRICE }
where I want NAME and DESCRIPTION to have multi language inputed.
I searched before where found two solutions :
1)
T_PRODUCT {PRD_ID, PRD_DETAIL_ID, PRICE}
T_PRODUCT_DETAIL { PRD_DEATIL_ID, LANG, NAME, DESCRIP
Claes Wiberg wrote:
Hi,
I need to a find a way to migrate a progress 4gl application from progress own
database enterprisedb to mysql. The thing is that progress 4gl doesn´t really speak
sql. Has anyone found a solution to this dilemma? Some sort of odbc-driver that can do
the trick?
brgds
Is t
Hi,
I need to a find a way to migrate a progress 4gl application from progress own
database enterprisedb to mysql. The thing is that progress 4gl doesn´t really speak
sql. Has anyone found a solution to this dilemma? Some sort of odbc-driver that can do
the trick?
brgds
Thanks...
I will try that :)
patrick
From: Victor Pendleton <[EMAIL PROTECTED]>
To: 'patrick kuah' <[EMAIL PROTECTED]>, Victor Pendleton
<[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject: RE: mysqldump query
Date: Mon, 17 Nov 2003 09:38:56 -0600
Are you running on a Linux platform?
File => .my.cn
Hi eveybody,
The mysql_fix_privilege tables can be undone? I have already re-install mysql server
and nothing
Thanks a lot.
Fernando Bernardino
>Description:
When we run the mysql database for any length of time, we end up with
corruptions such as:
/usr/local/mysql/bin/myisamchk: error: record delete-link-chain
corrupted MyISAM-table 'CollectedValue' is corrupted
CollectedValue is a table from our schema:
create table CollectedValue(oi
Mark Wilson <[EMAIL PROTECTED]> wrote:
> Two related questions.
> 1. I have a table with a "date" field. (Ex: '04/13/2002'). I want to get a list
> of all UNIQUE values for that field (many entries from the same day), i.e., all
> days with entries.
> **
> CREAT
dan orlic <[EMAIL PROTECTED]> wrote:
> is there a way to close aging sleeeping connections after they have
> slept for a certain amount of time? a setting or something in mysql?
Take a look at wait_timeout and interactive_timeout variables:
http://www.mysql.com/doc/en/SHOW_VARIABLES.html
I have a problem with a bigger table on mysql 4.0.16-log / debian linux
I played around with indexes, delete quick and such, but I just can't get it
to work.
The following table holds >35mio rows and has >5mio inserts/replaces per
day. to clean it up I want to delete all rows older than X days.
Andrey Kotrekhov <[EMAIL PROTECTED]> wrote:
>> Andrey Kotrekhov <[EMAIL PROTECTED]> wrote:
>> > Hi, All.
>> > Other question is:
>> > Can I create case sensitive field with right ordering of national
>> > characters.
>> >
>>
>> Take a look at collation name: "ci" at the end of the collation name me
Hello all,
I'm using mysql 3.23.49 under Debian Linux and gcc 2.95.4.
I'm writing a mysql client in C, and therefore I link libmysqlclient.a in my program.
The problem is that I also use and link a static list-handling library I've written
some time ago.
And of course problem arises with "mu
Hi!
I have a query that allways creates temporary tables to disk (the ratio
created_tmp_disk_tables/created_tmp_tables is close to 0.8, but I think it
is 1 for this particular query).
This query joins 4 tables, groups by a field a orders by another field (or
sometimes an sql variable).
When I anal
82 matches
Mail list logo
