ay, October 11, 2005 9:49 AM
Subject: Re: Help on writing a sql statement
> (my response bottom-posted. See below - SG)
> > - Original Message -
> > From: <[EMAIL PROTECTED]>
> > To: "Imran" <[EMAIL PROTECTED]>
> > Cc:
> > Sent: Mond
eport` int(10) default NULL,
> PRIMARY KEY (`ID`),
> KEY `ProdNo` (`ProdNo`),
> KEY `Branch` (`Branch`)
> )
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "Imran" <[EMAIL PROTECTED]>
> Cc:
> Sent: Monday, October 10, 2005 4
l Message -
From: <[EMAIL PROTECTED]>
To: "Imran" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, October 10, 2005 4:17 PM
Subject: Re: Help on writing a sql statement
> "Imran" <[EMAIL PROTECTED]> wrote on 10/10/2005 03:52:21 PM:
>
> > Hi all:
> > I
"Imran" <[EMAIL PROTECTED]> wrote on 10/10/2005 03:52:21 PM:
> Hi all:
> I need some help in writing a sql statement.
>
> I have three tables (Sales, Cust and Product). The sales table contains
a
> large volume of data and I want to create a sql to group the sales table
> then join the resultant
On 04/10/2005, Jasper Bryant-Greene wrote:
> Kishore Jalleda wrote:
> > Could you kindly advice if this query can be made to run faster
> > SELECT title, template
> > FROM template
> > WHERE templateid IN
> > (608,2072,2073,1888,1898,1895,1897,1894,1896,1901,1903,1889,1900,189
> > 0,1891,1902,1904
Kishore Jalleda wrote:
Could you kindly advice if this query can be made to run faster
SELECT title, template
FROM template
WHERE templateid IN
(608,2072,2073,1888,1898,1895,1897,1894,1896,1901,1903,1889,1900,1890,1891,1902,1904,2104,624,625,2152,2212,1985,1996,614,1964,2103,2106,2113,1982,1983
[EMAIL PROTECTED] wrote:
Mike Blezien <[EMAIL PROTECTED]> wrote on 10/04/2005 10:08:24 AM:
Hello,
[EMAIL PROTECTED] wrote:
Mike Blezien <[EMAIL PROTECTED]> wrote on 10/04/2005 08:34:56
AM:
Hello,
I am trying to put together a single query from across 4 tables and
not having a
pro
Mike Blezien <[EMAIL PROTECTED]> wrote on 10/04/2005 10:08:24 AM:
> Hello,
>
>
> [EMAIL PROTECTED] wrote:
> > Mike Blezien <[EMAIL PROTECTED]> wrote on 10/04/2005 08:34:56
AM:
> >
> >
> >>Hello,
> >>
> >>I am trying to put together a single query from across 4 tables and
> >>not having a
>
Hello,
[EMAIL PROTECTED] wrote:
Mike Blezien <[EMAIL PROTECTED]> wrote on 10/04/2005 08:34:56 AM:
Hello,
I am trying to put together a single query from across 4 tables and
not having a
problem getting the results needed. table structure:
#
Mike Blezien <[EMAIL PROTECTED]> wrote on 10/04/2005 08:34:56 AM:
> Hello,
>
> I am trying to put together a single query from across 4 tables and
> not having a
> problem getting the results needed. table structure:
> ##
> CREATE TABLE IF NOT
I meant 600k not 6meg. Sorry
>>> "Ed Reed" <[EMAIL PROTECTED]> 9/30/05 9:46:32 AM >>>
That's not true.
Group_Concat can already return more than 6meg. It's set by
group_concat_max_len variable. The fact is that I've been told there are
security issues corrected in the 4.1.14a update and I can'
That's not true.
Group_Concat can already return more than 6meg. It's set by
group_concat_max_len variable. The fact is that I've been told there are
security issues corrected in the 4.1.14a update and I can't apply them because
it will break my already existing apps.
Is there a fix?
- Th
In the last episode (Sep 27), Ed Reed said:
> Will someone please respond to this?
>
> >>> "Ed Reed" <[EMAIL PROTECTED]> 9/22/05 1:30 PM >>>
> Bump!
>
> >>> "Ed Reed" < [EMAIL PROTECTED] > 9/21/05 2:09:58 PM >>>
>
> I just upgraded from 4.1.11 to 4.1.14a and now Group_Concat returns
> garbage. In
Will someone please respond to this?
- Ed
>>> "Ed Reed" <[EMAIL PROTECTED]> 9/22/05 1:30 PM >>>
Bump!
>>> "Ed Reed" < [EMAIL PROTECTED] > 9/21/05 2:09:58 PM >>>
I just upgraded from 4.1.11 to 4.1.14a and now Group_Concat returns garbage. In
the previous version Group_Concat returned a text str
Bump!
>>> "Ed Reed" <[EMAIL PROTECTED]> 9/21/05 2:09:58 PM >>>
I just upgraded from 4.1.11 to 4.1.14a and now Group_Concat returns garbage. In
the previous version Group_Concat returned a text string and after the upgrade
they are returning a blob.
Hello.
>..e, but I am manually entering it in.
Use mysql command line client. You may pass SQL statements as the
command line options or execute them from the file (i.e mysql -e
"sql_statement" or mysql < sql_file). See:
http://dev.mysql.com/doc/mysql/en/mysql.html
Eric Mynes
100 search items is a lot to search on at once for any system. MySQL
has to search on a 100 terms, no way around that.
I think the only way to optimize your query is to narrow down the
search terms. Perhaps you can search on phrases instead of words?
After the first 5-10 terms have been matc
I know it's bad form to reply to yourself but I just found a major mental
mistake in my response. See embedded:
[EMAIL PROTECTED] wrote on 08/12/2005 12:18:21 AM:
> Sebastian <[EMAIL PROTECTED]> wrote on 08/11/2005 01:19:30
PM:
>
> > well i managed to solve the problem myself, and im no sql ge
Sebastian <[EMAIL PROTECTED]> wrote on 08/11/2005 01:19:30 PM:
> well i managed to solve the problem myself, and im no sql genius...
> i thought i had an index on maps_rating.map which i didn't.. adding an
> index on it improved the query.
>
> i think that is about all the improvement i can get.
Hello.
> i thought i had an index on maps_rating.map which i didn't.. adding an
> index on it improved the query.
Have a look here:
http://dev.mysql.com/doc/mysql/en/order-by-optimization.html
http://dev.mysql.com/doc/mysql/en/group-by-optimization.html
Sebastian <[EMAIL
Sebastian wrote:
well i managed to solve the problem myself, and im no sql genius...
i thought i had an index on maps_rating.map which i didn't.. adding an
index on it improved the query.
i think that is about all the improvement i can get.. but if there is
still room for more speed i'd like
well i managed to solve the problem myself, and im no sql genius...
i thought i had an index on maps_rating.map which i didn't.. adding an
index on it improved the query.
i think that is about all the improvement i can get.. but if there is
still room for more speed i'd like to know..
Sebast
Jigal van Hemert wrote:
Sebastian wrote:
this query runs slow because AVG and COUNT on maps_rating table i think.
can anything be done to improve?
You may want to include:
- table definitions (output of SHOW CREATE TABLE )
- output of EXPLAIN
sorry for the lack of info.
there are a coupl
om: Scott Noyes [mailto:[EMAIL PROTECTED]
Sent: 11 August 2005 15:39
To: Ben Smith
Cc: mysql@lists.mysql.com
Subject: Re: HELP! sql command question for mysql
> It appears that you don't need to
> specify in the Group By clause all the columns that are referenced
> without an agg
Scott Noyes wrote:
It appears that you don't need to
specify in the Group By clause all the columns that are referenced without
an aggregate function
True.
For example this query would be invalid in MSSQL but
valid in MySQL:
select id, vendor, sum(price)
from p
group by id
In this cas
> It appears that you don't need to
> specify in the Group By clause all the columns that are referenced without
> an aggregate function
True.
> For example this query would be invalid in MSSQL but
> valid in MySQL:
>
> select id, vendor, sum(price)
> from p
> group by id
In this case, `vendor
id, vendor
Each query giving a different result.
Regards
Ben.
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: 10 August 2005 23:29
To: mysql@lists.mysql.com
Subject: Re: HELP! sql command question for mysql
Hello.
I'm not sure about the speed of this quer
Hello.
I've created tables similar to your and the query runs fast enough
on my test data (maybe I have good indexes). Please, provide the
EXPLAIN output for your query and exact definitions of your tables
(use SHOW CREATE TABLE).
Sebastian <[EMAIL PROTECTED]> wrote:
> this query runs
Hello.
I'm not sure about the speed of this query, but it seems to work:
mysql> source g.sql
+---+---++
| id| price | vendor |
+---+---++
| OG012 |20 | b |
| OG013 |40 | c |
+---+---++
[EMAIL PROTECTED] mysql-deb
surely stand a better chance of reply if you provide
information on the above set of questions.
Cheers
Manoj
- Original Message -
From: "Sebastian" <[EMAIL PROTECTED]>
To:
Sent: Thursday, August 11, 2005 3:52 PM
Subject: Re: help with slow query
> no one has any in
Sebastian wrote:
this query runs slow because AVG and COUNT on maps_rating table i think.
can anything be done to improve?
You may want to include:
- table definitions (output of SHOW CREATE TABLE )
- output of EXPLAIN
This way the list members can make better suggestions.
Regards, Jigal.
-
no one has any info to help me out?
all i need to know if there is a way to speed up the query or will i
have to live with it.
this query runs slow because AVG and COUNT on maps_rating table i think.
can anything be done to improve?
query:
SELECT
maps.*, AVG(maps_rating.rating) AS rating, CO
Hello.
Do you have a shell account? What engines do you use for your tables?
In your previous post you said you had tried to repair database (did you
want to say table?) while it was in use. What way had you chosen for
repairing? If myisamchk - that wasn't good idea on running server.
If al
Hi Gleb,
This is what I have using SHOW PROCESSLIST:
Waiting for tableSHOW TABLE STATUS FROM `db_mambo` LIKE 'mos_TFS_visits'
Help me pls, is there any way I can save this database? Looks like the
troubled table is mos_TFS_visits.
Thanks,
Fakar
On Monday 08 August 2005 03:59 pm, Gleb
Hello.
Use SHOW PROCESSLIST to see what's going on in your database.
Fajar Priyanto <[EMAIL PROTECTED]> wrote:
> Hi all,
> I'm hosting my web on a provider with MySQL 4.0.25-standard.
>
> I've got this situation when I open my database using phpMyadmin, one of my
> table has status
"Scott Purcell" <[EMAIL PROTECTED]> wrote on 07/29/2005 04:44:10 PM:
> Hello,
>
> I have created a table for items. And I needed some of the columns
> to be searchable, so I created the table as:
> a MyISAM for full text search.
>
> CREATE TABLE `item` (
> `parent_id` int(11) NOT NULL default
Gregory Machin <[EMAIL PROTECTED]> wrote on 07/29/2005 08:00:07 AM:
> Hi
> Please could advise me.
>
> I need search all the tables in a database for a single string. I'm
> trying to figure out how, where and what other tables exponent cms
> saves it text pages and references to, so i can finish
On Fri, 2005-07-29 at 14:00 +0200, Gregory Machin wrote:
> I need search all the tables in a database for a single string. I'm
> trying to figure out how, where and what other tables exponent cms
> saves it text pages and references to, so i can finish writing a mass
> page import module
>
> In
Hello.
This is a line from one of your files which were attached in archive:
>[EMAIL PROTECTED] Test_pgms]# gcc -c -I/usr/lib/bcc/include
^^
>-I/usr/include/mysql createdb.c
Are you using Borland C++ includes with gcc?!
Ash
Hello.
What engine do you use? 'SELECT COUNT(*) FROM TABLE_NAME' is
very optimized, however only for MyISAM tables. Have you thought about
a dedicated table for such a purposes, or adding auto_increment column to
the table?
Brian Dunning <[EMAIL PROTECTED]> wrote:
> I am cross-postin
Or even make .txt file with the cron and just include that txt file in
your php
Then in backgrond with perl(php) and cron you will udate that .txt file :-)
So it will be 1 quesry per 15 minutes :-)
Peter
[EMAIL PROTECTED] wrote:
Brian Dunning <[EMAIL PROTECTED]> wrote on 07/06/2005 04:43:11
Brian Dunning <[EMAIL PROTECTED]> wrote on 07/06/2005 04:43:11 PM:
> I am cross-posting this to the PHP and the MySQL lists because I'm
> not sure in which technology my solution will lie.
>
> I have a pretty busy PHP/MySQL site that executes the following query
> a lot:
>
> select count(*) as
Hello.
This is an output of diff user.c user.cpp. Which successfully compiles on
my FC3 system using the following command:
g++ user.cpp -I/usr/include/mysql -lmysqlclient
I've changed the extension to 'cpp', so g++ could work with this file.
Also #include was commented, and main now r
The same source that you compiled under VC++ may not work at all under
linux. Especially since the header files will be different. Make sure
you have the proper header files for linux installed. Also I did not
see any linking flags during compilation.
On 7/3/05, Ashok Kumar <[EMAIL PROTECTED]> wro
"Scott Purcell" <[EMAIL PROTECTED]> wrote on 07/01/2005 03:46:49 PM:
> Hello,
>
>
> MYSQL on PC v 4.0.15
>
> And I am trying to add an address table off of it. Using the
> users(id) as a primary key and deleting on cascade. So when the user
> is deleted from system, so are the addresses associ
Ashok Kumar wrote:
Dear Friends,
I'm Ashok here. first i'll tell my sys configuration.
1.Redhat-Linux 9
2.Intel Pentium chipset
3.MySQL 4.1 with Development Libraries
For this i've downloaded the MySQL4.1 under the
specification "Linux x86 RPM downloads" from the site.
In my system, the MySQ
Hi Prashanth,
I'm happy to help u. i attached one 'C' code in the
previous mail. just use that code for in vc++. Follow
the procedure,
1.Create the new "win32 Console App." as a empty
project and add the attached 'C' file to the project.
2.goto "Tools->options->Directories(tab)" and in that
add
Hello.
Very often similar error occurs when you didn't remove
service from previous MySQL installation. See:
http://dev.mysql.com/doc/mysql/en/windows-troubleshooting.html
Carlos J Souza <[EMAIL PROTECTED]> wrote:
> Dear Friends,
> =A0
> Iam trying to install MySQL 4.1.x in Windo
Hi Carlos,
My suggestion for this problem is, just uninstall the
MySQL Server and manually delete all the corresponding
files, restart the system once (not a must, but it's a
advisable), then u install the MySQL, hope now it'll
definitely work.
This is happening because of mis-configuration b/w
t
Carlos J Souza wrote:
The error as follows:
when installation is try to finish, the install try a start de new service "MYSQL
4" and does not success
I try the install and reinstall many times and nothing.
Regards
On Wed, 29 Jun 2005 08:39:51 -0400, JamesDR wrote:
Carlos J Souza wrote:
Carlos J Souza wrote:
Dear Friends,
Iam trying to install MySQL 4.1.x in Windows 2003
Server, and on error occurs when installation try a
start de service. The service does not start and
installation don't finish.
I Try install and reinstall many times and all fail
My WIndows is a 2003
First, remember when MySQL interacts with the filesystem it does so with
the privileges of the mysql user (or whatever user is running the
database). You'll have problems if that user doesn't have permissions in
that dir.
I'm not sure what OS GoDaddy runs, but if it's a flavor of Linux the
da
hi,
havant't you an automatic naming to ".htm" such as test.txt.htm rather than
test.txt ?
it's an upload problem. Can you access your file online ?
Mathias
Selon Brian Dunning <[EMAIL PROTECTED]>:
> I've got a GoDaddy virtual dedicated server and I'm trying to run a
> LOAD DATA INFILE, but I k
I just solved my own problem. For the benefit of others, I only
needed to set permissions to 755 for the directory containing my data
file. Works fine now.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
James M. Gonzalez wrote:
-Original Message-
From: Danny Stolle [mailto:[EMAIL PROTECTED]
Sent: 15 June 2005 21:09
To: James M. Gonzalez
Subject: Re: help joining tables in a query
James M. Gonzalez wrote:
Greetings,
I'm facing a difficult query at the moment. I have tried
No, I don't have Windows.
I need some one to load my tables, export to excel and email me the
excel docs.
On Jun 7, 2005, at 11:54 PM, [EMAIL PROTECTED] wrote:
if you want to use excel i suppose you have also windows with more
than 3 GO
free disk.
install win32 mysql
put the files in the
if you want to use excel i suppose you have also windows with more than 3 GO
free disk.
install win32 mysql
put the files in the data directory of one existing database
connect and use that database
export data to an outfile by :
select * from yourtable into outfile csv fields terminated by '
[EMAIL PROTECTED] wrote:
>>I pretty much have no idea how I can do this without nested queries (and
>>to be frank not even how to do it with them) so I'd really appreciate
>>any help!
>
>
>>kind regards Philip
>
>
> Try this as a starting point:
> I think you were having two mental problems
Unless you are keeping track of whether a widget in complete or not,
there is no hope but to scan the entire table to determine if a widget
is complete. That's something you don't want to do. You should mark a
widget as complete when it is completed. This would mean checking if a
particular wid
Philip Lawatsch wrote:
Hi,
I'm trying hard to figure out how to perform a special query in mysql 4.0.
I have one table "widgets" which has a column "widget-id" (int) and one
column "number_of_parts" (int).
And then I have another table "part_mapping" which has one column
"widget-id" (int) and
Philip Lawatsch <[EMAIL PROTECTED]> wrote on 06/06/2005 01:37:37 PM:
> Hi,
> I'm trying hard to figure out how to perform a special query in mysql
4.0.
> I have one table "widgets" which has a column "widget-id" (int) and one
> column "number_of_parts" (int).
> And then I have another table "p
Asha <> wrote:
> Is there a physical
> limitation in the InnoDb table structure as to why it can't
> support FullText indexes?
http://dev.mysql.com/doc/mysql/en/fulltext-restrictions.html
http://dev.mysql.com/doc/mysql/en/innodb-restrictions.html
Peter Normann
--
MySQL General Mailing List
with no comma (sorry):
select
sum(a.attendhours),
s.attendhours
from
attendance a,
attsum s
where
a.siteid = s.siteid and
a.assignmentid = s.assignmentid and
a.attenddate = s.attenddate and
a.siteid = 'XXX' and
a.attenddate >= '-XX-XX'
group by
a.assignmentid,
hi,
you can add
...
...
group by
a.assignmentid,
a.attenddate;
having sum(a.attendhours) != s.attendhours
Mathias
Selon Scott Pippin <[EMAIL PROTECTED]>:
> I have the following query.
>
> select
> sum(a.attendhours),
> s.attendhours
> from
> attendance a,
> attsum s
> where
> a.
Mathias,
To drop multiple IP, you can use distinct :
mysql> SELECT year, month, day, group_concat(distinct ip),count(*) AS
access
-> FROM access
-> WHERE year = 2005
-> AND month = 5
-> GROUP BY year, month,day
-> ORDER BY year, month, day;
+--+---+--+---
Hi Ronan,
I don't know if i understand your need, but your query gives something like that
:
mysql> SELECT year, month, day, ip, COUNT(*) AS access
-> FROM access
-> WHERE year = 2005
-> AND month = 5
-> GROUP BY year, month, day, ip
-> ORDER BY year, month, day;
+--
"Ronan Lucio" <[EMAIL PROTECTED]> wrote on 05/16/2005 04:21:17 PM:
> Mathias,
>
> > Hi,
> > look at group by ... with rollup at :
> > http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html
>
> Thank you very much for your help.
>
> My needs aren´t this, exactly.
>
> GROUP BY WITH ROLLUP, re
Mathias,
Hi,
look at group by ... with rollup at :
http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html
Thank you very much for your help.
My needs aren´t this, exactly.
GROUP BY WITH ROLLUP, returns me several lines of the
same day (one per IP), plus the total.
I need that every year-month-da
Hi,
look at group by ... with rollup at :
http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html
Mathias
Selon Ronan Lucio <[EMAIL PROTECTED]>:
> Hello,
>
> I have a table where is saved all site´s access:
>
> access
>
> id
> year
> month
> day
> weekday
> hour
> minute
> ip
>
> Any colu
Hi,
Have you done a $ ps aux | grep mysql and checked the daemon is running?
It sounds as if it hasn't started. If not, then you need to check the
mysql log. It is probably in /var/log/mysqld.log or somewhere similar.
You can look up the errors at
http://dev.mysql.com/doc/mysql/en/index.html This
Can one of these columns have binary data in it? If so that could
explain what the garbled text is. Although it should still
export/import correctly. My guess is that somewhere beteween > file
and < file file became corrupted. Try dumping it again. If possible
check that table to make sure it's ok.
I'm not sure if there is a built-in, but what I usually do
for similar things is to use general purpose table to force
iteration.
E.g. create a table called ITERATE with one column, x, and
populate with values 0,1,2,3,4,... -- in your case up to 10
-- and index the column.
Then it's easy - I only s
not null primary key)
-Original Message-
From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 13, 2005 7:33 PM
To: MySQL
Subject: Re: Help with a tricky/impossible query...
I should mention that I'm constrained to version 4.0.n so no sub queries for
me!
An
On Thu, 14 Apr 2005 11:57:50 +0100
"Andrew Braithwaite" <[EMAIL PROTECTED]> wrote:
> Thanks for the idea,
>
> Unfortunately I can't do that as the ranges involved are unknown and
> will be from 1 to several billion at lease. I can't have another table
> that needs to be augmented each time my ra
Thanks for the idea,
Unfortunately I can't do that as the ranges involved are unknown and
will be from 1 to several billion at lease. I can't have another table
that needs to be augmented each time my ranges change.
Any other ideas?
Cheers,
Andrew
-Original Message-
From: Paul B va
I should mention that I'm constrained to version 4.0.n so no sub queries for
me!
Andrew
On 14/4/05 1:11 am, "Andrew Braithwaite" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I need some help with a tricky query. Before anyone asks, I cannot bring
> this functionality back to the application layer (as
On Monday 11 April 2005 16:00, mysql helppp wrote:
> Error - Duplicate key '444642', -1
> (The syntax of the error message is not exact)
probably index error, run myisamchk on the table, or "repair table" inside
MySQL command line. Should fix without loose any data.
--rengolin
--
MySQL Genera
select l.b, r.a = l.b from tab l join tab r on l.a = r.b where l.a = 1 ;
seems to produce the result you want
"Gabriel B." <[EMAIL PROTECTED]>
29/03/2005 09:30
Please respond to
"Gabriel B." <[EMAIL PROTECTED]>
To
mysql@lists.mysql.com
cc
Subject
help with a mutuality check (good query e
- Original Message -
From: "Chris Kavanagh" <[EMAIL PROTECTED]>
To:
Sent: Saturday, March 26, 2005 9:41 PM
Subject: help-a-noob: WHERE statement not working
> Dear list,
>
> Happy Easter if anyone else is working. This statement is returning a
> syntax error when I insert the WHERE li
15 characters) and the same (even the spaces).Removing one
and
> the index on varchar was created. Any idea why?
>
> I will try to play with the indexes, if I understand well I'd better
index
> the three columns in once, because that will automatically index each of
> t
e columns in once, because that will automatically index each of
them?or am I wrong?
Anyway, thank you for all your advices, I'm really learning a lot of things
with that case!
Melanie
From: [EMAIL PROTECTED]
To: "mel list_php" <[EMAIL PROTECTED]>
CC: mysql@lists
Hi Mevers,
SELECT * FROM woorden WHERE LIKE % woord %
It's not going to be efficient (at all) but you can do:
SELECT * FROM woorden WHERE "foo" LIKE CONCAT('%', woord, '%')
Regards,
Jeremy
--
Jeremy Cole
Technical Yahoo - MySQL (Database) Geek
--
MySQL General Mailing List
For list archives: http:
"mel list_php" <[EMAIL PROTECTED]> wrote on 03/18/2005 10:35:30 AM:
> Hi again,
>
> Thanks for the explanation about the join and the group by.
>
> I wanted to test your query (almost a simple copy/paste :-)) ).
>
> The first 2 queries are ok, but the third one still is too long :
> mysql> CREA
Maybe you better do something like:
SELECT * FROM woorden WHERE % woord % LIKE
-Oorspronkelijk bericht-
Van: Mevershosting.nl [mailto:[EMAIL PROTECTED]
Verzonden: vrijdag 18 maart 2005 16:11
Aan: mysql@lists.mysql.com
Onderwerp: Help with LIKE
Dear list,
I need some help on this, I hav
n matches and the other tables is still too
heavy
Any idea?
From: [EMAIL PROTECTED]
To: "mel list_php" <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: help on query/group by
Date: Fri, 18 Mar 2005 09:14:02 -0500
Responses embedded below
"mel list_php"
"shaun thornburgh" <[EMAIL PROTECTED]> wrote on 03/17/2005
06:46:22 PM:
> Hi,
>
> I have ( among others ) three tables in my database: Claims, Expenses
and
> Mileage. A claim can contain many expense entries and many mileage
entries.
> I am using the follwing query to show the total expenses
Responses embedded below
"mel list_php" <[EMAIL PROTECTED]> wrote on 03/18/2005 05:57:29 AM:
> Hi Shawn,
>
> Thank you very much, I'm impressed by the time you took to answer me,
and
> the quality of the reply!!!
> I forwarded the answer to my friend.
> I'm wondering, I knew the mechanism of t
Hello shaun,
May be with subselects you can do what you want:
SELECT C.*,(select SUM(E.Amount) from Expenses E where E.Claim_ID =
C.Claim_ID)AS Amount, (select SUM(M.Mileage) from Mileage M where M.Claim_ID =
C.Claim_ID) AS Mileage
FROM Claims C
WHERE C.Claimant_ID = '1'
st> Hi,
st> I have
n thank you very much for your help, I will give temporary tables
an other chance!!!
Melanie
From: [EMAIL PROTECTED]
To: "mel list_php" <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: help on query/group by
Date: Wed, 16 Mar 2005 13:52:44 -0500
I have a favorite techn
I have a favorite technique for improving the results of queries , like
this, which involve fairly large JOINed tables. It's a form of
"divide-and-conquer" in that you pre-compute what you can then make the
JOINS you need to finish up the results.
I agree that the "AND s2.syn LIKE '%'" in the O
Scott Haneda <[EMAIL PROTECTED]> wrote on 03/09/2005 08:51:43 PM:
> Mysql 4, I have datetime field set of -00-00 00:00:00
>
> Sampling of data I need to insert in is as follow:
> 12/26/04 13:35
> 12/25/04 12:41
> 12/25/04 8:53
>
> How do a massage that to the proper format YYY-MM-DD HH:MM:SS
Michael Satterwhite wrote:
-
As it is, all I can suggest is to JOIN on all 90 tables - and hope MySQL
can handle the query - and that you can type all of them without error.
Note that if you use a UNION query as you suggest above, you will get
the last login FOR EACH DAY - not the overall last logi
In article <[EMAIL PROTECTED]>,
"J S" <[EMAIL PROTECTED]> writes:
> and I need to check the last date each user logged on to the proxy in
> the last 3 months.
> In my database, there is a table for the users:
mysql> desc user_table;
> +---+--+--+-+-+--
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
J S wrote:
|
|
|> J S wrote:
|> | Hi,
|> |
|> | I need a bit of help with a mySQL query. I have a list of users in a
|> | text file called 'users':
|> |
|> | u655354
|> | u687994
|> | u696974
|> | u728141
|> | ..
|> | ..
|> |
|> | and I need to check th
J S wrote:
| Hi,
|
| I need a bit of help with a mySQL query. I have a list of users in a
| text file called 'users':
|
| u655354
| u687994
| u696974
| u728141
| ..
| ..
|
| and I need to check the last date each user logged on to the proxy in
| the last 3 months.
|
| In my database, there is a ta
shaun thornburgh schrieb:
> Thanks for your reply, I would like the query to retun one
> instance of user 101 rather than 15!
SELECT DISTINCT ...
Regards,
A.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED
from the first table
From: "shaun thornburgh" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED], mysql@lists.mysql.com
Subject: Re: Help with a query please
Date: Mon, 21 Feb 2005 13:24:55 +
From: "Rhino" <[EMAIL PROTECTED]>
To: "shaun thornburgh"
<[
From: "Rhino" <[EMAIL PROTECTED]>
To: "shaun thornburgh"
<[EMAIL PROTECTED]>,
Subject: Re: Help with a query please
Date: Mon, 21 Feb 2005 08:22:29 -0500
- Original Message -
From: "shaun thornburgh" <[EMAIL PROTECTED]>
To:
Sent: Monday
- Original Message -
From: "shaun thornburgh" <[EMAIL PROTECTED]>
To:
Sent: Monday, February 21, 2005 7:28 AM
Subject: Help with a query please
> Hi,
>
> I am having trouble with the following query:
>
> SELECT U.User_ID,
> U.User_Firstname,
> U.User_Lastname
> FROM Users U, Allocation
Jack Lauman <[EMAIL PROTECTED]> wrote on 02/04/2005 11:57:37 AM:
> I want to run a nightly cron job where you iterate throught each row of
> a single table and reset a field depending on the conditions specified.
> In this case I want to take a date field (RenewalDate) and compare it
> to the
501 - 600 of 1666 matches
Mail list logo
