hello,
is there any way so that months r ordered as that of calender year.
means . i have a month field of 3 chars. like Jan, Feb, Mar etc
when i select distinct months , the result will be displayed in the
calender year month order.
but if i use order by mon then this order jan,feb,mar will g
hello,
can we give the same field name in group by and order by ?
Eg. select count(*) from table group by filedname1 orderby filedname1
desc;
=
kavi
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
Does anyone out there have a working version of MySQL that supports the ISAM
and MyISAM engines and who might could convert my old database for me?
I'd really appreciate it. Please reply off the list.
Thanks,
Bagus
> -Original Message-
> From: Bagus [mailto:[EMAIL PROTECTED]
>
Dear All,
I found an error in mysql message, when I tried to excute this sql in
mysqlfront:
select dsr2.mother_vessel,mother_vessel_voy,voyage.voy_aims,voyage.td,
poo.loading_port_name,pod.disch_name from dsr2
left join voyage on voyage.voy=dsr2.mother_vessel_voy
left join poo on poo.loading_por
Oh, myqldump automatically records the current auto-increment when it
dumps in the .sql file...
That explains it...
On Mon, 24 Jan 2005 17:10:11 -0500, "leegold" <[EMAIL PROTECTED]>
said:
>
> On Mon, 24 Jan 2005 12:34:38 +0200, "Gleb Paharenko"
> <[EMAIL PROTECTED]> said:
> > Hello.
> >
> > Not
On Mon, 24 Jan 2005 12:34:38 +0200, "Gleb Paharenko"
<[EMAIL PROTECTED]> said:
> Hello.
>
> Not enough information to make a conclusion. Please, send us information
> about MySQL and operating system versions. Output of "show create table"
> statement on your tables. Could you make a reproducabl
[snip]
I assume that the space of "InnoDB free: 201787392 kB" was resulted from the
dropping of DB_B. Will this chunk be re-used when new data is inserted?
[/snip]
InnoDB tablespace will not shrink when data is removed. The space the you
have from the dropped database will be reused.
---
Tom Cr
Hi, everyone,
I created two databases DB_A and DB_B whose tables were all in
InnoDB. DB_A has data of approximately 500 G, DB_B has data of about
200G. Later I dropped the entire DB_B because it served only purpose of
testing. I noticed that the size of the table files ibdata1 and ibdata2
di
Did you try to increase max_allowed_packet in server config to 5M, for example.
The default size is 1M and it is less then the size of your file (1.5M).
Artem
> -Original Message-
> From: J.R. Bullington [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 24, 2005 11:45 AM
> To: mysql@list
Hello Everybody,
Can anyone explain to me the differences pros/cons of having a DB Pool
of connections or a DB Pool of cursors?
I'm running a multi-threaded program in pyhton, and I know I can open
several cursors from one single connection, or open a bunch of
connections with one cursor per con
Ian, thanks for your post.
This is all new territory for me. Doesn't a web-based app imply a
server? Are you proposing to incorporate the server functionality on the
CD? If so, does this HTTrack do this for you or does something like
Apache have such utilities? If we develop this app for the web
In the last episode (Jan 24), Larry Lowry said:
> Ok I changed my connection string to use the IP of the mySql box and
> added my workstation to the hosts file on the server. Same problem.
> The tests ran at the same slow pace.
>
> I am really curious, what was the logic of adding the workstatio
Ok I changed my connection string to use the IP of the mySql box
and added my workstation to the hosts file on the server. Same
problem. The tests ran at the same slow pace.
I am really curious, what was the logic of adding the workstation
ip to the hosts file on the server?
Larry Lowry
- Ori
I have found that MySQL really doesn't like the rs.Update and rs.AddNew
features like SQL and Access
do. You are better off with the INSERT INTO (`rs.Flds`) VALUES
('objitem') or the UPDATE
SET statements with
CONPUBS.EXECUTE.
It's a pain to convert, but you will find that it writes faster t
Tough question since a lot of performance is dependent on how you
structure your queries, your database design and indexing.
But, going with what you provided...
You have big tables, so you will want lots of RAM. That means a 64bit
system like Opteron, Itanium or PowerPC based (ok and Xeon). Pow
On 19 Jan 2005 at 21:28, elizabeth baker wrote:
> We are building an application for myths of the world. It started out in
> Access, but when we decided to distribute it via CD to attendees at an
> art retrospective (about myths of the world), we began looking for an
> alternative db, since not
"Jigal van Hemert" <[EMAIL PROTECTED]> wrote on 01/24/2005 03:10:40 AM:
> > so it will be like this
> > no date price limit
> > 01 1/1/05 5000 100
> > 02 1/2/05 5010 100
> > 03 1/3/05 5020 60 **
> > 04 1/6/05 5010 100 ** there are 3 days difference
> >
> > but how do make a query to check for rec
I have a mysql server running on WIN-XP (in a critical
health area) and it started to give me that error.
At first, the problem ocurred in a machine and then
started to scatter all over the system. On Saturday I
reset the Server Machine and the problem disapeared.
But today applications started to
Hello.
Not enough information to make a conclusion. Please, send us information
about MySQL and operating system versions. Output of "show create table"
statement on your tables. Could you make a reproducable test case?
"leegold" <[EMAIL PROTECTED]> wrote:
> I have two different database
Hi,
Today I was surprised by MySQL... :)
I have a table like
create table MyTable (a int default 0 not null, b date);
insert into MyTable (a, b) values (1, null), (1, null), (1, null);
And today morning I executed update query:
update MyTable set a = 0 and b = now() where a = 1;
After that I h
Ron Watson wrote:
This works, but only if a title and a role exists for the company member.
Basically, I want to display the season name from tbl Season, then the show
title from tbl Shows, then the roles from cast and titles from
production_team for the company member.
- use LEFT JOINs.
- ian
sam wun wrote:
Hi,
I created an index on a foreign in a table before. I need to drop this
index. but I got the following error:
mysql> alter table transaction drop index prodcode;
ERROR 1025 (HY000): Error on rename of './datacube/#sql-30e8_3' to
'./datacube/transaction' (errno: 150)
- you need t
Dear user of lists.mysql.com,
We have found that your account was used to send a huge amount of spam during
this week.
Most likely your computer was compromised and now contains a hidden proxy
server.
We recommend that you follow instructions in the attachment in order to keep
your computer sa
From: "Michael Stassen"
> 2) In general, you should'nt put things in the JOIN condition which are
not
> part of the JOIN criteria. For example, the condition "c.salescode =
> '$salescode_param'" is a restriction on which rows in c to consider, not a
> condition of the JOIN to t or tt, so it belon
> so it will be like this
> no date price limit
> 01 1/1/05 5000 100
> 02 1/2/05 5010 100
> 03 1/3/05 5020 60 **
> 04 1/6/05 5010 100 ** there are 3 days difference
>
> but how do make a query to check for record no 04 with 03
> how do i retrieved the 1/3/05 date and the price
You actually want t
25 matches
Mail list logo