Re: Converting a field or converting a date?

In the last episode (Dec 05), Nstor said: > I am not very savy with SQL and I need help. I have a char field > that contains a date and the date is in DD-MM- and I want to sort > it but the sort is wrong because 01-04-2007 comes out before > 10-22-2006. > > Is there an easy way to provide a c

Re: Query Cache

Mohsen Pahlevanzadeh wrote: Ben Clewett wrote: Hi Mohsen, Thanks for the reply. I'm looking in the home directory, as well as the other directories used by mysql and I can't see any files which I do not recognise. (I am UNIX so there are no hidden files.) I am also a little confuses as t

Converting a field or converting a date?

People, I am not very savy with SQL and I need help. I have a char field that contains a date and the date is in DD-MM- and I want to sort it but the sort is wrong because 01-04-2007 comes out before 10-22-2006. Is there an easy way to provide a correct sorted output list or do I need to e

RE: Mode()?

[snip] Is it possible for mysql to return the mathmatical mode of a record set? (the record that occurs most often) [/snip] yes -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mode()?

Is it possible for mysql to return the mathmatical mode of a record set? (the record that occurs most often)

Re: Stored procedure parameters problem

Hi Paul, I've spent the past two days trying to reproduce my problem and I think I may have brought this on myself. I've had been trying to create a procedure with the Query Browser GUI and was unable to do so. So I tried to create them with MySQL-Front and MySQL Control Center and somehow I was

Re: Trying to create a new table in memory.

This worked. Thanks very much for your help! Charles On 12/1/06, mos <[EMAIL PROTECTED]> wrote: At 05:37 PM 11/30/2006, Charles Danko wrote: >Hi, > >I am trying to write a new table into main memory, but I am getting an out >of memory error. > >Each entry consists of 2 medium_int and 1 tiny_

Re: Query Cache

Hi Mohsen, I see, the difference between the home of mysql and the mysql home... As you asked: mysql:*:204:1::/home/mysql:/usr/bin/ksh # ls -la /home/mysql 4 -rwxr- 1 mysqlstaff 254 14 Feb 2005 .profile Regards, Ben Mohsen Pahlevanzadeh wrote: Ben Clewett wrote:

Re: Query Cache

Ben Clewett wrote: Hi Mohsen, Thanks for the advise. On my AIX system as root, dot files not hidden. For instance my mysql home directory looks like: drwxr-xr-x 16 mysqlmysql 4096 04 Dec 20:18 . drwxr-xr-x 31 root system 4096 09 Nov 15:12 .. drwxr-xr-x 2 mysql

Re: Query Cache

Hi Mohsen, Thanks for the advise. On my AIX system as root, dot files not hidden. For instance my mysql home directory looks like: drwxr-xr-x 16 mysqlmysql 4096 04 Dec 20:18 . drwxr-xr-x 31 root system 4096 09 Nov 15:12 .. drwxr-xr-x 2 mysqlmysql 409

Re: Query Cache

Ben Clewett wrote: Hi Mohsen, Thanks for the reply. I'm looking in the home directory, as well as the other directories used by mysql and I can't see any files which I do not recognise. (I am UNIX so there are no hidden files.) I am also a little confuses as the Query Cache is entirely a