Re: OT: SQL Question

2012 7:28 PM >Subject: OT: SQL Question > >My question is not specific to MySQL, even though I am using a MySQL db for >this project. I have a servlet/jsp/MySQL web site in production, and there >are about 2,000 records in the flights table. One of the foreign keys is >teacher_id

Re: OT: SQL Question

A many-to-many is generally best accomplished with a third linking table which contains the ids of the 2 records being linked ie. create table tflink ( flightid int; teacherid int; ); On Fri, Mar 23, 2012 at 10:28 PM, Mark Phillips wrote: > My question is not specific to MySQL, even though I am

OT: SQL Question

My question is not specific to MySQL, even though I am using a MySQL db for this project. I have a servlet/jsp/MySQL web site in production, and there are about 2,000 records in the flights table. One of the foreign keys is teacher_id. Up to this point, there is a one to many relationship between t

RE: SQL Question

responsabilité pour le contenu fourni. > Date: Tue, 3 Nov 2009 18:17:52 +0100 > From: n...@phibee.net > To: mysql@lists.mysql.com > Subject: SQL Question > > Hi > > i request a small help for know if it's possible. > > Anyone know if they have a Sql requ

SQL Question

Hi i request a small help for know if it's possible. Anyone know if they have a Sql request for search the best value at one information: Sample: i have a table with: ID int 5 Chaine int 16 and this entry: 1 12345 2 123 3 12 i am search a request in "WHERE" : Chaine LIKE '12345

Re: SQL question: find items tagged with specific tags

Ingo Weiss schrieb: Thanks, Sebastian! I have tried this one before. The problem is that it finds all items the tags of which include EITHER 'blue' OR 'red', not 'blue' AND 'red': oh ... "and" ..., i missred SELECT DISTINCT items.* FROM items INNER JOIN taggings ON item

Re: SQL question: find items tagged with specific tags

Thanks, Sebastian! I have tried this one before. The problem is that it finds all items the tags of which include EITHER 'blue' OR 'red', not 'blue' AND 'red': mysql> SELECT DISTINCT items.title from items inner join taggings on (items.id = taggings.item_id) inner join tags on (tags.id =

Re: SQL question: find items tagged with specific tags

Ingo Weiss schrieb: Hi all, I have an application where items can be tagged. There are three tables 'items', 'taggings' and 'tags' joined together like this: items inner join taggings on (items.id = taggings.item_id) inner join tags on (tags.id = taggings.tag_id) Now I have been struggli

SQL question: find items tagged with specific tags

Hi all, I have an application where items can be tagged. There are three tables 'items', 'taggings' and 'tags' joined together like this: items inner join taggings on (items.id = taggings.item_id) inner join tags on (tags.id = taggings.tag_id) Now I have been struggling for some time no

Re: SQL question

Is it just this line I need to change? INNER JOIN url_categories uc ON uc.ID=bt.category_ID; Would it change to something like: INNER JOIN url_categories uc ON CAST(uc.ID as CHAR)=delimit(bt.category_ID) Just guessing! Thanks - that's what I thought. I really don't have much experience with

Re: SQL question

Thanks - that's what I thought. I really don't have much experience with mySQL. If it's not too much trouble, could someone give me a bit more help on how to do that please? Ed. no, those won't match based on just the datatype change.. you will have to define a user defined function to do

Re: SQL question

Thanks, that's interesting. Actually the uc.ID column is still type tinyint as it holds only one number, but are you saying if I change this to varchar my query will work e.g. 15 = 15:17 would work? What is the type of the 'uc.ID' column? If it's varchar, your match will work fine. If it

SQL question

Hi, I have the following mySQL query in my script which has been working fine but due to a recent change, I had to modify one of the columns, bt.category_ID. This used to be defined as tinyint(3) but I've changed that now to varchar(20) as it needs to hold values such as 15, or 74:79 or 43:56

Re: SQL Question: alternative to crazy left joins?

e this problem using straight SQL. Ethan -- View this message in context: http://www.nabble.com/SQL-Question%3A-alternative-to-crazy-left-joins--t1357877.html#a3654455 Sent from the MySQL - General forum at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/

Re: SQL Question: alternative to crazy left joins?

| ContactID| Donation1.* | Donation2.* | Donation3.* | etc... > > Thanks in advance...off to Ruby to see if I can code some hack quick to get > this task done with...;) > > -Ethan > -- > View this message in context: http://www.nabble.com/SQL-Question%3A- > alternative-to-

