Oh, and here's the output (Sorry):
+---+-+
| releaseid | name|
+---+-+
| 1 | Unspecified |
| 2 | Next Patch |
| 3 | LOCset |
| 4 | Abashiri|
|
Here's my full test solution:
use test;
drop table if exists releases;
create temporary table releases
(
releaseid int(10) unsigned not null auto_increment primary key,
name varchar(255)
)engine=myisam;
insert into releases ( name ) values
( 'Unspecified' ),
( 'Next Patch' ),
(
> -Original Message-
> From: Jay Pipes [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 12, 2007 2:07 PM
> To: Daevid Vincent
> Cc: mysql@lists.mysql.com
> Subject: Re: Need help with a "natural sort order" for
> version numbers and release code names
>
> Daevid Vincent wrote:
> >
Andrew Carlson wrote:
Is there a purchase order (10002) with no orders in the order_details table?
No, PO 10002 is related to the order_id = 2 here:
mysql> SELECT order_id, SUM(quantity * unit_price) AS subtotal
-> FROM order_details GROUP BY order_id;
+--+--+
| order_id |
Daevid Vincent wrote:
I'm trying to get some 'release/version numbers' to sort properly.
mysql> SELECT ReleaseID, Name FROM releases ORDER BY Name DESC;
+---+-+
| ReleaseID | Name|
+---+-+
|18 | Unspecifie
I have 2 queries to give me a list of names.
Q1:
SELECT DISTINCT FName, LName
FROM user u
JOIN userprofile p
USING ( UserID )
JOIN trainingstatus t
USING ( UserID )
WHERE ProgramID =12
ORDER BY LName, FName
Q2
SELECT DISTINCT FName, LName
FROM namelist
WHERE `Date`
What I need is query that wil
I'm trying to get some 'release/version numbers' to sort properly.
mysql> SELECT ReleaseID, Name FROM releases ORDER BY Name DESC;
+---+-+
| ReleaseID | Name|
+---+-+
|18 | Unspecified |
|20
using 5.0.24
mysql> describe order_details;
++---+--+-+-++
| Field | Type | Null | Key | Default | Extra |
++---+--+-+-++
| id | mediu
Paul,
Take a look at the ulimit command. We had a similar issue, and it turns out
there are OS level per-process limits as well. We have now configured the
/etc/init.d/mysql file set the ulimit to what we need.
here is the snippet form the file:
echo $echo_n "Starting MySQL"
ulimit -n 4096
>Mostly because use 2 field to represent the same data is a waste of storage
i think.
Oh, ok. So you're sending a non-date value and you want to transform it into
an
actual character presentation of a date value, but making things easier on
yourself
is a waste of storage.
Feel free to continu jum
Mostly because use 2 field to represent the same data is a waste of storage i
think.
- "Martijn Tonies" <[EMAIL PROTECTED]> escribió:
> >The aplication which is writing to the database is sending the date
> in unix
> format.
> >I can't no change that, so i suposse using a triger will help.
>
>The aplication which is writing to the database is sending the date in unix
format.
>I can't no change that, so i suposse using a triger will help.
>
>The application pass the 'xx.xx' value when is inserting to the table.
Righto. Well, what does this mean then:
>im converting the unixtime to
The aplication which is writing to the database is sending the date in unix
format.
I can't no change that, so i suposse using a triger will help.
The application pass the 'xx.xx' value when is inserting to the table.
- "Martijn Tonies" <[EMAIL PROTECTED]> escribió:
> >If i define that t
>If i define that the value for the field must be varchar data type, `fecha`
varchar(25) default NULL, the triger records the right date.
>I think because is wrinting a string only. But if i define the field as a
date data type, `fecha` date default NULL, the value writen is: 1969-31-12.
I suppose
Martijn,
If i define that the value for the field must be varchar data type, `fecha`
varchar(25) default NULL, the triger records the right date.
I think because is wrinting a string only. But if i define the field as a date
data type, `fecha` date default NULL, the value writen is: 1969-31-12. I
Given that FEHLGESCHLAGEN means "failed" and coupled with the proceding
text, I would assume that you don't have mysql installed in the first
place. If you are on an rpm based system, try the following:
rpm -q mysql
If you don't get anything back, you need to reinstall.
Ananda Kumar wrote:
> if
if u do ps -ef | grep mysql, what do u get.
regards
anandkl
On 10/12/07, Daniel Bau <[EMAIL PROTECTED]> wrote:
>
> He say he can not connect to the server --> no server is installed and no
> socket is in
> var/lib/mysql
>
> When I install it he want to start the server and say "FEHLGESCHLAG
He say he can not connect to the server --> no server is installed and no
socket is in
var/lib/mysql
When I install it he want to start the server and say "FEHLGESCHLAGEN"
No mysql server or manager
Or can not connect to mysql.sock
So he not realy install the server and say me he ha
what is the error ur getting.
regards
anandkl
On 10/11/07, Daniel Bau <[EMAIL PROTECTED]> wrote:
>
> Dear MySQL Support team ,
>
> I have bis problems to upgrade my MySQL 3.23.58 Version on a Linux Red Hat
> 3 system.
> I nearly download all MySQL Versions (4,5,6) and try to test them but
> nowb
Dear MySQL Support team ,
I have bis problems to upgrade my MySQL 3.23.58 Version on a Linux Red Hat 3
system.
I nearly download all MySQL Versions (4,5,6) and try to test them but nowbody
work.
I stopp my MySql Server, reinstall the old version and install the new with
rpm.
It never work
Hi,
> I have a problem with a trigger which should conver a unix timestamp to a
MySQL date datatype.
> The trigger works if the column is varchar, but when the column is date
type, it write the date of 1969-31-12.
Instead of "column", I guess you mean "value"?
> Any ideas?
>
>
>
> DROP TABLE IF
21 matches
Mail list logo
