- Original Message -
> From: "David Lerer"
>
> Have you tried to set city = null (i.e. without the quotes)?
Spot on, I'd think.
NULL values are not a string with "NULL" in it - that's only what it looks like
in query results :-) An empty string ('') is to strings what 0 (zero) is for
sage-
> From: Richard Reina [mailto:gatorre...@gmail.com]
> Sent: Friday, March 09, 2012 4:24 PM
> To: mysql@lists.mysql.com
> Subject: query problem with null
>
> When I do the following query:
>
> SELECT * FROM geo_trivia WHERE city IS NULL;
>
> certain columns
Have you tried to set city = null (i.e. without the quotes)? David.
-Original Message-
From: Richard Reina [mailto:gatorre...@gmail.com]
Sent: Friday, March 09, 2012 4:24 PM
To: mysql@lists.mysql.com
Subject: query problem with null
When I do the following query:
SELECT * FROM
When I do the following query:
SELECT * FROM geo_trivia WHERE city IS NULL;
certain columns that DO have 'NULL' value for city and not a '' (blank)
value do not show up.
I have even gone to the extent of reseting these records value as ='NULL'
with UPDATE and they are still are not selected when
Is this what you meant?
SELECT * FROM tbl where Fname REGEXP '^[abcd]' AND Lname REGEXP '^[abcd]'
(alternatively, the extression could be simpliefied as "REGEXP '^[a-d]" )
- md
On Fri, Oct 22, 2010 at 11:01 AM, bharani kumar
wrote:
> in my database,
>
>
> if i want to render firstname and la
in my database,
if i want to render firstname and lastname match case ,
am using REGEXP '^[abcd]' WORK FOR SINGLE FIELD,
Now i have fname and lastname ,
How to make the query , which display both and single field satisfieds
records ,
That is my query should return like
Name(combined Firstnam
You regular expression is alittle off. You don't need the OR operator
'|' inside the character class definition, it is implied. Try this:
[php]
SELECT * FROM tbl where Fname REGEXP '^[abcd]'
[/php]
- michael dykman
On Thu, Oct 21, 2010 at 11:07 PM, bharani kumar
wrote:
> Hi ,
>
> Am just try
Hi ,
Am just trying alphabetical pagination ,
Yes there is lot of pager class there for this ,
but in my requirement little but diff , that is
totally 4 sets ,
A-DE-H I-PQ-S (Assume there are pager links)
When user click the A-D , then it should show all the customer name starting
Try using the IS NULL operator instead of !
-Travis
-Original Message-
From: Andy Wallace [mailto:awall...@ihouseweb.com]
Sent: Thursday, September 16, 2010 10:47 AM
To: mysql@lists.mysql.com
Subject: Update query problem
So I'm having a problem with an update query. I have
So I'm having a problem with an update query. I have three tables:
Table: A
Columns: acnt, name, company, email, domain
Table: AM
Columns: acnt, m_id
Table: M
Columns: m_id, name, company, email, domain
and I want to conditionally update the columns in one to values from the
other. i.e.,
exact
> columns interms of wat is suppliers which table is it coming from
> etc.
>
> -Original Message-
> From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
> Sent: Monday, December 22, 2008 5:16 PM
> To: Baron Schwartz; [MySQL]
> Subject: Re: Distinct Query Probl
On Fri, Dec 19, 2008 at 1:03 PM, Tompkins Neil
wrote:
> Hi,
>
> I've the following query which I'm having problems with. Basically I have
> a 5 tables as follows :
>
> MasterTB - Contains list of master records
> LookupTB - Contains relationship between MasterTB to ProductTB
> ContentTB - Contain
OK, I've made further progress by changing GROUP BY ProductTB.ProductID,
MasterTB.MasterID to GROUP BY MasterTB.MasterID.
However ProductTB.Supplier is showing the incorrect Supplier. Why is this ?
Thanks
Neil
On Mon, Dec 22, 2008 at 11:45 AM, Tompkins Neil <
neil.tompk...@googlemail.com> wrote
Hi,
If anyone could point me in the right direction, I'd be most grateful.
Thanks !
Neil
On Mon, Dec 22, 2008 at 9:55 AM, Tompkins Neil wrote:
> Hi
>
> I'm having trouble trying to figure this out. Any help/example would be
> grateful.
>
> Thanks
> Neil
>
> On Sun, Dec 21, 2008 at 4:30 PM,
Hi
I'm having trouble trying to figure this out. Any help/example would be
grateful.
Thanks
Neil
On Sun, Dec 21, 2008 at 4:30 PM, Baron Schwartz wrote:
> On Fri, Dec 19, 2008 at 1:03 PM, Tompkins Neil
> wrote:
>
> > of products for all suppliers for a particular product. However I want
> to
On Fri, Dec 19, 2008 at 7:03 PM, Tompkins Neil wrote:
> Basically each product is listed in the master table, and can have a number
> of suppliers linked to it (ProductTB). The query above will show me a list
> of products for all suppliers for a particular product. However I want to
> be able to
Hi,
I've the following query which I'm having problems with. Basically I have
a 5 tables as follows :
MasterTB - Contains list of master records
LookupTB - Contains relationship between MasterTB to ProductTB
ContentTB - Contains description of product, and location of data files
PriceTB - Contai
I am trying to display results from one or the other part of the
query, however, at the moment it is showing results from both parts.
The Replace part of the query works fine in that it chooses the
correct data to display, but the content relevant to /8/ always
displays even when I select,
On Wed, Apr 16, 2008 at 4:35 AM, sivasakthi <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> Iam having the one table name called AccessDetails and data inside that
> tables is following,
>
[snip=schema]
>
> In that , I need to calculate the number of total sites , number of
> total Accessed Sites,num
Hi all,
Iam having the one table name called AccessDetails and data inside that
tables is following,
DateTime UserName SiteName
ScanType Status Virus_Category
| 2008-04-16 | 13:05:31 | 172.16.1.22 | - | www.veer.com
|C | A
Dear Mat,
Your mail is not very clear. But I have a feeling that using '%' wildcard in
the like operand should help you
Regards,
Ravi.
On 11/14/07, Matthew Stuart <[EMAIL PROTECTED]> wrote:
>
> Hi, I have built a site with Dreamweaver and I have a problem with a
> query.
>
> I am trying to
Hi, I have built a site with Dreamweaver and I have a problem with a
query.
I am trying to pass a parameter from one page to another to drill
down. Basically, I have one product entry that is in multiple
categories on my website. So, say it's a dress, it is therefore
related to category 1
Thanks Jay,
I had to make a change to the first part of the query to get the results that I
wanted but your suggestion was definitely what I needed to get to the solution.
Thanks again.
For those that are interested, here's the final solution,
INSERT INTO purchase (Source, Item, Qty)
SELEC
Ed Reed wrote:
Hi All,
I have an issue that I need to resolve that is difficult to explain. I
hope that someone can understand what I*m trying to do and shed some
light on a solution. Here goes.
I have three tables, inventory, which is a list of transactions with
positive and negative value
Hi All,
I have an issue that I need to resolve that is difficult to explain. I
hope that someone can understand what I*m trying to do and shed some
light on a solution. Here goes.
I have three tables, inventory, which is a list of transactions with
positive and negative values; request, which e
> how do I return a single row per property even if it has 3 or 4 images
> attached to it.
Please reply to the list instead of directly to me.
You could do a:
select p.from properties p where exists (select i.* from images i
where i.property_id = p.property_id)
> > >I have a table of propert
No I want all the properties only one regardless of how many images are
attached to them. Think I need a distinct in there somewhere,
- Original Message -
From: "Jon Ribbens" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, May 09, 2007 6:56 PM
Subject: Re: Query problem
On Wed, May 09, 2007 at 07:14:38PM +0200, Martijn Tonies wrote:
> >I have a table of properties that is linked to a table f images with a one
> property to many images relationship. I >have manged this with nested
> queries but want to try and do it on one line. My current query
> >
> >$query = "S
>I have a table of properties that is linked to a table f images with a one
property to many images relationship. I >have manged this with nested
queries but want to try and do it on one line. My current query
>
>$query = "SELECT * FROM images, properties WHERE images.property_id =
properties.prop
I have a table of properties that is linked to a table f images with a one
property to many images relationship. I have manged this with nested queries
but want to try and do it on one line. My current query
$query = "SELECT * FROM images, properties WHERE images.property_id =
properties.prope
Dan,
Actually you were on the right track. I changed your suggested query
to the following and it seems to work and is a lot quicker.
SELECT id, subject, updated FROM mrldisc WHERE updated > SUBDATE(NOW
(), INTERVAL 48 HOUR) AND mainthread = 'T' ORDER BY updated DESC
LIMIT 50
Thanks.
A
On 8/3/06, André Hänsel <[EMAIL PROTECTED]> wrote:
Hi Dan, hi Obed,
of course I have no specific username, I want the last 5 downloads of each
distinct username in the table. :)
i was thinking a lot... and i can't find the solution but maybe yo
can do somthing like this
select user,downl
André Hänsel wrote:
>> -Ursprüngliche Nachricht-
>> Von: Miles Thompson [mailto:[EMAIL PROTECTED]
>> Gesendet: Donnerstag, 3. August 2006 21:56
>> An: mysql@lists.mysql.com
>> Betreff: Re: Query problem
>>
>> At 03:08 PM 8/3/2006, André H
> -Ursprüngliche Nachricht-
> Von: Miles Thompson [mailto:[EMAIL PROTECTED]
> Gesendet: Donnerstag, 3. August 2006 21:56
> An: mysql@lists.mysql.com
> Betreff: Re: Query problem
>
> At 03:08 PM 8/3/2006, André Hänsel wrote:
>
> >I have a table logging downl
At 03:08 PM 8/3/2006, André Hänsel wrote:
Hi,
I have a table logging downloads (time, username, download).
Now I'd like to have the last 5 downloads per user.
Can someone tell me a solution (or what to search for)?
Regards,
André
--
MySQL General Mailing List
For list archives: http://list
;
>> -Ursprüngliche Nachricht-
>> Von: Dan Buettner [mailto:[EMAIL PROTECTED]
>> Gesendet: Donnerstag, 3. August 2006 20:15
>> An: André Hänsel
>> Cc: mysql@lists.mysql.com
>> Betreff: Re: Query problem
>>
>> For a specific username:
>>
>
Hänsel
> Cc: mysql@lists.mysql.com
> Betreff: Re: Query problem
>
> For a specific username:
>
> SELECT username, time, download
> FROM table
> WHERE username = 'someusername'
> ORDER BY time DESC
> LIMIT 5
>
> Dan
>
> On 8/3/06, André Hänsel &
For a specific username:
SELECT username, time, download
FROM table
WHERE username = 'someusername'
ORDER BY time DESC
LIMIT 5
Dan
On 8/3/06, André Hänsel <[EMAIL PROTECTED]> wrote:
Hi,
I have a table logging downloads (time, username, download).
Now I'd like to have the last 5 downloads per
On 8/3/06, André Hänsel <[EMAIL PROTECTED]> wrote:
Hi,
I have a table logging downloads (time, username, download).
Now I'd like to have the last 5 downloads per user.
Can someone tell me a solution (or what to search for)?
SELECT download FROM table WHERE username='user' ORDER BY time DES
Hi,
I have a table logging downloads (time, username, download).
Now I'd like to have the last 5 downloads per user.
Can someone tell me a solution (or what to search for)?
Regards,
André
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://l
Barry wrote:
Nenad Bosanac schrieb:
Hi I have one problem that i can`t resolve.
still need advice or is it solved?
IF!!! you need IF!! :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Nenad Bosanac schrieb:
Hi
I have one problem that i can`t resolve.
still need advice or is it solved?
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
Hi
I have one problem that i can`t resolve.
I have 3 tables
TABLE `predmet` (
`PredmetID` int(10) unsigned NOT NULL
auto_increment,
`BrojPredmeta` int(10) unsigned NOT NULL default
'0',
`VrstaPredmetaID` int(10) unsigned NOT NULL default
'0',
`KorisnikID` int(10) unsigned NOT NULL default
Rhino wrote:
- Original Message - From: "John Meyer" <[EMAIL PROTECTED]>
To: "List: MySQL"
Sent: Tuesday, May 30, 2006 5:09 PM
Subject: Query problem
Setup
TITLES:
TITLE_ID
AUTHORS:
AUTHOR_ID
TITLE_AUTHOR:
(TITLE_ID,AUTHOR_ID)
Problem:
Given a tit
- Original Message -
From: "John Meyer" <[EMAIL PROTECTED]>
To: "List: MySQL"
Sent: Tuesday, May 30, 2006 5:09 PM
Subject: Query problem
Setup
TITLES:
TITLE_ID
AUTHORS:
AUTHOR_ID
TITLE_AUTHOR:
(TITLE_ID,AUTHOR_ID)
Problem:
Given a title, I need t
Setup
TITLES:
TITLE_ID
AUTHORS:
AUTHOR_ID
TITLE_AUTHOR:
(TITLE_ID,AUTHOR_ID)
Problem:
Given a title, I need to find all the authors who aren't connected with
that particular book.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://list
>
To: "'Luke'" <[EMAIL PROTECTED]>;
Sent: Wednesday, May 24, 2006 2:16 AM
Subject: RE: Query problem: UNION in subquery
Hi Luke..
Try this
SELECT ObjectId FROM
(SELECT f15.Form15SampleTube1RnaBarcode AS ObjectId,
f15.Form15PatientID AS PtId FROM form15 f15
WHER
15PatientID AS PtId FROM form15 f15
WHERE f15.Form15SampleTube6RnaBarcode IN ('01D2V','01DH6'))as abc
Cheers :)
Neeraj Black Bits
-Original Message-
From: Luke [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 24, 2006 9:36 AM
To: mysql@lists.mysql.com
Subject: Quer
Hello!
I have a problem using UNIONs inside subqueries. I have simplified my
query to make it more readable/understandable.
The question is about the right syntax.
1.
This works fine /UNION/
(SELECT f15.Form15SampleTube1RnaBarcode AS ObjectId,
f15.Form15PatientID AS PtId FROM form15 f1
On Wed, 8 Mar 2006 10:12:22 - <[EMAIL PROTECTED]> wrote:
> but I have two other filters which may or may not be chosen. (area, and
> interest).
>
> $query = "SELECT * FROM $table_name WHERE sname LIKE '$search_string%' AND
> area='area' AND interest='interest' ORDER BY fname $type";
>
>
[EMAIL PROTECTED] wrote:
I am fairly new to sql and am now getting into the area of slightly
more complex queries.
At present my query is
$query = "SELECT * FROM $table_name WHERE sname LIKE '$search_string%'
ORDER BY fname $type";
but I have two other filters which may or may not be chosen
On 3/8/06, Adrian Bruce <[EMAIL PROTECTED]> wrote:
> one solution (may not be the best but would work) would be to use 'like'
> instead of '=' and then put wildcards %%$var % around the variable so
> that if it is not there then it wount effect the query.
>
Yeah, I use this kind of "trick" for SEL
one solution (may not be the best but would work) would be to use 'like'
instead of '=' and then put wildcards %%$var % around the variable so
that if it is not there then it wount effect the query.
Ade
[EMAIL PROTECTED] wrote:
I am fairly new to sql and am now getting into the area of slight
I am fairly new to sql and am now getting into the area of slightly more
complex queries.
At present my query is
$query = "SELECT * FROM $table_name WHERE sname LIKE '$search_string%'
ORDER BY fname $type";
but I have two other filters which may or may not be chosen. (area, and
interest).
I am fairly new to sql and am now getting into the area of slightly more
complex queries.
At present my query is
$query = "SELECT * FROM $table_name WHERE sname LIKE '$search_string%'
ORDER BY fname $type";
but I have two other filters which may or may not be chosen. (area, and
interest).
Sheeri,
Thanks for the help. I tried your sample queries, but they dont really
return what I'm looking for. I think I've found a solution though.
Given the contents of a case, I'm looking for a unique case id, basicially I
want to search for a case if it exists once I've decided the configuration
You originally mention your UNION "doesn't work" but you did not
specify the query. This is a simple or query, or union. You can do
either:
select CaseType_idCaseType,Sizes_idsizes,qty from CaseType_has_Sizes
where (qty=1 and Sizes_idsizes=2) or (qty=1 and Sizes_idsizes=4);
or
select CaseType_
Sheeri,
The table I'm searching on has a composite primary key since it's mapping an
N:M relationship between Cases and Sizes.
Here's the create statement for the table I'm searching on:
DROP TABLE IF EXISTS `CaseType_has_Sizes`;
CREATE TABLE `CaseType_has_Sizes` (
`CaseType_idCaseType` int(10
Hi Conor,
The table you showed us has 2 primary keys, which is not possible.
Can you do a SHOW CREATE TABLE on *each* table?
-Sheeri
On 2/8/06, Conor McTernan <[EMAIL PROTECTED]> wrote:
> Hello, I'm having a hell of a time figuring this query out, maybe someone
> can point me in the right direc
Hello, I'm having a hell of a time figuring this query out, maybe someone
can point me in the right direction.
I have a table which lists the case configurations for cases of items. Each
case will have a different combination of sizes e.g. Case 002 has 2 size 5,
2 size 7 and 2 size 8 items.
What
Hi,
An alternative for any MySQL version (from 3.23.??) would be:
SELECT r1.question_id,count(r1.member_id)
FROM Records r1
LEFT JOIN Records r2 ON r1.question_id=r2.question_id
AND r2.member_id=
WHERE r2.question_id IS NULL;
Hello.
Perhaps this will work (depends on the version of MySQL you're using):
select question_id
, count(*)
from Records
group by question_id
having question_id not in (
select distinct question_id
from Records r
wher
Hello,
I have a simple Records table with two columns, member_id and question_id.
The object of the query is to retrieve the question_id, as well as how many
times it's been answered - as long as the current user hasn't answered it
(member_id). So, the query shouldn't return any question_id
Dusan.
- Original Message -
From: "Tomas Rasek" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, December 21, 2005 11:12 AM
Subject: Re: Delete query problem
What about
DELETE master_tbl,detail_tbl FROM master_tbl LEFT JOIN detail_tbl ON
master_tbl.ID=detail_tbl.ID WHERE .
T.R.
On 21/12/2005, Dušan Pavlica wrote:
> Hello,
> I have master-detail tables and I would like to delete in one
> statement master record and all detail records but not every master
> record has details. MySQL versions 4.1.10 and higher. Could someone
> help me, please, to create such a query?
>
What about
DELETE master_tbl,detail_tbl FROM master_tbl LEFT JOIN detail_tbl ON
master_tbl.ID=detail_tbl.ID WHERE .
T.R.
Dušan Pavlica napsal(a):
Hello,
I have master-detail tables and I would like to delete in one statement master record and all detail records but not every master rec
Hello,
I have master-detail tables and I would like to delete in one statement master
record and all detail records but not every master record has details.
MySQL versions 4.1.10 and higher.
Could someone help me, please, to create such a query?
Example:
CREATE TABLE `master_tbl` (
`ID` int(
hino wrote:
- Original Message - From: "Jeff" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, November 29, 2005 11:42 AM
Subject: Insert query problem
All,
I can't get this query to run, it keeps compaining that there is a
problem:
The Query:
insert into
tickets
(id,from,dep
- Original Message -
From: "Jeff" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, November 29, 2005 11:42 AM
Subject: Insert query problem
All,
I can't get this query to run, it keeps compaining that there is a
problem:
The Query:
insert into
tickets(id,from,de
You can use backticks ( ` ) to escape the names:
INSERT INTO `tickets` ( `id` , `from` , `departement` .
hth,
melanie
From: "Jeff" <[EMAIL PROTECTED]>
To:
Subject: Insert query problem
Date: Tue, 29 Nov 2005 11:42:34 -0500
All,
I can't get this query to run, it
Many Many wrong SQL syntax error check your symbol (') becareful it 'very
important .
You can do that.
Cheer!!
From: "Jeff" <[EMAIL PROTECTED]>
To:
Subject: Insert query problem
Date: Tue, 29 Nov 2005 11:42:34 -0500
All,
I can't get this query to run, it k
Jeff wrote:
tickets(id,from,department,subject,body,lastaction,lastpost,priority,sta
tus,created,fromname,lastpostname,attach,ct,uniq,notify,replyto)
values(null,'jmckeon','1','test','test
test',unix_timestamp(now()),'"[EMAIL PROTECTED]"
<[EMAIL PROTECTED]>','Medium','Open',unix_timestamp(now())
Nevermind, found that usig `from` works.
Jeff
> -Original Message-
> From: Jeff [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 29, 2005 11:43
> To: mysql@lists.mysql.com
> Subject: Insert query problem
>
>
> All,
>
> I can't get this query to
"Jeff" <[EMAIL PROTECTED]> wrote on 11/29/2005 11:42:34 AM:
> All,
>
> I can't get this query to run, it keeps compaining that there is a
> problem:
>
> The Query:
>
> insert into
> tickets(id,from,department,subject,body,lastaction,lastpost,priority,sta
> tus,created,fromname,lastpostname,atta
All,
I can't get this query to run, it keeps compaining that there is a
problem:
The Query:
insert into
tickets(id,from,department,subject,body,lastaction,lastpost,priority,sta
tus,created,fromname,lastpostname,attach,ct,uniq,notify,replyto)
values(null,'jmckeon','1','test','test
test',unix_time
Hello.
You should solve the issue with server crashes. I'm not familiar with JDBC,
and if changing the values of parameters with SET statement doesn't work
with JDBC, probably somebody clever on the list could help you. You may
forward your message to:
http://lists.mysql.com/java
Hi,
Yes the server dies during the queries from JDBC.
Regarding the client parameters, what if the client doesn't have mySQL
installed?
Amir
Hello.
Does SHOW STATUS executed from JDBC client return increased values of
this parameters? Could your server die during queries from JDBC (ch
Hello.
Does SHOW STATUS executed from JDBC client return increased values of
this parameters? Could your server die during queries from JDBC (check the
error log)? Sometimes you should increase interactive_timeout as well. A lot of
variables usually could be changed using SET statement. See:
Hi,
Sometimes when querying mySQL 4.1.11 on Linux machine I get the error
"Lost connection to MySQL server during query". Here are the symptoms
1. When running the query from the server it returns OK
2. When running the query from another machine using the mySQL
query browser it r
Hi,
This is driving me nuts, please tell me is this a bug or a problem wiht my
query:
jappz_guestbook(owner_cno, sent_datetime, is_secret, accepted)
jappz_member_profile(cno, pic_name)
jappz_guestbook's owner_cno and jappz_member_profile's cno are the same
what i need to do is select * fro
Ok, Thanks for all Roger.
-Mensaje original-
De: Roger Baklund [mailto:[EMAIL PROTECTED]
Enviado el: viernes, 22 de abril de 2005 4:06
Para: Dto. Sistemas de Unitel
CC: mysql@lists.mysql.com
Asunto: Re: Query Problem
Dto. Sistemas de Unitel wrote:
> You don't understand me, I re
Dto. Sistemas de Unitel wrote:
You don't understand me, I refer that if in a table I use productos.prod_id
and in other table indexes.id if I can use this two fields like the same
index, because when I named the two equal, the index start to work fine.
There should be no problem with joining two ta
EMAIL PROTECTED]
Enviado el: jueves, 21 de abril de 2005 18:17
Para: mysql@lists.mysql.com
CC: Dto. Sistemas de Unitel
Asunto: Re: Query Problem
Dto. Sistemas de Unitel wrote:
> Hi Roger,
>
> You are ok, there was an index problem in one table, they name of the rows
> wasn't equal and
Dto. Sistemas de Unitel wrote:
Hi Roger,
You are ok, there was an index problem in one table, they name of the rows
wasn't equal and MySQL didn't recognize they as the same index. I have
changed the row name and now is working fine, but I have a little question,
How can I use indexes with different
's tables?
Thanks for your help, you have been very helpful for me.
Roberto
-Mensaje original-
De: Roger Baklund [mailto:[EMAIL PROTECTED]
Enviado el: miércoles, 20 de abril de 2005 18:30
Para: mysql@lists.mysql.com
CC: Dto. Sistemas de Unitel
Asunto: Re: Query Problem
Dto. Sistemas
Dto. Sistemas de Unitel wrote:
Hi Roger,
That was just I need. The order isn’t like you say:
++-+---++---+-+-
++---+-+
| id | select_type | table | type | possible_k
Hi Roger,
That was just I need. The order isnt like you say:
++-+---++---+-+-
++---+-+
| id | select_type | table | type | possible_keys | key | key_len
| ref
Dto. Sistemas de Unitel wrote:
[...]
something like
/indexes.id=productos.prod_id and indexes.id_termino=terminos.id_termino
and termino="computer" and termino=”intel”/ I know that is impossible,
but maybe there is another way to make that).
Yes, there is another way. You _can_ join the same tab
Hi,
I’m trying to make a query that need
to search throught a table and have to search different terms, and SUM their
Rank (is for a small search engine I have to design), this is the table:
Table Indexes
ID – bigint
ID_Termino -bigint
Rank – double
Table Terminos
ID_Termino – bigint
o be printed again...
Any ideas?
From: sol beach <[EMAIL PROTECTED]>
Reply-To: sol beach <[EMAIL PROTECTED]>
To: Xristos Karvouneas <[EMAIL PROTECTED]>
Subject: Re: Query Problem
Date: Tue, 15 Mar 2005 12:33:24 -0800
http://www.catb.org/~esr/faqs/smart-questions.html
It would
get it in the format specified in the message, i.e.
if
> the title is the same, I do not want it to be printed again...
>
> Any ideas?
>
> >From: gerald_clark <[EMAIL PROTECTED]>
> >To: Xristos Karvouneas <[EMAIL PROTECTED]>
> >CC: mysql@lists.mysql.
message, i.e. if
the title is the same, I do not want it to be printed again...
Any ideas?
From: gerald_clark <[EMAIL PROTECTED]>
To: Xristos Karvouneas <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: Query Problem
Date: Tue, 15 Mar 2005 14:49:45 -0600
Xristos Karvouneas
message, i.e. if
the title is the same, I do not want it to be printed again...
Any ideas?
From: sol beach <[EMAIL PROTECTED]>
Reply-To: sol beach <[EMAIL PROTECTED]>
To: Xristos Karvouneas <[EMAIL PROTECTED]>
Subject: Re: Query Problem
Date: Tue, 15 Mar 2005 12:33:24 -0800
h
Xristos Karvouneas wrote:
Dear All,
I am faced with the following problem: I have got three tables -
book,author and authorbook - containing information about books and
authors (some books have multiple authors). I want to do a query that
would print information like:
Title 1 Author 1
Dear All,
I am faced with the following problem: I have got three tables - book,author
and authorbook - containing information about books and authors (some books
have multiple authors). I want to do a query that would print information
like:
Title 1 Author 1
Author 2
Title 2
"Nick Zukin" <[EMAIL PROTECTED]> wrote on 03/14/2005 05:22:38 PM:
> I'm trying to do a multitable query and am having problems.
>
> I have three tables: vendors, products, and vendorproducts. The
> vendorproducts table creates a many to many relationship between the
vendors
> and the products. T
Thanks. That was it. I'm glad it was something so simple. Just needed a
careful set of eyes. I was worried my understanding of SQL/JOINs was
screwy.
Thanks again.
Nick
PS I'll read up on the FULLTEXT matching. I don't know it well.
>> $query = "SELECT v.vbusiness, v.vcategory, v.vurl, v.v
Nick Zukin wrote:
I'm trying to do a multitable query and am having problems.
I have three tables: vendors, products, and vendorproducts. The
vendorproducts table creates a many to many relationship between the vendors
and the products. There is nothing more than the vendor and product ids in
the
List
Asunto: Re: Multi-Table Query Problem...
On Mon, 14 Mar 2005 15:12:18 -0800, Scott Klarenbach wrote
> Because, with the '%keyword%' operator, you're going to match any of
> those columns that contain the keyword inside of it. This can be a
> little confusin
On Mon, 14 Mar 2005 15:12:18 -0800, Scott Klarenbach wrote
> Because, with the '%keyword%' operator, you're going to match any of
> those columns that contain the keyword inside of it. This can be a
> little confusing as 'ef' will return true on 'abcdefghijk'? Instead,
> you might try 'keyword%'
1 - 100 of 331 matches
Mail list logo
