Have you thought about creating a fulltext index? Then you can search on
any word in a field. MySQL 4 has a lot more options for fulltext search,
but you can still do it in 3.
On Monday, December 16, 2002, at 04:25 PM, Chris Stark wrote:
SELECT my_id FROM my_table WHERE my_value LIKE
Hi,
I was just wondering if anyone has any tricks for speeding up huge queries
that require a LIKE comparison, and also a wild card at the front and back
of the search term. For example:
SELECT my_id FROM my_table WHERE my_value LIKE '%ABCDEFG%' LIMIT 50;
I know that in a query
7970948-3
- Original Message -
From: Chris Stark [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, December 16, 2002 10:25 PM
Subject: Large Like Queries
Hi,
I was just wondering if anyone has any tricks for speeding up huge queries
that require a LIKE comparison, and also a wild
Hi-
I am trying to write a sql query that will output (domain, transport,
sum(count), sum(size)) from multiple tables for many records.
When the domain field is dynamic based on the adminId passed to the query,
how do I execute the second query at the same time?
Thanks in advance,
Max
select
So I am trying to accomplish something like this:
select a.domain, a.transport, sum(c.recipient_count) sum(c.recipient_size)
from transport as a, acl as b, recipientstats as c where a.id=b.transportId
and b.adminId='1' and c.recipient_email like '%a.domain';
But I know I am missing something
Message-
From: news [mailto:[EMAIL PROTECTED]] On Behalf Of Max Clark
Sent: Thursday, December 12, 2002 5:30 PM
To: [EMAIL PROTECTED]
Subject: Re: newbie - linking queries with dynamic where conditions
So I am trying to accomplish something like this:
select a.domain, a.transport, sum
I've bene trying to find info on how efficient queries are for the SET
datatype, specifically, how does
MySQL use indexes for SET column types.
I have looked in the O'Reilly MySQL Reference Manual, and at mysql.com and
have found effectively nothing on this subject.
For example, if i have a table
Hi!
I have a problem with MySQL that hangs when concurrent queries run.
The symptom is this:
A) A Perl program that performs several queries using temporary tables takes 8 seconds
to run.
CPU utilisation around 30% (using the 'top' command)
B) Running two instances of the same perl program
Reestrup wrote:
Hi!
I have a problem with MySQL that hangs when concurrent queries run.
The symptom is this:
A) A Perl program that performs several queries using temporary tables takes 8
seconds to run.
CPU utilisation around 30% (using the 'top' command)
B) Running two instances
Hello,
I set up replication on my servers since the version 3.23.43. Recently I
upgrade all my servers to version 4.0.3.
The replication work fine for insert and delete queries (also alter table)
but doesn't take care of update queries.
When I make an update on an existant row in a table
On Friday 22 November 2002 17:19, RAHARD Matthieu wrote:
I set up replication on my servers since the version 3.23.43. Recently I
upgrade all my servers to version 4.0.3.
The replication work fine for insert and delete queries (also alter table)
but doesn't take care of update queries
I am a grad student attempting to complete an assignment to research a DBMS
engine. Is the SQL implemented by MySQL based on relational algebra or
relational calculus? And if it's relational calculus (which I suspect it is
based on an archive search), is it tuple or domain calculus?
Thank you
* raj
However, I wish to use this as a security tool. I.e. one in which I (as
the mysql admin) can do a grant like:
all queries on a specific table from user apache must only return
1 record
This would be like forcing a limit of 1 (using the technique below).
I don't think GRANT can
mysql,query
Hi List
I have a couple of slow queries listed in my slow log, but I don't know
what to do from here to make them fast.
Here is an EXPLAIN table:
mysql explain w3t_Users;
++--+--+-+-++
| Field | Type
To: [EMAIL PROTECTED]
Subject: slow queries
mysql,query
Hi List
I have a couple of slow queries listed in my slow log, but I don't know
what to do from here to make them fast.
Here is an EXPLAIN table:
mysql explain w3t_Users
Hi all,
is it possible to limit a result so that only the first record in a query
can be returned for a specific user?
I want to do this so that someone who does not have intimate knowledge of
a large (10 records) table cannot issue commands to grab *all* of the
data.
Thanks ahead of time
see if the limit keyword will do what you want.
select * from table limit 0, 2000
Hi all,
is it possible to limit a result so that only the first record in a query
can be returned for a specific user?
I want to do this so that someone who does not have intimate knowledge of
a large
Hi John,
thanks for the limit tip!
However, I wish to use this as a security tool. I.e. one in which I (as
the mysql admin) can do a grant like:
all queries on a specific table from user apache must only return
1 record
This would be like forcing a limit of 1 (using the technique below
I have two tables in a mysql db:
|+|
|games |3 |
|+|
|eat
that I can do both those queries in one go? Basically,
I want to provide PureFTP with one SQL query, that will either return the
account details on the user account ([EMAIL PROTECTED]), OR, for a
virtual web site ([EMAIL PROTECTED])
If I can write this quick of what I have in mind, I'm looking
I have a database with a table called targetTsObj, and I want to perform
many queries from it, such as this one:
select run,rerun,camcol,field,id,ra,decl,r from targetTsObj where ra
between 255.84730673785904 and 256.31969326214096 and decl between
58.7494108 and 58.9577892
Hi All;
Is there any way to get a real time queries per second in MySQL as opposed
to the average given when I request the server status?
Mike
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
At 14:00 -0600 9/18/02, Mike Hillyer wrote:
Hi All;
Is there any way to get a real time queries per second in MySQL as opposed
to the average given when I request the server status?
real time defined how, exactly?
Mike
In the last episode (Sep 18), Mike Hillyer said:
Hi All;
Is there any way to get a real time queries per second in MySQL as
opposed to the average given when I request the server status?
Request status twice, with a 1-second delay in between.
--
Dan Nelson
[EMAIL PROTECTED
From: Mike Hillyer
MH Is there any way to get a real time queries per second in MySQL as
MH opposed to the average given when I request the server status?
From: Dan Nelson
DN Request status twice, with a 1-second delay in between.
I think what Mike is looking for is an average across a time
On Wed, Sep 18, 2002 at 02:00:54PM -0600, Mike Hillyer wrote:
Hi All;
Is there any way to get a real time queries per second in MySQL as opposed
to the average given when I request the server status?
Use mytop:
http://jeremy.zawodny.com/mysql/mytop/
That's partly what I wrote it to do
I noticed in the changelog for mysql 4.0.2 that it now
Use index for ORDER BY in queries of type: SELECT * FROM t WHERE
key_part1=1 ORDER BY key_part1 DESC,key_part2 DESC
Very cool, I need this. Question though, when creating indexes, do we need
to somehow specify desc in the index or does
At 12:15 -0700 9/12/02, PR wrote:
I noticed in the changelog for mysql 4.0.2 that it now
Use index for ORDER BY in queries of type: SELECT * FROM t WHERE
key_part1=1 ORDER BY key_part1 DESC,key_part2 DESC
Very cool, I need this. Question though, when creating indexes, do we need
to somehow
table, so we could rotate the
table...) Or should we just keep letting it grow and maybe deal with it
down the road? After a a few hundred gigs, say
2. Does anyone have an already thought out set of SQL queries that will
generate useful data given a database full of log files? I know all those
mysql,query
Hello,
Maybe I'm an idiot, but I can't find any documentation on how to stop
running queries interactively. The only thing I can come up with is to stop
and restart the server. I don't want to do that. Basically, if a user does
something stupid, and sparks off a query
On Thu, 5 Sep 2002, James Kelty wrote:
mysql,query
Hello,
Maybe I'm an idiot, but I can't find any documentation on how to stop
running queries interactively. The only thing I can come up with is to stop
and restart the server. I don't want to do that. Basically, if a user does
something
Pada Thu, 5 Sep 2002 09:39:33 -0700
James Kelty [EMAIL PROTECTED] menulis :
mysql,query
Hello,
Maybe I'm an idiot, but I can't find any documentation on how to stop
running queries interactively. The only thing I can come up with is to stop
and restart the server. I don't want to do
Hi
I'm trying to see how many queries per second I have running in my MySQL server.
I understand that the number i see (Queries per second avg) is the average since the
time the MySQL Server came up.
The numbers i see below do not make much sense since the number stabilizes around
47 at any
Is there a way to combine these queries?
SELECT count(SeekID) FROM Seekers
WHERE DateLastLogNOW() AND DateLastLog(NOW()-INTERVAL 7 DAY)
SELECT count(SeekID) FROM Seekers
WHERE DateLastLogNOW() AND DateLastLog(NOW()-INTERVAL 1 MONTH)
Or these?
SELECT count(ResumeID) FROM Resumes WHERE
On Thu, 15 Aug 2002 10:37, you wrote:
Is there a way to combine these queries?
SELECT count(SeekID) FROM Seekers
WHERE DateLastLogNOW() AND DateLastLog(NOW()-INTERVAL 7 DAY)
SELECT count(SeekID) FROM Seekers
WHERE DateLastLogNOW() AND DateLastLog(NOW()-INTERVAL 1 MONTH)
SELECT
SUM
At 17:37 -0700 8/14/02, Richard Baskett wrote:
Is there a way to combine these queries?
SELECT count(SeekID) FROM Seekers
WHERE DateLastLogNOW() AND DateLastLog(NOW()-INTERVAL 7 DAY)
SELECT count(SeekID) FROM Seekers
WHERE DateLastLogNOW() AND DateLastLog(NOW()-INTERVAL 1 MONTH
Hi,
I m using MySQL 4.0.2 which now supports multi-table
update query
I am getting error while throwing multi-table UPDATE
query, I don't know what the problem is
To generate an error run below query, it will create a
2 InnoDB table and inserts a dummy record in it
CREATE TABLE
Hi,
I m using MySQL 4.0.2 which now supports multi-table
update query
I am getting error while throwing multi-table UPDATE
query, I don't know what the problem is
To generate an error run below query, it will create a
2 InnoDB table and inserts a dummy record in it
CREATE TABLE
[EMAIL PROTECTED]
Sent: Friday, July 26, 2002 2:21 PM
Subject: Re: Slow queries
At 05:53 PM 7/24/2002, you wrote:
Hello,
I am running mysql in our production environment, which have a few
reporting
tables with millions of rows. Certain queries cascade 2 such tables that
have millions of rows
Hello,
I am running mysql in our production environment, which have a few reporting
tables with millions of rows. Certain queries cascade 2 such tables that
have millions of rows and there by, there are extremely slow, sometimes
taking over 10 minutes.
However, we are ok with that since the size
Bhavin
I'm doing queries to one table with 4 other smaller tables.
The large table is 12-14 million records. With an index,
the table select is 13-15 seconds. With a compound index,
the delay is sub one second. Use explain to verify which
index is being used. Read the manual to tune your index's
, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
MySQL 3.23.51: up 48 days, processed 1,026,565,214 queries (245/sec. avg)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
I have an INNODB table which has 4 records in it. customer_number is the
primary key.
If I run
select count(cutomer_number) from customer;
It takes about 15 seconds to return the number of rows.
I ran explain on the query and it's using the unique key index on
customer_number.
If I run
| Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
MySQL 3.23.51: up 47 days, processed 1,019,366,418 queries (246/sec. avg)
-
Before posting, please check:
http://www.mysql.com
On Tuesday 16 July 2002 05:05 pm, Jeremy Zawodny wrote:
On Tue, Jul 16, 2002 at 03:52:35PM -0400, walt wrote:
I have an INNODB table which has 4 records in it. customer_number is
the primary key.
If I run
select count(cutomer_number) from customer;
It takes about 15 seconds to
Walt,
InnoDb physically counts all the rows in the table (unlike MyISAM
tables which stores the row count in a separate location). So in your case
it went through all 99,994 rows. The more rows you have in the table, the
longer it will take. I don't know how accurate Show table status
At 06:00 PM 7/16/2002, you wrote:
hello,
this issue is important for me too. i have a few silly questions
1. why innodb table type? what is its use? which one is default? (ISAM?)
Innodb Supports row locking and transactions which is very important when a
lot of users are updating the same
Hello All:
I believe that MySQL does not have the ability to directly
store procedures, but I need to develop a process for clients
to have an option to store queries that they have just made.
The most obvious solution (to me) would be to store the entire query
as a string
Tim:
From the DB side, it is pretty easy to do ... a table with 3 columns will
suffice:
CREATE TABLE queries (
q_id int(11) NOT NULL auto_increment,
q_name varchar(30) default NULL,
q_text text,
PRIMARY KEY (q_id)
);
Your app needs to be able to select/load
would like me to send binary.conf file, please let me know.
Keith C. Ivey wrote:
On 28 Jun 2002, at 14:27, Mark Hennessy wrote:
I have noticed after migrating my database from mSQL to MySQL that
queries are providing lookup results in a case-insensitive manner.
To avoid that, make your
Hi!
rhuddleston == rhuddleston [EMAIL PROTECTED] writes:
Description:
rhuddlestonThe following query results in a different # of rows if the
sql_big_tables is set to 1:
rhuddleston select count(incidents.ref_no) from incidents, labels where
incidents.ref_no like '020531%' group by
changes results when set for some queries
Severity:
Priority:
Category: mysql
Class:
Release: mysql-3.23.47 (Source distribution)
Environment:
System: Linux dbsc01.rightnowtech.com 2.4.17 #2 SMP Fri Jan 4 17:47:51 EST 2002 i686
unknown
Hello,
I have the following nested query that I would like to port to Mysql:
SELECT * FROM ad_catego
WHERE db_subcategory NOT IN
(SELECT rules.db_subcategory FROM rules
WHERE rules.db_login='$session_login')
AND db_category_int =2
PROTECTED]
Subject: Nested queries and joins
Hello,
I have the following nested query that I would like to port to Mysql:
SELECT * FROM ad_catego
WHERE db_subcategory NOT IN
(SELECT rules.db_subcategory FROM rules
WHERE rules.db_login
. juni 2002 18:15
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Nested queries and joins
SELECT ad_catego.* FROM ad_catego, db_subcategory
WHERE ad_catego.db_subcategory=rules.db_subcategory
AND rules.db_category != '2'
AND rules.db_login !='$session_login';
?
Peter Normann
-Original
Hello to all,
I'm new to mysql programming, I had recently switched from interbase6 to
mysql to test speed differences.
I have builded a simple test loading (under win2k server) the mysql library
(to achieve direct access).
Into this bench I have run many times 100 sequential queries to test
I have a database called TracerLock. Right now it is in some kind of state
where queries involving the user table will hang:
SELECT count(*) FROM user;
but queries involving any other table run fine:
mysql select count(*) from news_article;
+--+
| count(*) |
+--+
| 1335037
Is there any way to dynamically create columns non programatically? As in pure sql
queries?
This is what I am doing now:
SELECT SQL_BUFFER_RESULT
ORDERHEADER.ID_CUSTOMER AS 'Acct #',
CUSTOMER.Company AS 'Company',
SALESLEVEL.Name AS 'Client Type',
DATE_FORMAT(ORDERHEADER.AvailableAt, '%b
what the query does, I'll appreciate it allot. It may help
me understand the basic logic behind the structure of the query, and
aid me in the future when I may need to execute such queries again
(although, I'm honestly hoping that when such a time comes, MySQL
will support sub-queries).
Okay
Lo all,
are sub-queries supported on mysql-max 3.23.49 ??
If they are, what's wrong with the following statement?
SELECT monitorhosts.HostID
FROM monitorhosts
WHERE monitorhosts.HostID NOT IN
(SELECT HostID
FROM monitorhostgroupdetails
WHERE
I'm sorry to disappoint you, but subqueries are NOT supported int any MySQL
version, yet.
You can read the MySQL manual about it. You can find there when and how it
will be implemented.
Bye
Daniel
At 21:39 2002.06.06. +0200, you wrote:
Lo all,
are sub-queries supported on mysql-max
Dániel [EMAIL PROTECTED]
To: Chris Knipe [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, June 06, 2002 9:47 PM
Subject: Re: sub-queries
I'm sorry to disappoint you, but subqueries are NOT supported int any
MySQL
version, yet.
You can read the MySQL manual about it. You can find there when
SELECT monitorhosts.HostID
FROM monitorhosts, monitorhostgroupdetails
WHERE monitorhosts.HostID = monitorhostgroupdetails.HostID
AND monitorhostgroupdetails.HostGroupID != '1');
Gruss
Sabine
Chris Knipe wrote:
Lo all,
are sub-queries supported on mysql-max 3.23.49
-
From: Chris Knipe [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 2:52 PM
To: [EMAIL PROTECTED]
Subject: Re: sub-queries
Fair enough (and also what I thought)
Does anyone have any idea how I can implement the below in a similar
fashion then?
I have a list of items, and a list
Subject: Re: sub-queries
SELECT monitorhosts.HostID
FROM monitorhosts, monitorhostgroupdetails
WHERE monitorhosts.HostID = monitorhostgroupdetails.HostID
AND monitorhostgroupdetails.HostGroupID != '1');
Gruss
Sabine
Chris Knipe wrote:
Lo all,
are sub-queries supported on mysql-max
HostID 1 7, assigned to CompanyID 1.
monitorhostgroupdetails table data:
|51 | 1 | 1 |
Here, I can see HostID 1 belongs to HostGroup 1. The results on all the
various queries I tried and that's been suggested...
Select monitorhosts.HostID
from monitorhosts left join
:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 1:52 PM
To: [EMAIL PROTECTED]
Subject: Re: sub-queries
Ok, I spoke to soon... And this is starting to drive me up
the walls now...
i.e. getting REALLY irritating and frustrating.
mysql DESCRIBE monitorhosts
- Original Message -
From: Kevin Fries [EMAIL PROTECTED]
To: 'Chris Knipe' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, June 07, 2002 12:38 AM
Subject: RE: sub-queries
Chris,
sounds like you're looking for an exclusive left outer join.
You want to see records from
Hi.
On Fri 2002-06-07 at 01:55:18 +0200, [EMAIL PROTECTED] wrote:
[...]
Chris,
sounds like you're looking for an exclusive left outer join.
You want to see records from monitorhosts, where there is no corresponding
record
in monitorhostgroupdetails, right?
Yes - and no. If a
also have to admit... It was pointed out to me about two days ago that I
would need to execute this query with a LEFT JOIN. Coming from a MSSQL
background, and being used to simply using sub-queries, I did go and read
the section in the manual about LEFT / RIGHT JOIN statements. After reading
about
well yeah, but the people who are going to be using the databse don;t know
PHP and they want to edit the queries in Access, but still be able to access
it online, and if they change the queries in Acces, then it won't be changed
on the webpage (don't ask my why they want this, i'm just doing
another interface in PHP so
Your customers can easily edit queries without having
MS Access involved. One possibility is to have all queries
in an include file which can be easily maintained by using
a texteditor or via webinterface.
I haven't test PHP capabilities of #define stuff but
it should work
a
third query is also sent to the database to see if there are any other
projects in the gallery by the same artist- and then create a list of
related links.
So I have 3 database queries over two pages.
I'm wondering if there is a more efficient way of doing
You can create another frame that's invisible by having a zero height or
width. This can be your page that does all the queries and refreshes.
You can then use the javascript command document.write() to update the other
frames without having to hit the server again. Or, retrieve the data
Hey guys,
i'm still doing this web ODBC thing, and i was wondering since, all the
wqueries i'm going to use are in a database, is there a way (using
php/mysql/odbc) to access and call on those queries without typing them over
in my php script?
So basically i just want to connect to queries.mdb
Hi.
On Fri, May 31, 2002 at 01:26:34PM -0400, [EMAIL PROTECTED] wrote:
Hey guys,
i'm still doing this web ODBC thing, and i was wondering since, all the
wqueries i'm going to use are in a database, is there a way (using
php/mysql/odbc) to access and call on those queries without typing them
massive tables though, say 1 million rows each, so
would it be faster to execute two queries such as:
SELECT c.fkey_humanword FROM codewords AS c GROUP BY fkey_humanword
Then loop through each resulting fkey_humanword, store it in a variable
called '$varname', and have the second query be
SELECT w.word
Under normal operating conditions our v3.23.47 MySql db server handles about
60 queries per second using 50 threads or less. The host is a dual processor
700MHz Intel machine running the 2.2.14-5.0smp Linux kernel with 256M of
RAM.
Here's the problem: during spikes of activity where about 90-100
We run many queries for data for the previous day..
select foo from blah where date=(Current_Date)-1;
Since it was just the end of the month that ended up giving us a blank
result set. I looked through the manual but I didn't find an answer. (I
probably just looked over the right part)
Does
PROTECTED]]
Sent: Wednesday, May 01, 2002 4:05 PM
To: [EMAIL PROTECTED]
Subject: using currentdate in queries
We run many queries for data for the previous day..
select foo from blah where date=(Current_Date)-1;
Since it was just the end of the month that ended up giving us a blank
On 1 May 2002, at 13:04, Jeff O'Neal wrote:
select foo from blah where date=(Current_Date)-1;
Since it was just the end of the month that ended up giving us a blank
result set.
WHERE date = CURRENT_DATE - INTERVAL 1 DAY
see http://www.mysql.com/doc/D/a/Date_and_time_functions.html
I have a table full of cell phone data with three important columns:
ServiceNumber, ratingPeriod (1,2 or 3) and minutes. I want to run a
query grouped by serviceNumber that gives me the sum of minutes per
rating period for each of the numbers in the other cloumns. So the query
result will
At 14:24 -0500 4/27/02, [EMAIL PROTECTED] wrote:
I have a table full of cell phone data with three important columns:
ServiceNumber, ratingPeriod (1,2 or 3) and minutes. I want to run a
query grouped by serviceNumber that gives me the sum of minutes per
rating period for each of the numbers in
PROTECTED]
Sent: Wednesday, April 17, 2002 8:43 AM
Subject: dummy queries + csv dump
Hi,
I would like to know if it is possible to run a dummy qury on a table,
check for the number of possibly affected rows, and then, according to
specific conditions, execute the query for real.
The reason why I
sql,query
HI,
which one would be best for performance, many simple queries or one complex?
jari mäkelä
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Hi everyone,
I know that one can execute queries through files. can anyone please tell
me how to do that. I am working on sgi-irix and mysql 3.22.*.
also how can i view previous messages on mailing list since i just joined
the list yesterday.
SMIB,
Univ of nebraska
Q1: I am not sure what you mean by executing queries through files. Do you
mean being able to run a query from a script like this?
#!/bin/sh
mysql -t -p password -u usename databasename EOF
Select * From mytable;
EOF
Q2: There are mailing list archives available at http://lists.mysql.com
queries through files. can anyone please tell
me how to do that. I am working on sgi-irix and mysql 3.22.*.
also how can i view previous messages on mailing list since i just joined
the list yesterday.
SMIB,
Univ of nebraska
Hello all,
I'm in a mysql client session and I want to do multiple inserts
into a table (or run a multi-query script etc). This doesn't work
so what's the correct seperator / methodology?
INSERT INTO mytbl (a1) VALUES (12);
INSERT INTO mytbl (a1) VALUES (13);
INSERT INTO mytbl (a1) VALUES (14);
Hi
insert into mytbl (a1) values (12),(13),(14);
cheers
Mark
---
On Mon, 15 Apr 2002, Bill Adair wrote:
Hello all,
I'm in a mysql client session and I want to do multiple inserts
into a table (or run a multi-query script etc). This
hi. I'm using MySQL 3.23.38, default settings for the mysql variables(my-large.cnf),
linux 2.2.14-5.0smp kernel - Red Hat 6.2, Records 140750, Size 101.0 MB, mem 1G, CPU
PIII 800.
But for some reason queries take too many time.
During the long query, I did a mysqladmin proc to see what
On Tue, 9 Apr 2002 13:17:59 +0800
Alvin Chen [EMAIL PROTECTED] wrote:
hi. I'm using MySQL 3.23.38, default settings for the mysql variables(my-large.cnf),
linux 2.2.14-5.0smp kernel - Red Hat 6.2, Records 140750, Size 101.0 MB, mem 1G, CPU
PIII 800.
But for some reason queries take too many
I am quite new to coding and have managed so far but, i've been havin
trouble with queries.
Okay well here goes, it is quite simple but i can't figure it out, and
haven't found any helpfull documentation
I have a mysql database, and i want to sort a table by date Where the
resulting records
the dates.
--
sh
On Thu, 2002-03-28 at 10:15, David Rice wrote:
I am quite new to coding and have managed so far but, i've been havin
trouble with queries.
Okay well here goes, it is quite simple but i can't figure it out, and
haven't found any helpfull documentation
I have a mysql database
to coding and have managed so far but, i've been
havin
trouble with queries.
Okay well here goes, it is quite simple but i can't figure it out,
and
haven't found any helpfull documentation
I have a mysql database, and i want to sort a table by date Where
the
resulting records
- it has a quick intro/tutorial
chapter that covers this ground quite neatly!
Regards,
=dn
I am quite new to coding and have managed so far but, i've been
havin
trouble with queries.
Okay well here goes, it is quite simple but i can't figure it out,
and
haven't found any
Hey thanks i got it to work sort of
$query = SELECT * FROM gigs WHERE date '$today' ORDER BY date DESC LIMIT
3;
that works
but i want it to show them ascending and when i change it to
$query = SELECT * FROM gigs WHERE date '$today' ORDER BY date ASC; DESC
LIMIT 3;
it doesn't work
any
$query = SELECT * FROM gigs WHERE date '$today' ORDER BY date ASC LIMIT
3;
-Original Message-
From: David Rice [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 2:20 PM
To: [EMAIL PROTECTED]
Subject: Queries help (part II)
Hey thanks i got it to work sort of
$query = SELECT
If you only want it ascending, take out the DESC as in:
$query = SELECT * FROM gigs WHERE date '$today' ORDER BY date ASC LIMIT
3;
- Original Message -
From: David Rice [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 28, 2002 12:19 PM
Subject: Queries help (part II
Hi !
Is it possible to log mysql queries into a fifo created by :
# mkfifo -m660 queries.log
I've search with google but i found only one thread of one email where
somebody is getting an error 29. That's my case too.
Thanks a lot
901 - 1000 of 1256 matches
Mail list logo