Oops, I meant to send this to the list.
Rhino
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "Mester József" <[EMAIL PROTECTED]>
Sent: Friday, January 06, 2006 8:44 AM
Subject: Re: SQL Question
- Original Message -
From: "Mester József" <[EMAIL PROTECTED]>
To:
Hi to all...i've a problem...would anyone help me?
I've a table called COURSES, where there are some universitary courses.
I've a table called DIDACTIC_UNITS, where there are some subjects with some
info like the professor, the course year, etc.
The problem is that some didactic units can be lend
Then try:
select somefields,fieldname + 0 as orderfield order by orderfield
John Almberg wrote:
>Nope. I've tried every combination I can think of of these ideas. They all
>give syntax errors. I don't think arithmatic is allowed in an ORDER BY
>clause. Doesn't even work on an INT field.
>
>--
--Original Message-
> From: Mark Matthews [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 27, 2002 1:33 PM
> To: John Almberg
> Cc: Mysql
> Subject: Re: FW: SQL question
>
>
> John Almberg wrote:
>
> >Nope. I've tried every combination I can think of o
Yes, that works! Thanks very much to all who suggested similar solutions!
-- John
> -Original Message-
> From: Mark Matthews [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 27, 2002 1:33 PM
> To: John Almberg
> Cc: Mysql
> Subject: Re: FW: SQL question
>
&g
Yes, that works! Thank you very much!
-- John
> -Original Message-
> From: Mark Matthews [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 27, 2002 1:33 PM
> To: John Almberg
> Cc: Mysql
> Subject: Re: FW: SQL question
>
>
> John Almberg wrote:
&
A couple things off the top of my head:
- Have you looked into MySQL's 'SET' type?
- What about something like SELECT 0+fieldname as zerofield FROM table ORDER
BY zerofield;
- Would using grouping help?
- Have you considered creating a custom character set? (This may be too
extreme. Can be d
John Almberg wrote:
>Nope. I've tried every combination I can think of of these ideas. They all
>give syntax errors. I don't think arithmatic is allowed in an ORDER BY
>clause. Doesn't even work on an INT field.
>
>-- John
>
>
Have you tried a computed column, i.e,
SELECT BLAH, 0 + BLAH as ord
Here is a small example I have just run :
mysql> create table test (f char(20));
Query OK, 0 rows affected (0.90 sec)
mysql> insert into test values ('11xbc');
Query OK, 1 row affected (0.01 sec)
mysql> insert into test values ('2bcv');
Query OK, 1 row affected (0.00 sec)
mysql> insert into te
Nope. I've tried every combination I can think of of these ideas. They all
give syntax errors. I don't think arithmatic is allowed in an ORDER BY
clause. Doesn't even work on an INT field.
-- John
> -Original Message-
> From: gerald_clark [mailto:[EMAIL PROTECTED]]
> Sent: Friday, Septe
- Original Message -
From: "Harry Rorarius" <[EMAIL PROTECTED]>
To: "Mysql list" <[EMAIL PROTECTED]>
Sent: Thursday, March 28, 2002 9:18 AM
Subject: Fw: sql
>
> - Original Message -
> From: "Harry Rorarius" <[EMAIL PROTECT
- Original Message -
From: "Harry Rorarius" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 28, 2002 7:46 AM
Subject: sql
> I am a new comer to the sql world. I have some but brief knowledge of
perl.
> here goes!
>
> I am using mysql on a Winnt platform and I have per
You don't really have to do the two searches and if-then-else. You can use
joins to first get all grads, then a join to get all profs.
SELECT user.*,graduser.* FROM graduser LEFT JOIN user USING(userid);
SELECT user.*,profuser.* FROM profuser LEFT JOIN user USING(userid);
These assume USERIDs a
With out knowing the exact error im guess its because you're trying to
start the server as root.
Sheena Sidhu wrote:
>
> Hi All,
> I have installed mysql-max. Previously I had the mysql verion 3.23.40
> without max libraries on the same machine. When I start the server , I get
> the fol
Hi All,
I have installed mysql-max. Previously I had the mysql verion 3.23.40
without max libraries on the same machine. When I start the server , I get
the following messages:
Please help ! Urgent!
***
> [root@arulacc mysql-max-3.23
select *,DATE_FORMAT(datecolumn,'%M %D %Y');
On Tue, 16 Jan 2001, Mike Podlesny wrote:
>
> > Thanks for your help but that unfortunately doesn't answer the question,
> > unless I am looking at it wrong. I want the sql statement to read
> something
> > to the affect:
> >
> > SELECT * FROM Table
- Original Message -
From: "Mike Podlesny" <[EMAIL PROTECTED]>
To: "Scott Gerhardt" <[EMAIL PROTECTED]>
Sent: Tuesday, January 16, 2001 3:20 PM
Subject: Re: SQL HELP
> Thanks for your help but that unfortunately doesn't answer the question,
> unless I am looking at it wrong. I want the
17 matches
Mail list logo