Fw: SQL Question

2006-01-06 Thread Rhino
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:

Fw: [SQL] foreign key from a table to the *same* table

2003-09-09 Thread Alberto
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

Re: FW: SQL question

2002-09-27 Thread gerald_clark
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. > >--

RE: FW: SQL question

2002-09-27 Thread John Almberg
--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

RE: FW: SQL question

2002-09-27 Thread John Almberg
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

RE: FW: SQL question

2002-09-27 Thread John Almberg
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: &

Re: FW: SQL question

2002-09-27 Thread jacob
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

Re: FW: SQL question

2002-09-27 Thread Mark Matthews
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

Re: FW: SQL question

2002-09-27 Thread Joseph Bueno
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

FW: SQL question

2002-09-27 Thread John Almberg
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

Fw: sql

2002-03-28 Thread Harry Rorarius
- 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

Fw: sql

2002-03-28 Thread Harry Rorarius
- 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

FW: SQL/Design -- how to use sub entities/type discriminators ?

2002-01-14 Thread Rick Emery
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

Re: FW: sql

2001-08-27 Thread Colin Faber
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

FW: sql

2001-08-27 Thread Sheena Sidhu
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

Re: Fw: SQL HELP

2001-01-16 Thread j.urban
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

Fw: SQL HELP

2001-01-16 Thread Mike Podlesny
- 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