d') = 2004;
return no rows. I can extract any piece of that date I want in a SELECT,
but can't seem to use it in a WHERE clause at all. There has to be
something really obvious that I'm missing?
Barry Newton
--
MySQL General Mailing List
For list archives: http://lists.mysql
At 02:05 PM 7/25/2006, Winn Johnston wrote:
after talking to a few people on the #mysql irc
someone suggested using NFS to create a ramfs to get
100GB+ RAM shared memory to load the entire database
into the RAM. Can anyone offer any Pros or Cons to
this setup, drawing from personal expierence?
t
At 06:35 PM 8/1/2006, Martin Jespersen wrote:
I just ran the following sql (on mysql 4.1.20):
update tbl set col1=col2, col2=col1
To my surprise, mysql updates col1 via col1=col2 before reading it for use
in col2=col1, so I end up with the same value in both columns, which, of
course, was n
Back with another registration db question:
Have a convention database which tracks people as they register all year
long; the actual convention is held in October. I've got a fairly simple
query which shows how many people registered in each calendar month--useful
to compare to prior year to
At 11:10 PM 8/2/2006, Peter Brawley wrote:
Barry
>It would make life easier if I could also show a column
>with the cumulative count for each month.
Set @cum - 0;
Select
Monthname(DatePaid) Month,
Year(DatePaid) Year,
Count(*) as Registrations,
Extract(Year_Month from DatePaid
At 04:15 PM 8/3/2006, Brent Baisley wrote:
You might look into WITH ROLLUP. That could easily give you cumulative
totals for the year, but off the top of my head I can't think of a way to
get it for the months.
- Original Message - From: "Barry Newton" <[EMAIL PRO
PROTECTED] + Registrations RegYearToDate, @cumpd2:=
@cumpd2+Paid RegIncomeYTD
From Montable2 ;
Barry Newton
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 10:20 PM 8/22/2006, Chris wrote:
You can't store them in memory.
http://dev.mysql.com/doc/refman/5.1/en/temporary-table-problems.html
Despite what the doc says, I posted a working script here a couple of weeks
ago which creates temporary tables with engine=Memory. Either my
specification
Hi. . .I'm trying to be lazy and write a query where I stuff a list of
names into a variable (@namelist), and then try to find items in column
lastname which appear anywhere in that list. It doesn't want to work,
and even regexp isn't working, though that's probably my fault. Any
suggestions?
OK, never mind. I finally found the 'locate' function. I knew it had
to be there somewhere!
--
Barry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Nik wrote:
I've posted below the output of STATUS and SHOW GLOBAL STATUS. Any
and all comments would be much appreciated as to how we can get
performance back on track.
Wow. . .200 logins? 511 open tables? 277+ million sort rows? On a
single PC host? And you're complaining about perform
Olaf Stein wrote:
I am still amazed by the fact that youtube "is worth" 1.5 billion and MySQL
AB barely 1 billion. Did they sell under price? Or does Google just have way
to much many to spend/waste?
Greetings from the just wondering...
Olaf
MySQL A.B., so far as I know, derives income from trai
Hmm. Speaking of Navicat, does anybody out there have an easy way to
scrub the control coding from scripts developed under Navicat? I expect
that they're there mostly for coloration on displays, but it's kind of
obnoxious when you want to do anything else with them.
--
Barry
--
MySQL Gene
g the subquery 2000 times for the 2000
records in your company file.
And will run 500,000 times when you go to production data. Somebody with
better math than I should try to project that.
His prep query runs once, and his update query runs once. Scales very nicely.
Barry Newton
--
MySQL Ge
ments are disturbed,
but you can now use the single old-style userid to connect with DBD4, and
keep your production users as secure as possible.
I've just done this on Win XP, and it works very nicely.
Barry Newton
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
that as long as you're willing to pay *something*, there's probably a
lot of room for negotiation. It's distinctly not in their interest
to eliminate collateral development efforts. And there are already
several products out there which do connect with MySQL and cost <
At 11:36 AM 4/23/2007, Drew Burchett wrote:
I have a mysql v 5.0 server running on Suse Linux 10.1. It has been
running steadily and properly for several months now. However, when I
came in this morning, my network card in the machine was bad. I
replaced the card and reconfigured the network,
I hope this isn't a silly question, or something covered in a FAQ. .
.but is there any reason to not have at least some primitive print
formatting commands in MySQL? Or am I missing something blindingly obvious?
Barry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
e MS Windows, it would be absolutely possible to
configure 3-5 high speed printers and knock out 100,000 bills per
hour from an Intel single CPU box. You really have no appreciation
of how much power you actually have at your disposal.
Barry Newton
--
MySQL General Mailing List
For list archive
I'd rather do it in a sql statement rather than using a scripting language.
I'm thinking you might be able to do one select, accumulating 5
siubstring counts (a,e,i,o,u) into 5 variables, and then sum the
counts? I'll leave the testing to you. . .:-)
Barry Newton
-
20 matches
Mail list logo
