99'
We are trying to find Former Clients who have not been seen after the date
range - Lapsed Client Report
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
ot;Exc","E","S”),
tr.Score DESC
WHEN tr.Placed != "X" THEN tr.ride_time ASC
END
How does one deal with CONDITION study like this?
Thanks in advance for any assistance
Don
ot;Exc","E","S”),
tr.Score DESC
WHEN tr.Placed != "X" THEN tr.ride_time ASC
END
How does one deal with CONDITION study like this?
Thanks in advance for any assistance
Don
te, "%M %Y") AS mo_label FROM
tl_items_classes ic
LEFT JOIN tl_items i ON ic.item_id = i.item_id
WHERE i.active = 1 AND ic.cl_cancelled IS NULL ORDER BY ic.cl_date ASC;
Any help would be appreciated.
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
= a.client_id
GROUP BY a.client_id
HAVING max(a.time_start) >= UNIX_TIMESTAMP(DATE_SUB( NOW(), INTERVAL 24 MONTH))
AND last_appt IS NOT NULL AND count(a.client_id) >= 2;
BUT, how do I add the other “condition b” to the query to get an accurate end
result.
I’d appreciate any help.
Don
(a.time_start) >= UNIX_TIMESTAMP(DATE_SUB( NOW(), INTERVAL 24 MONTH))
AND last_appt IS NOT NULL AND count(a.client_id) >= 2;
BUT, how do I add the other “condition b” to the query to get an accurate end
result.
I’d appreciate any help.
Don Wieland
D W D a t a C o n c e p t s
the SUM I need is on the JOIN relationship -
results should be:
1,Banana,3
2,Orange,5
3,Melon,6
Thanks!
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
invoice_InvoiceLines i ON p.pk_ProductID = i.fk_ProductID AND
i.fk_InvoiceID IN (1,2,3)
WHERE p.pk_ProductID IN (1,2,3)
GROUP BY i.fk_ProductID;
but it is not working.
Little help please. Thanks!
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
id = 730 AND ht.tr_date BETWEEN "2015-01-01 00:00:00" AND
"2015-12-31 23:59:59"
GROUP BY ht.`transaction_id`
ORDER BY ht.tr_date DESC, ht.rec_code ASC;
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
g one row of the “hiv_transactions” table when there are
multiple rows.
On the GROUP_CONCAT I am trying to get a comma delineated list of the child
rec_code with no duplicates
Appreciate any help. Hopefully a small mod ;-)
Don Wieland
D W D a t a
Hey gang,
I need a few hours of support from a LAMP developer to resolve a few issues via
TeamViewer or GoToMeeting. Anyone who is interested, has the skills, and can
offer this to me, please contact me PRIVATELY. Please include your support
hourly rate.
Thanks!
Don Wieland
d
eath ;oP
Thanks!
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
@'localhost' to database
'teal1dwd_teal'
Do I need to perform this query in a different place? Sigh…
Don
On Sep 19, 2014, at 8:03 AM, Reindl Harald wrote:
> "into outfile" is *not* a db-specific permission
>
> http://lmgtfy.com/?q=mysql+permissions+into
o resolve this issue asap.
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
rst_name
INTO OUTFILE '/tmp/1_2031305738.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"']
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
EIF NEW.content_asset_type_code = 'VIDEO' THEN
INSERT INTO videos (content_asset_id) VALUES (NEW.id);
END IF;
INSERT INTO content_asset_statistics (content_asset_id,
statistic_type_code, seq) SELECT NEW.id, statistic_type_code, seq from
content_asset_statistic_t
:= a + 1)
WHERE
document_category = category
ORDER BY
sort_id;
END
//
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
contact me, privately, if you can assist. I am located in California,
USA (PST). Thanks!
Don Wieland
d...@pointmade.net
http://www.pointmade.net
for the work they do on the site ;-)
If you are interested, please contact me PRIVATELY and include a few
examples of your work (websites,etc...). Thanks.
Don
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
how many emails my server can send per hour.
They recommended I find a 3rd party service provider with support PHP
API connections.
My budget is limited. Does anyone have any suggestions of companies
that might work for my scenario?
Any feedback is appreciated ;-)
Don
--
MySQL General
arlier with ANY user, those appts can be earlier
than the start of the date range.
If they have a count of ZERO appts prior to the earliest appt within
the date range, the are a NEW CLIENT else a FORMER CLIENT.
Any assistance would be appreciated. Thanks!
Don Wieland
--
MySQL Gene
4 ---
SELECT count(*) AS dr_all_ther_qty FROM tl_appt LEFT JOIN tl_rooms r
on r.room_id = tl_appt.room_id WHERE client_id = '254023' AND
r.location_id = '1' AND user_id = '506' AND appt_status_id = '3' AND
time_start > '1321903800'
--- end query 4 ---
Don Wieland
D W D a t a C o n c e p t s
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
ient_id = 161
AND user_id != 503 AND appt_status_id = '3' AND
FROM_UNIXTIME(time_start,'%Y-%m-%d') between '2012-01-01' and
'2012-05-20';
dr_not_ther_qty = 2
SELECT count(*) as dr_all_ther_qty FROM tl_appt WHERE client_id = 161
AND appt_st
e where the COUNT of appointments (in
the entire tl_appt table) LESS THAN the stime > 0
I am sure I need a multiple select query, but I am having a hard time
wrapping my head around it.
Thanks for any feedback.
Don
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
be exported or printed? Graphs would be nice, too.
I know I can build this from scratch, but would rather get a hold of
something already pre-built (open source or shareware) to save me a
bunch of coding time.
I appreciate any feedback you can offer!
Don
nsactions WHERE
transaction_id IN ((select group_concat(payment_id) from
tl_trans_pmt_items where inv_id = 1033911)) AND client_id != 251719
I do not get the same results. Am I missing something? Hopefully
something simple ;-)
Don
--
MySQL General Mailing List
For list archiv
d,
regardless of the combination I use, invalid relationships come back
as NULL - need to return 0 so I can use it in a math formula.
Probably simple - maybe ;-)
Don
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Raj Shekhar writes:
> One option here might be to use "mysql proxy" as a man-in-the-middle and
> filter out unwanted queries...
This seems more or less the same as what I'm doing now with php.
The same question applies there - what would you look for in your
filter?
--
MySQL General Mailing Li
Daevid Vincent writes:
> > > For the love of God and all that is holy,
> > > do NOT put the user/pass on the URL like that!!
> > What's so unholy (or even unwise) about it?
> Oh my goodness, where to begin...
> Well barring the fact that it'll be in the user's cache and browser
It won't b
Daevid Vincent writes:
> For the love of God and all that is holy,
> do NOT put the user/pass on the URL like that!!
What's so unholy (or even unwise) about it?
> Or use "mod_auth_mysql" to maintain your 'authorized' users to your page.
Why is this so much better?
In my case it's worse ca
Adam Alkins writes:
> Sounds like you just want to GRANT access to specific tables (and with
> limited commands), which is exactly what MySQL's privilege system does.
How about this part?
> > Finally, suppose I want to limit access to the table to the rows
> > where col1=value1. If I just add
This seems like a topic that must have been studied, but I'm having
trouble figuring out what to search for in Google, since the usual
discussion of sql injection is not what I'm looking for here.
If anyone knows of references that discuss the issue, I'd like to
see them. I'm also interested in a
ction side, and then:
>
> mysql -h test_db_server -h user -pPASSWORD database < /tmp/db.sql
...
--
Don Readdon_r...@att.net
It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that
ELECT name FROM students [ORDERED BY ...]';
$res = mysql_query($qry);
for ($cnt=0; $cnt < 5000; $cnt++) {
$row = mysql_fetch_array($res);
$div1str .= '' .$row['name'];
}
while ($row = mysql_fetch_array($res))
$div2str .= '' .$row['name
uot;, "Extra-small", "'aqua:7FFFD4', 'blue:99'");
>
INSERT INTO products ...
..., ('aqua:7FFFD4', 'blue:99'));
http://dev.mysql.com/doc/refman/5.0/en/set.html
Regards,
--
Don Read
On Sat, 26 Dec 2009 10:43:55 +0800 Eva said:
> 2009-12-26 2:36, Don Read :
>
> >
> > Change noticed to enum('new', 'scan', 'done') not null default 'new';
> >
> > When proc two runs, it should
> > "UPDATE noticed=
sing old IPs.
>
> So how to resolve this problem?
> Thanks for my newbie questions.
> Merry Holidays!
>
> Eva.
Change noticed to enum('new', 'scan', 'done') not null default 'new';
When proc two runs, it should
"UPDATE noticed='sca
.
When the user logs in, it scans all the 'en' (english) tokens and stores
it in a PHP array('Day' => 'Day', 'Total' => 'Total' ...
Once you figure out the user's locale (either from a user table or
parsing the http headers) you re-sc
CT ... FROM MSSQL_table WHERE seen='GET';
INSERT INTO MySQL_table ...
UPDATE MSSQL_table SET seen='GOT' WHERE seen='GET';
lather, rinse, repeat.
--
Don Readdon_r...@att.net
It's always darkest before the dawn. So
ion is that the query runs faster the second time around but i dont
> > have ...
> >
>
> --
> A: It reverses the normal flow of conversation.
> Q: What's wrong with top-posting?
> A: Top-posting.
> Q: What's the biggest scourge on plain text ema
> the NULL handling syntax.
>
> If you are wondering who Codd is I can anticipate you that he invented the
> things we are talking about
> (http://en.wikipedia.org/wiki/Edgar_F._Codd)
>
>
> Cheers
>
> Claudio Nanni
And Claudio for the WIN!
--
Don Read
x27;top' still shows his processes (old and new) with a nice of 0.
Is there something else I'm missing?
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Friday, April 13, 2007 2:57 PM
To: Don O'Neil
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Mys
Nevermind on the "badly formatted number"... I specified the full path
/usr/bin/nice and it worked ok this time :-)
However, I still want to know if there is a way to specify a nice level for
an entire users processes.
Thanks!
-Original Message-----
From: Don O'Neil
er [mailto:[EMAIL PROTECTED]
Sent: Friday, April 13, 2007 11:38 AM
To: Don O'Neil
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Mysql Hogging all system resources
On Apr 12, 2007, at 1:17 PM, Don O'Neil wrote:
[ ... ]
> Is there a way to prioritize or set the amount of resources t
I have a customer that loaded up a HUGE table and was doing all sorts of
fancy stuff in it, and not waiting for the process to finish before sending
the same query, and eventually loading up the server to the point where the
only thing I could do was unplug it.
Is there a way to prioritize or set
This is using version: 5.0.18-log on linux.
I have a stored procedure that takes .2 sec the first time,
12 the second, 12 the third. The data is unchanged.
The relevant part of the procedure looks like this.
...
drop temporary table if exists temptab;
create temporary table temptab (index (
I just deleted and re-created my indexes and the query works now... I guess
the index got corrupted somehow. Strange that I never saw any indications of
this in messages, just that 0 rows were returned.
Don
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Thursday
Yes, there is a full text index, there are about 12,000 rows or so.
Don
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 19, 2006 11:47 PM
To: Don O'Neil
Cc: mysql@lists.mysql.com
Subject: Re: Problem with query on 5.11
Don O'Neil wrote:
Why does this query return no results:
SELECT * FROM FileList WHERE MATCH Filename AGAINST ("9640")
When there are entries in the Filename list that have 9640 in them?
I'm using MySQL 5.1.11.
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
es it work with '../../Customer_Data.csv'?
Axis
On 9/12/2006 10:22:01 PM, Don ([EMAIL PROTECTED]) wrote:
> Presuming your csv is set up in the structure of your table - this may
> help
>
>
>
> BULK INSERT tablename
>
> FROM 'C:\filelocation\my_d
he method we are using to bulk
insert into our tables. Works like a champ.
Don
-Original Message-
From: axis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 12, 2006 9:10 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: What's the best way to INSERT a long list of ema
properly
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-passw
7;$baz%'";
// then test, case by case, to see if you need more selection clauses:
if (! empty($area))
$qry = andclause($qry, 'area', $area);
if (! empty($interest))
$qry = andclause($qry, 'interest', $interest);
echo '', $qry, '
Hi all...
I have some OLD programs I don't have the source for that were built with
the MySQL 3.23.55 client libraries. They still work great, even when using
those libraries to connect to 4.1.18 Mysql (I have a copy of the old lib in
the new lib dir)
However, is there some way I can build a 3.
Yeah, I know about that... But the 4.1.18 client/server isn't there.. Only
4.0.7 or some such older version.
Thanks!
-Original Message-
From: Julian C. Dunn [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 23, 2006 9:39 AM
To: Don O'Neil
Cc: mysql@lists.mysql.com
Subject:
Where are the client libraries and such for the FreeBSD 4.x Build of MySQL
4.1.18? I downloaded the MAX binary yesterday, and tried to install it, but
none of the libmysqlclient files are present in the distribution.
Do I need to download the sources and build it, or are the client files
located
don't seem to be any symbols in
the executable:
# nm -n /usr/sbin/mysqld
nm: /usr/sbin/mysqld: no symbols
Nor is there a file anywhere on the system named mysqld.sym.gz.
--
Don Doumakes
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I'm installing MySQL 4.1.14 on a new Gentoo box. When I try to connect
to the mysqld daemon, it crashes and restarts itself, which just doesn't
seem right. I enter these commands:
cd /usr; /usr/bin/mysqld_safe &
mysqladmin -u root password 'foobar'
and get this response:
mysqladmin: connect
.
A link to a previous thread or documentation on this would be fine. I don't
mind doing the reading - but my Google search seems to turn up more info
about multi-table deletes than inserts. I realize that MySQL doesn't
support a single multi-table insert function, but are the two appr
Maybe a good question to ask is where can I find documentation on:
MySQL WHERE where_definition
Specifically, all the options available for the 'where_definition'
-Original Message-----
From: Don [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 08, 2005 3:40 PM
To: mysql@lists
d, it will find all
instances of BOOKING with a '12345' in it.
Hence, partial matches
Thanks,
Don
-Original Message-
From: Gordon Bruce [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 08, 2005 3:31 PM
To: Don; mysql@lists.mysql.com
Subject: RE: Are partial searches possible?
fine if I have an exact entry but fails for a partial entry. For
example. If I have an entry where "Booking" is 'TSIN15' and I search on
the string 'TSIN15', it is found.
How can I get it to find a partial match if the string I enter is only
'15000
x27;t been
documented? Am I missing something obvious? I have a lot of tables I
expected to behave the same way as they did in prior releases...
Don
smime.p7s
Description: S/MIME Cryptographic Signature
umented? Am I missing something obvious? I have a lot of tables I
expected to behave the same way as they did in prior releases...
Don
smime.p7s
Description: S/MIME Cryptographic Signature
34
050423 12:07:20 [ERROR] Fatal error: Can't open privilege tables: Table
'mysql.host' doesn't exist
050423 12:07:20 mysqld ended
--
Don
Vaillancourt
Director of Software Development
WEB
IMPACT INC.
phone: 416-815-20
by creating a new select
statement and running it.
It seems this is not possible if the framework tries to use a single
global connection to the daemon, yes? no?
Can another connection be made?
thanks,
Don.
---
[EMAIL PROTECTED] wrote:
The parent-child type of query you want to make is
y may show up
somewhere I don't want them?
Is there a way to do this, does it work and I am missing something?
Thanks,
Don.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Eric Bergen wrote:
If you can use mysqldump to export the data from 3.23 with the -Q
switch to quote all db, table, and column names.
Thanks for the input, that has worked for me in the past, but it's on a hosted db server and I don't think I have rights to run mysqldump on it. I was hoping to av
Don Stefani wrote:
Hello,
I am trying to import a table structure from ver 3.23.52 to ver
4.1.7-max and I am getting an error:
--- error -
|#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
Hello,
I am trying to import a table structure from ver 3.23.52 to ver
4.1.7-max and I am getting an error:
--- error -
|#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'wish_list_id` i
GH wrote:
I am using IIS :(
On Windows... Which do i install first? PHP or MySQL?
Apache. :)
If your just working on a local dev box, it may not be that big of a deal.
PHP using IIS is a bit easier to install than Apache since PHP5 does not
have an installer that auto-configs Apache,
dbconn->Execute($qry);
while($row = $r->FetchRow())
$rank[$row['user_id']] = $row['rank'];
$dbconn->Execute('UPDATE user SET rank=0');
foreach($rank as $id => $r) {
$qry = "UPDATE user SET
t; mysqladmin -u root flush-privileges password "newpwd"
I get the error:
mysqladmin: unable to change password; error: 'Can't find any matching row
in the user table'
I think my user table is screwed up but how can I get in to fix it???
Worst case, do I just uninst
tatic timing as per the instructions
that came with it, and i can't get the test light to come on at all which says
something, I think.
Any help appreciated.
Thanks,
Don
noDB backup.
Anyone else seen this? Any ideas?
Thanks,
Don
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ing similar but with MEDIUMINT.
hittime DATETIME NOT NULL DEFAULT '-00-00',
prd MEDIUMINT UNSIGNED NOT NULL DEFAULT 0,
...
KEY idx_p (prd),
...
UPDATE tbl SET prd=EXTRACT(YEAR_MONTH FROM hittime) ...
Then query it with
SELECT ... WHERE prd=200408 etc.
--
Don Read
x, they go away.
These are the stock compiled .tar.gz distributions.
My service seems to still run fine, and it's not reporting not being
able to connect. Multiple hosts get the error, not just one IP.
Any ideas?
Thanks,
Don
--
MySQL General Mailing List
For list archives: http://lists.mysq
How do I turn on the General log file in version 3.23.52? Can I put an entry in the
my.cnf file and reboot?
Thanks,
Don
my.cnf and it has no reference to a port so I'm
figuring it's using the default 3306.
I can ping the server.
Any ideas?
Thanks,
Don
x27;ve actually specified
> a display width, except just to see what effect it has on result
> display. :-)
>
The only time I've used it is in a billing app (w/ zerofill):
CREATE TABLE invoice (
id mediumint(6) unsigned zerofill NOT NULL auto_increment,
idcust med
ith joins etc, I don't find the "your
> error near .." very useful or am I giving up to easy?
Howzabout :
mysql_query($qry) or
die(sprintf('Borked query at file %s line %d :%s',
__FILE__, __LINE__, nl2br($qry)) .''
.mysql_errno() .'' .mysq
lowing query:
>
> SELECT SYS_IDX, LEFT(RIGHT(C,
> LENGTH(C)-LOCATE(';',C,LOCATE('name',C))),10) FROM A;
>
> This return's up to ten characters after the name, somethimes this is
> to
> much, sometimes to many. Does anybody knows how to go from here.
Is it possible to do something like this?
If(select * from xxx, "if record found"..update it, "if record not found" ..insert it)
Thanks,
Don
s the leader in supporting Access Control Lists...is that a
consideration for a MySQL server?
Thanks,
Don
Success with the bug entry. Nice system, too.
http://bugs.mysql.com/bug.php?id=3483
Thanks,
Don
Don MacAskill wrote:
This problem is completely repeatable, I'm not the only one having it,
and I've found a (temporary) workaround. I'm not sure if it affects
other machines tha
Thanks for the help! Worked perfectly.
Don
Paul DuBois <[EMAIL PROTECTED]> wrote:
At 10:01 -0700 4/16/04, Don Dachner wrote:
>Ok, that worked. Thanks.
>
>I guess now my only question is is there something wrong with my
>environment since I have to type:
>
>"./bin
ain, this is 4.0.18-max on AMD64. Only INSERTs ... UPDATE and DELETE
work fine, but INSERT hangs.
Thanks,
Don
Jaroslav Kocourek wrote:
FWIW, I'm still having this problem.
I've completely dropped the table and re-built it from the ground up.
It's a bizarre problem... The t
Ok, that worked. Thanks.
I guess now my only question is is there something wrong with my environment since I
have to type:
"./bin/mysql -u root"
instead of
"mysql -u root"?
Thanks,
Don
At 9:30 -0700 4/16/04, Don Dachner wrote:
>I ran ./bin/safe_mysqld &a
I ran ./bin/safe_mysqld &
and got:
[1] 3328
root # Starting mysqld daemon with databases from /usr/local/mysql/data
and the cursor hangs on the next line down ...
thanks,
don
Try ls to see whether safe_mysqld is in the directory and the run:
Safe_mysqld &
Note! You have to be
x27;m delete most if not all of those
files.
Don
+ rows, so it's pretty tiny.
A mysqldump of the table is only 442K.
Has no-one else seen anything like this? I can't imagine I'm the only one.
Thanks,
Don
Don MacAskill wrote:
Hi there,
I've got a bizarre problem I can't seem to solve. I have a small MyISAM
table
gt;
A. run both servers on the same time-zone.
B. load the data and run the query:
UPDATE tbl SET ts= DATE_SUB(ts, INTERVAL 10 HOUR) WHERE ...
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going t
This should be simple, no? I can't make it work
Objective:
- bring up a panel to ask for MySQL User/Host/Password and save settings if
we get logged in.
- when we start (likely on a new machine) create a new Weather DB if it
doesn't exist
- when we start ("" """) create a new TimeTable tabl
W, it only seems to hang on INSERT, not on UPDATE. I haven't tried
DELETE yet.
I'm stumped. Any help would be greatly appreciated!
Thanks,
Don
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 25-Mar-2004 [EMAIL PROTECTED] wrote:
> Not using perl or php I came up with:
>
> mysqlshow -u user --status db_name | awk -F"|" '{print $2,$5}' | grep
> -i pattern
>
> Is there a query to do the same thing?
>
>
SHOW TABLE STATUS
--
Don Rea
DESC, membershiptype DESC
-- or --
ELT(membershiptype + 1, '2', '0', '1') ASC
-- or --
MAKE_SET(membershiptype, 'a','b') DESC
Regards
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn
actually contains anything?
From: "Matt W" <[EMAIL PROTECTED]>
To: "Don Dikunetsis" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: Re: fulltext search always returns no results
Date: Thu, 26 Feb 2004 01:26:17 -0600
Hi Don,
No, full-text search was added
arches still
return blank results.
I must admit that at this point I'm stumped!
From: "Peter Lovatt" <[EMAIL PROTECTED]>
To: "Matt W" <[EMAIL PROTECTED]>, "Don Dikunetsis"
<[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: RE: fulltext se
Hi, thanks for your reply, but it looks like:
> As of Version 3.23.23, MySQL has support for full-text indexing and
searching.
--according to:
http://www.mysql.com/doc/en/Fulltext_Search.html
However, I would be unsurprised (though disappointed) to find that the
answer is some variant of "thi
Summary: When I run a fulltext search, it always returns no results. I have
added a fulltext index to the column being searched. Also, I am searching
for a term that is in the table, but not in more than 50% of the rows.
I notice that when I add EXPLAIN to my search, the key_len of my fulltext
1 - 100 of 456 matches
Mail list logo