SQL Question: alternative to crazy left joins?

he right direction. What I want is something like this: | ContactID| Donation1.* | Donation2.* | Donation3.* | etc... Thanks in advance...off to Ruby to see if I can code some hack quick to get this task done with...;) -Ethan -- View this message in context: http://www.nabble.com/SQL-Question

FW: Re: SQL Question

. mysql> SELECT ABS(2); -> 2 mysql> SELECT ABS(-32); -> 32 This function is safe to use with BIGINT values. -Original Message- From: Rhino [mailto:[EMAIL PROTECTED] Sent: Friday, January 06, 2006 12:19 PM To: Mester József; mysql Subject: [SPAM] - Re:

RE: [SPAM] - Re: SQL Question - Bayesian Filter detected spam

. mysql> SELECT ABS(2); -> 2 mysql> SELECT ABS(-32); -> 32 This function is safe to use with BIGINT values. -Original Message- From: Rhino [mailto:[EMAIL PROTECTED] Sent: Friday, January 06, 2006 12:19 PM To: Mester József; mysql Subject: [SPAM] - Re:

Re: SQL Question

- Original Message - From: "Mester József" <[EMAIL PROTECTED]> To: "Rhino" <[EMAIL PROTECTED]>; "mysql" Sent: Friday, January 06, 2006 12:07 PM Subject: Re: SQL Question Hy If you know which values are supposed to be negative, wouldn

Re: SQL Question

Hy If you know which values are supposed to be negative, wouldn't it be easier to do updates to your data to change all of those values to negatives? That should only need to be done once. Then use the normal SQL sum() function to add all of the values together. Thank you. Actually my first

Re: SQL Question

Hello. Do you want something similare to this: SELECT SUM(IF(moving like 'Move-',-moved_quantities,moved_quantites)) FROM DB; Have a look here: http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html Mester József wrote: > Hy > > I want to sum quantites but ther

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: "M

SQL Question

Hy I want to sum quantites but there is some data that value is negative but users didn't write the - sign before. I can decide which datas are negative. I would like something like that select sum(moved_quantities) from db if moving like 'Move-' then sum seem the move is negat

Re: SQL question

Hi All! I have a MySQL database (I have them using MySql at work for more stuff now!), and the definition is as follows: uid mediumint(6) NOT NULL auto_increment, ym varchar(6) default NULL, fileid varchar(8) default NULL, off char(3) default NULL, PRIMARY KEY (`uid`) TYPE=MyISAM uid is not re

Re: "How do I ..." SQL question

> > Return only four rows beginning at second row: > > > > SELECT count(*) AS count, name, year FROM a > > GROUP BY name, year > > ORDER BY count DESC, name ASC > > LIMIT 4 OFFSET 1; > > > > count name year > > --- -- -- > >3 joe2004 s,e,e > >2 bob20

Re: "How do I ..." SQL question

[EMAIL PROTECTED] wrote on 01/17/2005 06:45:22 PM: > Hi there: > > I have a "How do I..." SQL question regarding selecting > distinct values from a field not included in an aggregated > query when LIMIT is in effect, illustrated by the > following example: >

Re: "How do I ..." SQL question

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] writes: > SELECT DISTINCT place FROM a ; > place > --- > south > west > east > Note that the place north does not appear in the last result > because north was only visited by bob in 2005 and kim in 2004, > records which are not i

Re: "How do I ..." SQL question

Can't you do: SELECT count(*) AS count, name, year FROM a WHERE place IN ('south','west','east') GROUP BY name, year ORDER BY count DESC, name ASC LIMIT 4 OFFSET 1; [EMAIL PROTECTED] wrote: Hi there: I have a "How do I..." SQL question reg

"How do I ..." SQL question

Hi there: I have a "How do I..." SQL question regarding selecting distinct values from a field not included in an aggregated query when LIMIT is in effect, illustrated by the following example: Table a contains the names of individuals, the places they have visited and the year in

Re: General Sql question

On Fri, 03 Dec 2004 10:58:30 -0700, Steve Grosz wrote: > > I wrote my query as > select Cust_ID, Cust_Name > from mailings > where ucase(Name) = ucase(Cust_Name) > > When it runs, I get a error: > You have an error in your SQL syntax; check the manual that corresponds > to your MySQL server versi

Re: General Sql question

Does Name exist as a column in your table, or is it a ColdFusion variable? I know very little about how ColdFusion works, but it does parse the query, and alter it, before it gets sent to ODBC. Just looks like it's using ucase(Name) as a coldfusion function, then replacing it in the query. Just

Re: General Sql question

I am writing this by hand, and is being used within Coldfusion. MySql is v 4.1.7 and I am connecting via ODBC. Steve <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Your sample query is not valid SQL. What tool/language are you using to > run this query? There must be something int

Re: General Sql question

Your sample query is not valid SQL. What tool/language are you using to run this query? There must be something interpreting what you entered and mis-representing your query to the MySQL server. Without that piece of the puzzle I am completely in the dark. It would also help to know what versio

General Sql question

I am kinda new to SQL, and am having a problem trying to get something done. I'm trying to search for usernames in one of my tables. The name is stored as firstname lastname. I wrote my query as select Cust_ID, Cust_Name from mailings where ucase(Name) = ucase(Cust_Name) When it runs, I get a er

Re: SQL question.... Trying to improve upon my PHP solution.

At 11:53 AM 11/29/2004, you wrote: On 11/29/04 12:27 PM, "mos" <[EMAIL PROTECTED]> wrote: > Mike, >Your solution is way too complicated (it makes my head hurt). > Try this: > > set @n=0; > update tmp set rnd = @n := @n + 1 order by RAND() > > Mike I'll give this a shot. Follow-up question:

Re: SQL question.... Trying to improve upon my PHP solution.

On 11/29/04 1:26 PM, "Rhino" <[EMAIL PROTECTED]> wrote: > I don't think this is a question about SQL at all; I think you already know > how to write the SQL to select, insert, update or delete rows. > > I think that what you really want to know is if there is a more efficient > way to shuffle you

Re: SQL question.... Trying to improve upon my PHP solution.

- Original Message - From: "Mike Zornek" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 29, 2004 12:08 PM Subject: SQL question Trying to improve upon my PHP solution. > I have a table of members, about 13,000 rows. > > Each night

Re: SQL question.... Trying to improve upon my PHP solution.

On 11/29/04 12:27 PM, "mos" <[EMAIL PROTECTED]> wrote: > Mike, >Your solution is way too complicated (it makes my head hurt). > Try this: > > set @n=0; > update tmp set rnd = @n := @n + 1 order by RAND() > > Mike I'll give this a shot. Follow-up question: I've had a lot of trouble with

Re: SQL question.... Trying to improve upon my PHP solution.

At 11:08 AM 11/29/2004, you wrote: I have a table of members, about 13,000 rows. Each night I need to shuffle the table. I have a small int column called random_position. Currently I am creating a position list (based on the count of the members), shuffle it, then while iterating through the member

SQL question.... Trying to improve upon my PHP solution.

I have a table of members, about 13,000 rows. Each night I need to shuffle the table. I have a small int column called random_position. Currently I am creating a position list (based on the count of the members), shuffle it, then while iterating through the members assigning them a a position. $t

Re: Simple SQL Question

Good one. I don't know how I missed this either! Thanks! "gerald_clark" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > What about > select distinct a.region, a.city > from mytable a , mytable b > where a.region=b.region and a.city <> b.city > > Jay Blanchard wrote: > > >[snip] >

Re: Simple SQL Question

[snip] What about select distinct a.region, a.city from mytable a , mytable b where a.region=b.region and a.city <> b.city [/snip] Crud! Standing too close to the forest and forgot about a self join... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Simple SQL Question

What about select distinct a.region, a.city from mytable a , mytable b where a.region=b.region and a.city <> b.city Jay Blanchard wrote: [snip] Anybody? I have a simple problem and I'm just wondering the BEST query to solve it. I want to return all the rows of a table whose foreign key

Re: Simple SQL Question

[snip] Anybody? > > I have a simple problem and I'm just wondering the BEST query to solve it. > > I want to return all the rows of a table whose foreign key value exists > more > > than once in that table. IE... > > > > MyTable > > Region(foreign key)City > > EastB

Re: Simple SQL Question

Anybody? ""Jeff Burgoon"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Sorry, I forgot to mention I am using version 4.0.20a (no subqueries > supported) > > ""Jeff Burgoon"" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > I have a simple problem and I'm just wond

Re: Simple SQL Question

Sorry, I forgot to mention I am using version 4.0.20a (no subqueries supported) ""Jeff Burgoon"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I have a simple problem and I'm just wondering the BEST query to solve it. > I want to return all the rows of a table whose foreign key val

Simple SQL Question

I have a simple problem and I'm just wondering the BEST query to solve it. I want to return all the rows of a table whose foreign key value exists more than once in that table. IE... MyTable Region(foreign key)City EastBaltimore EastPhil

Re: An SQL question about using multiple tables

I don't know the source of the "INTERSECT" command that keeps popping up on the list but this is a straight-forward JOIN situation if I have ever seen one. Please read for more details: http://dev.mysql.com/doc/mysql/en/JOIN.html SELECT A.*, E.* FROM A INNER JOIN B ON A.ID = B.parentid

An SQL question about using multiple tables

Background: I have one master table A, and other supplementary tables B,C and D such that   for every row of A there can be one or more corresponding rows in B,C,D. There is another supplementary table E with which A has a one-to-one relationship. Problem: Given three search criteria resulting

Re: SQL question, SELECT DISTINCT

How about INSERT INTO original_table SELECT MAX(f1), f2, f3 FROM new_table GROUP BY f2, f3; Michael Stephen E. Bacher wrote: I had a similar problem, but my criteria for selecting the value of "f1" was different; it's a date field and I wanted only the rows with the most recent date value in th

Re: SQL question, SELECT DISTINCT

I had a similar problem, but my criteria for selecting the value of "f1" was different; it's a date field and I wanted only the rows with the most recent date value in that field, so only the "latest" of otherwise identical entries got inserted. I ended up doing something like this: create tempor

Re: SQL question, SELECT DISTINCT

Disregard by last message it's a repeat. THANKS for the help! On Mon, 16 Aug 2004 14:32:27 -0400, "Michael Stassen" <[EMAIL PROTECTED]> said: > Then I'd suggest you declare f1 as an AUTO_INCREMENT column in the target > table, leave it out of the SELECT, and let it auto-generate IDs. > Something

Re: SQL question, SELECT DISTINCT

On Mon, 16 Aug 2004 13:57:13 -0400, "Michael Stassen" <[EMAIL PROTECTED]> said: > You were perfectly clear. We understand that you only want to test f2 > and f3 for uniqueness. The question is, which of the possible values > of f1 do you want to get. Do you see? For a particular unique f2, f3

Re: SQL question, SELECT DISTINCT

Then I'd suggest you declare f1 as an AUTO_INCREMENT column in the target table, leave it out of the SELECT, and let it auto-generate IDs. Something like this: INSERT INTO original_table (f2, f3) SELECT DISTINCT f2, f3 FROM new_table; I did that in the same order as your original message, t

Re: SQL question, SELECT DISTINCT

On Mon, 16 Aug 2004 13:57:13 -0400, "Michael Stassen" <[EMAIL PROTECTED]> said: > You were perfectly clear. We understand that you only want to test f2 > and f3 for uniqueness. The question is, which of the possible values > of f1 do you want to get. Do you see? For a particular unique f2, f3

Re: SQL question, SELECT DISTINCT

You were perfectly clear. We understand that you only want to test f2 and f3 for uniqueness. The question is, which of the possible values of f1 do you want to get. Do you see? For a particular unique f2, f3 combination, there may be multiple f1 values. How should we choose which one to put

Re: SQL question, SELECT DISTINCT

On Mon, 16 Aug 2004 12:39:32 -0400, [EMAIL PROTECTED] said: > Let me see if I can explain it a little betterIf you need to move all > 3 columns to the new table but you only want *1* row where f2 and f3 have > a unique combination of values, how do you want to choose *which* value > of > f1

Re: SQL question, SELECT DISTINCT

Let me see if I can explain it a little betterIf you need to move all 3 columns to the new table but you only want *1* row where f2 and f3 have a unique combination of values, how do you want to choose *which* value of f1 to move over with that combination? Do you want the minimum value, the

Re: SQL question, SELECT DISTINCT

On Mon, 16 Aug 2004 11:36:32 -0400, [EMAIL PROTECTED] said: > It all depends on which values of f1 you want to ignore. > > f1 f2 f3 > - - -- > val1-1 val2 val3 > val1-2 val2 val3 > val1-3 val2 val3 > > Which value of f1 would you want in your new table? Which one

Re: SQL question, SELECT DISTINCT

It all depends on which values of f1 you want to ignore. f1 f2 f3 - - -- val1-1 val2 val3 val1-2 val2 val3 val1-3 val2 val3 Which value of f1 would you want in your new table? Which ones to ignore? Are there other columns (beyond these 3) to move as well? Yours,

SQL question, SELECT DISTINCT

say I'm selecting distinct (non-duplicate) rows for insertion, insert into original_table select distinct * from new_table these tables have 3 fields/row. Per the above code all 3 fields are evaluated by "distict *" . But my question is: I want to ignore field1, therefore I only want to test

Re: mysql sql question

| | cc: | | Fax to: | |

Re: mysql sql question

Bruce, >i have two hypothetical tables >create table owner ( >-> name char(20) , >-> ownerid int(10) auto_increment primary key); >create table dog ( >-> name char(20) , >-> ownerid int(10), >-> dogid int(10) auto_increment primary key); >i'm curious as to how i'd go about in

Re: mysql sql question

ob... You are correct. Good luck, --John > thanks > > -bruce > > > -Original Message- > From: Quentin Bennett > [mailto:[EMAIL PROTECTED] Sent: > Sunday, July 04, 2004 3:49 PM > To: [EMAIL PROTECTED] > Cc: MySQL (E-mail) > Subject: RE: mysql s

RE: mysql sql question

al Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED] Sent: Sunday, July 04, 2004 3:49 PM To: [EMAIL PROTECTED] Cc: MySQL (E-mail) Subject: RE: mysql sql question Hi, The insert says 'insert data in to two columns, name and collegeid'. The select says "get two columns, 'to

RE: mysql sql question

of the insert be derived from.. -bruce -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED] Sent: Sunday, July 04, 2004 3:41 PM To: [EMAIL PROTECTED]; Emmett Bishop; [EMAIL PROTECTED] Subject: RE: mysql sql question Hi, You've already specified some values, so you c

