Fw: SQL Question

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: Mysql list

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

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

FW: SQL question

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,

Re: FW: SQL question

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 test

Re: FW: SQL question

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

Re: FW: SQL question

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

RE: FW: SQL question

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: Nope. I've tried every combination I can

RE: FW: SQL question

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 John Almberg wrote: Nope

RE: FW: SQL question

- 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 of these ideas. They all give syntax errors. I don't think arithmatic

Re: FW: SQL question

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. -- John

Fw: sql

- 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 perl 5

Fw: sql

- 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 PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 28, 2002 7:46 AM

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

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

FW: sql

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

Re: FW: sql

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

Re: Fw: SQL HELP

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 * is