Re: inser woes

Hi Doug, I think you need to quote "imgsml=C2BUWS1028.jpg," like imgsml='C2BUWS1028.jpg', take care, /Johan [EMAIL PROTECTED] wrote: This has to be something silly, but I can not see it. Any help greatly appreciated: use newshop; insert into products set storeid=2, deptid=5, groupid=66, pr

Re: Newbie query question...

Hi John, I think you missed on the precedence of AND/OR if you change to > AND (cat_id='2' OR cat_id='5' ) it should work as you want it to /Johan John Croson wrote: I have a simple query: SELECT id,year,month,day,cat_id FROM events LEFT JOIN calendar_cat ON events.cat=calendar_cat.cat_id WHERE ye

Re: Maximum row size for MyISAM table type

Hi Joshua, the BLOB or TEXT is stored separately from the row. What is stored is a pointer to where the BLOB/TEXT is located. /Johan Joshua Beall wrote: Hi All, I am a bit confused by the MySQL documentation on this subject. From http://dev.mysql.com/doc/mysql/en/Storage_requirements.html "The m

Re: Milliseconds to date string

Hi Rafal, binary is a reserved word, you need to quote it with back-ticks ` if you want to use it: SELECT s2u.valus as `binary` FROM ... /Johan Rafal Kedziorski wrote: Hi, I get this: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the rig

Re: Group Query

Shaun, when you add "WHERE B.Project_ID > = '10'" you, in a way, change your LEFT JOIN to an INNER JOIN. You need to do it like: LEFT OUTER JOIN Bookings B ON U.User_ID = B.Rep_ID AND B.Project_ID = '8' /Johan shaun thornburgh wrote: Thanks for your reply, This works great, but when I add a constr

Re: Select non-matching rows

Hi, you could try: SELECT tbl1.id FROM tbl1 LEFT JOIN tbl2 ON tbl2.another_id = tbl1.id WHERE tbl2.id IS NULL /Johan Manish wrote: This should be simple but I am stuck here. I need to select rows from table 1, which do not have matching ID in table 2. Say each table has 100 rows each, and 90 rows f

Re: "PRODUCT()" function - calculating the product of grouped numeric values

Hi, you might take a look at this thread: http://lists.mysql.com/mysql/166184 /Johan Hi, I'm searching for a function that enables me to calculate the product of a group of values, like SUM() does. MySQL server version is at least 4.0.14. For example, a query like "SELECT id, PRODUCT(value) AS 'pr

Re: Newbie: Rewriting A Query- How?

Hi Ken, you might try: SELECT s.PROJID,s.PROJECTNAME FROM S_PROJECTREGISTER s INNER JOIN SL_PROGPROJ l ON s.PROJID = l.PROJID AND l.SNAPSHOTID = 56 INNER JOIN SL_PORTPROG p ON l.PROGID = p.PROGID AND p.SNAPSHOTID = 56 AND p.PORTID IN (100994,100996) WHERE s.SNAPSHOTID = 56 AND s.PROJECTS

Re: Using OR

Hi Keith, you can use: pla.type IN ('1','2','3','4'); /Johan Keith wrote: is there any alternative to using OR for selecting between values? ie: pla.type='1' OR pla.type='2' OR pla.type='3' OR pla.type='4' Cheers, Keith -- Johan Höök, Pythagoras Engineering Group - MailTo:[EMA

Re: insert field from another table

Hi, you could try something like: INSERT INTO articles_multi(article,author,text_ru,text_en ) SELECT e.article,e.authoer,r.text,e.text FROM articles_en e, articles_ru r WHERE e.article = r.article AND e.author = r.article /Johan nullevent wrote: Hello mysql, I have two tables - articles_

Re: select from two tables

Hi, if you are using 4.x or later you can use: (select * from helpdesk where month(helpdesk.hdcreatedate) = 3) UNION ALL (select * from archived where month(archived.hdcreatedate) = 3) LIMIT 0, 30; /Johan rmck wrote: Hi I have two tables in the same Db : table 1: helpdesk | CREATE TABLE `hel

Re: What Is LIMIT? and How to Use LIMIT?

Hi, I guess this is for a java.sql.PreparedStatement as the '?' seem to indicate that. LIMIT limits ;-) the number of rows retrieved, i.e. LIMIT 10, 20 gives you 20 rows starting at row 20 in the resultset and LIMIT 10 gives you the first 10 rows. See: http://www.mysql.com/doc/en/SELECT.html /Joha

Re: first LIMIT then ORDER

Assuming you want to order your arbitrary selection you could do something like: (SELECT t.Id FROM tab t LIMIT 10) UNION ALL (SELECT t.Id FROM tab t WHERE 1 < 0) ORDER BY t.Id /Johan Harald Fuchs wrote: In article <[EMAIL PROTECTED]>, Paul DuBois <[EMAIL PROTECTED]> writes: At 18:51 +0200 4/21/0

Re: ORDER BY Question

Hi Dirk, you should be able to just add on "ORDER BY Count" after your groub clause. /Johan Dirk Bremer (NISC) wrote: The following query produces the following results: select job_coop as 'Job/Coop', count(*) as Count from queue group by job_coop; -- snip Is there a way to use the ORDER BY clau

Re: ORDER BY Question

Hi Dirk, from the excellent on-line manual: http://dev.mysql.com/doc/mysql/en/SELECT.html Columns selected for output can be referred to in ORDER BY and GROUP BY clauses using column names, column aliases, or column positions. Column positions are integers and begin with 1: mysql> SELECT colleg

Re: (might be off list) MySQL AB

Hi, yes it is something like limited or incorporated, it stands for "Aktiebolag", which is a swedish word meaning literally "Sharecompany". It is related to the fact, I suppose, that MySQL is Swedish/Finnish in origin. /Johan mc wrote: > Hi, > > I would like to know what does the 'AB' in MySQL

Re: Using IF

Hi Keith, I think your problem comes down to the fact that IF() is a function that must return one value, when you put in your '*' you might be specifying more then one value to return. /Johan Keith wrote: g'day, Am having a bit of a problem with using IF. This is the error message I get: - SEL

Re: Group Query

Hi, you can use: SELECT COUNT(B.Booking_ID), User_Location FROM Users U LEFT JOIN Bookings B ON U.User_ID = B.User_ID GROUP BY(U.User_Location); /Johan shaun thornburgh wrote: Hi, The following table produces a query that shows all bookings that user has made and groups the number of bookings by t