RE: mysql sql question

mysql> insert into dept (name,collegeid) -> select name, id from test where name="sammy"; -Original Message- From: bruce [mailto:[EMAIL PROTECTED] Sent: Monday, 5 July 2004 10:50 a.m. To: Quentin Bennett Subject: RE: mysql sql question i can't see how this would wor

RE: mysql sql question

to:[EMAIL PROTECTED] Sent: Monday, 5 July 2004 10:41 a.m. To: 'Emmett Bishop'; [EMAIL PROTECTED] Subject: RE: mysql sql question i created the following as a simple test... mysql> describe test; +---+--+--+-+-+

RE: mysql sql question

7;t it be possible to extend the basic approach to multiple tables, using FROM tbl1, tbl2, tbl3.. - -Original Message- From: bruce [mailto:[EMAIL PROTECTED] Sent: Sunday, July 04, 2004 3:26 PM To: 'Emmett Bishop'; [EMAIL PROTECTED] Subject: RE: mysql s

RE: mysql sql question

me = $ownername; -bruce -Original Message- From: Emmett Bishop [mailto:[EMAIL PROTECTED] Sent: Sunday, July 04, 2004 12:59 PM To: [EMAIL PROTECTED] Subject: Re: mysql sql question Bruce, what you want it the insert into ... select statement. It's like this: insert into dog (name,

RE: mysql sql question

riginal Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Sunday, July 04, 2004 12:59 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: mysql sql question At 12:54 -0700 7/4/04, bruce wrote: >hi... > >i have two hypothetical tables >create table ow

Re: mysql sql question

At 12:54 -0700 7/4/04, bruce wrote: hi... i have two hypothetical tables create table owner ( -> name char(20) , -> ownerid int(10) auto_increment primary key); create table dog ( -> name char(20) , -> ownerid int(10), -> dogid int(10) auto_increment primary key); i'm curious as

mysql sql question

hi... i have two hypothetical tables create table owner ( -> name char(20) , -> ownerid int(10) auto_increment primary key); create table dog ( -> name char(20) , -> ownerid int(10), -> dogid int(10) auto_increment primary key); i'm curious as to how i'd go about inserting a

Re: sql question

Maybe something like: Select LIKE pkg_name%, LIKE site_%, version from table group by LIKE pkg_name% , LIKE site_%; but I'm still a beginner. Respectfully, Ligaya Turmelle <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello all, > > I've a table like this : > > site_1 pkg_name_

sql question

Hello all, I've a table like this : site_1 pkg_name_1 version site_1 pkg_name_2 version site_1 pkg_name_3 version ... site_1 pkg_name_n version site_2 pkg_name_1 version site_2 pkg_name_2 version ... site_2 pkg_name_n version ... site_n pkg_name_1 version ... site_n pkg_name_n v

RE: SQL question: Finding duplicates

> > row | foo > 1 | a > 2 | c > 3 | b > 4 | c > 5 | a > 6 | d > > the statement would return me rows 1, 2, 4, and 5. > CREATE TEMPORARY TABLE temptable SELECT * FROM test GROUP BY foo HAVING COUNT( * ) >1 ORDER BY foo ASC ; SELECT * FROM test, temptable WHERE test.foo = temptable.f

SQL question: Finding duplicates

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Disclaimer: I'm not an SQL expert so please don't laugh. ;-) I'm trying to generate a way to find all rows from a table where the data in column 'foo' is a duplicate of the data in another row. I.E.: row | foo 1 | a 2 | c 3 | b 4 | c 5 |

sql question

Hi Using mysql 3.23.54 I'm trying to join three tables. categories, topics, posts. I just want the categories to print out, with the number of topics in each category, and the number of posts in each topic. ex output: Category | Topics | Posts Cat One | 3

RE: Sql question

you want to do insert into mytable (column1, column2, column3) (select thiscolumn, '1', now() from anotherTable); > Mysql 3.. > > I can't figure this one out > > > > I need to move data from one mysql table to another > > The hurdle for me is adding additional column values. > > Here is w

Re: Sql question

Keith Schuster <[EMAIL PROTECTED]> wrote: > Mysql 3.. > > I can't figure this one out > > I need to move data from one mysql table to another > > The hurdle for me is adding additional column values. > > Here is what I have. > > > insert into mytable (column1, column 2, column3) > (Select thi

Sql question

Mysql 3.. I can't figure this one out I need to move data from one mysql table to another The hurdle for me is adding additional column values. Here is what I have. insert into mytable (column1, column 2, column3) (Select thiscolumn >From anotherTable), '1', now(); It's the 1 and the no

Re: Newbie SQL question

Keith, You're on the right track. But instead of 2 tables, pretend you have three. 1) Home Teams, 2) Schedule 3) Opponent Teams. In reality tables 1 and 3 are the same table, but you mus't get confused between using 'Teams' as Home Teams and Teams as Opponents. In the same way as you named columns

Newbie SQL question

I'm coming from a Filemaker Pro background and have very little SQL experience. I'm trying to write an SQL statement to extract data from two tables. One table has the Team IDs, Team Names for all the high school football teams in the state. The other table has the schedules for all the games. T

basic SQL question

Dear all, I have the following problem, I am trying to select records from two tables. the tables are constructed like: block block_id sequence_id snp_required first_polymorphism_index last_polymorphism_index first_reference_positio last_reference_position start_pos end_pos tiled_bp polymorphis

RE: basic SQL question

in -Original Message- From: Gomez Fabre, Pedro Manuel [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 5:19 AM To: [EMAIL PROTECTED] Subject: basic SQL question Dear all, I have the following problem, I am trying to select records from two tables. the tables are constructed like:

Re: (SQL Question) WHERE NOT IN A LIST

At 12:29 -0500 7/18/03, Tom O'Neill (MySQL User) wrote: Hi, Is there a way I can run a query that will delete all items that are not in a list? For example I have a bunch of records in a table and I want to remove all of them that are not in a comma delimited list that I have recieved from anothe

(SQL Question) WHERE NOT IN A LIST

Hi, Is there a way I can run a query that will delete all items that are not in a list? For example I have a bunch of records in a table and I want to remove all of them that are not in a comma delimited list that I have recieved from another application. I was thinking that I could create a que

Re: SQL question

Jake Johnson wrote: Nice approach Bruce, but I too won't have any problems with your case because I am grouping by sku and stock in the sub-query. You're right; you do avoid the problem with the specific sample data I gave you. Sorry about that! But, there are still potential problems because

Re: SQL question

Nice approach Bruce, but I too won't have any problems with your case because I am grouping by sku and stock in the sub-query. Regards, Jake Johnson [EMAIL PROTECTED] -- Plutoid - http://www.plutoid.com Shop Plutoid for the best pric

Re: SQL question

Jake Johnson wrote: This is one quick way to get the newest records of a group if you are grouping by the sku and stock. select stock, sku, qty from table where concat(dt_tm,stock,sku) IN ( select concat(max(dt_tm), stock, sku) from table group by stock, sku ) Another approach (also assuming a cur

Re: SQL question

This is one quick way to get the newest records of a group if you are grouping by the sku and stock. select stock, sku, qty from table where concat(dt_tm,stock,sku) IN ( select concat(max(dt_tm), stock, sku) from table group by stock, sku ) Regards, Jake Johnson [EMAIL PROTECTED] -

SQL question

Hi, I have a SQL issue I cannot figure out, perhaps somebody can help / solve / input on this ... I have a table with stock-status transactions like ... 2003-06-17 06:00 stockA SKU1 QTY 98 2003-06-16 06:10 stockA SKU1 QTY 101 2003-06-15 04:59 stockA SKU1 QTY 111 - the time for updating the tra

Re: SQL question - no CREATE VIEW in mysql

Luca, > In Oracle I could create a view from the initial table, what about MySQL? MySQL will support views as of version 5.1. I cannot find it in the todo (http://www.mysql.com/doc/en/TODO.html) but I saw it elsewhere. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH

SQL question - no CREATE VIEW in mysql

Hi People. SQL problem: given a table where each column is a number, let's say that I wish to create a second table where columns are the sum of specific columns of the first, i.e.: col_1 + col_2 + col_3 + col_4 > col_1 of second table col_5 + col_6 + col_7 + col_8 > col_2 of se

Re: SQL Question

On 16 Dec 2002, at 23:50, Stefan Hinz, iConnect (Berlin wrote: > > I need to construct a query to find out what customers in the database > > have not > > booked shipments with us. That means there would be no > > records in the shipment table for a given customer id. > > If I get this right, it

Re: SQL Question

rmany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "Darren Young" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 16, 2002 11:24 PM Subject: RE: SQL Question > > I have 2 tables i

RE: SQL Question

I have 2 tables in our MySQL database like this: TABLE: customers +--+---+--+-+-+- ---+ | Field| Type | Null | Key | Default | Extra | +--+---+--+-+---

re: SQL question

John, Tuesday, November 05, 2002, 1:50:32 AM, you wrote: JJ> I have a callers table and a citylist table. Both tables have a field JJ> 'town' and both tables have a field called 'zipcode'. JJ> The citylist is a list of cities and their zip codes. JJ> citylist.city and citylist.zipcode JJ> The c

SQL question

Hello, anyone care to show me how I can do this in SQL? I have a callers table and a citylist table. Both tables have a field 'town' and both tables have a field called 'zipcode'. The citylist is a list of cities and their zip codes. citylist.city and citylist.zipcode The callers table has the

RE: newbie: SQL question

Try this: http://www.devshed.com/Server_Side/MySQL - Hi, I am just a starter. Anyone can suggest me good web resources for learning SQL command that I can use (compatible) with mySQL ? I read from www.mysql.com documentation, but it's not complete ... Well, if you hav

  1   2   3   >