Re: Formatting Date to make counts easy.

) and for that matter switch the date to us format. Here the sql statement I am doing now. select count(*), date from my_db group by date; select count(*), DATE_FORMAT(date, '%c/%d/%Y') from my_db group by date; -- - Scott Haneda

Min permissions to run `mysqladmin version`

I need to run `mysqladmin version` from a remote host, on the same LAN, what are the min permissions for a user I need to set up to get this data? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com

Select returning more than I want

', 'failed') 2 rows in set (0.02 sec) -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL

Re: Tips for better performance

. Maybe you are running the default my.cnf file, if so, you will want to change that to be optimized. Please report back your current cnf file. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com

SQL_CALC_FOUND_ROWS

| | +---++---+-+-+---+---+-- --+ -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: case insensitive search

. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: LIKE problem part II

the data, and looking at it in a editor to see if you can see what may be wrong. Also, reimport it back into a new test table and run your tests again. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com

Re: Mysql docs

on 11/16/05 7:06 PM, Jasper Bryant-Greene at [EMAIL PROTECTED] wrote: Scott Haneda wrote: Google this: subselect site:dev.mysql.com And I get mostly non English stuff, limiting to english and I get a whopping 37 pages, none of which seem to help me much. Try googling for subquery

Complex select across multiple tables

. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Aborting slipped keys

can I tell mysql to drop me back to a clean prompt? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http

Mysql docs

:-) -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: LOAD DATA IF?

' row would be inserted. Probably pretty simple to just delete them after youa re done. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General

Quick split() and data parse

id = xxx Is there some way I can do some string parsing on the text field and get to the 3rd item where the passed in shippign_method equals? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com

Re: Possible to use a conditional in this UPDATE

, I tried and it would error, the docs are a wee bit confusing in that regards. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing

Possible to use a conditional in this UPDATE

a bit. Thanks -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Possible to use a conditional in this UPDATE

on 10/27/05 6:34 PM, Scott Haneda at [EMAIL PROTECTED] wrote: Right now, my update works as follows, and works fine, however, I want to do a condition to say if products.ship_status = 1 then set cart_test.shipping_status to 'now' else set it to 'soon' UPDATE cart_test, products SET

Can conditions be mixed with DISTINCT()

these to enum() types as I go, but to change this one, would break too much stuff. I would like to toss in a condition to the select so it returns shipping_now for 1 and shipping_soon for 2. When I do this, I get zero results returned. -- - Scott

Re: database won't load after machine reboot

options, and reset it from there, then start it up normal: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato

Dropped a field, need fix emergency

that will pull the session_key from the backup table, and update the sesssions table with it, based in the field id=id. Can someone help me, I am pretty sure I know what to do, but don't want to risk messing it up. thanks -- - Scott Haneda

Re: Terrible MySQL Administrator

That lists the current cron jobs crontab the_cron_file_name Will reload the one you have changed. Of course, you could just send the alerts to nowwhere with something like /dev/null -- - Scott HanedaTel

Re: Problems setting up on Mac OS X

in afterwards as root. This may be a little out of date, but should still apply, and maybe help: http://www.newgeo.com/index.ws?id=17 -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com

Re: Problems setting up on Mac OS X

thingy, I never used it, just start it from the command line, or leave it running all the time, wont hurt a thing on a dev machine. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com

Myisam or innodb

the table structure of clients databases. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com

Recommendations on new hardware

, or do you all have better stuff to recommend? If I have left out anything, please let me know, I will be sure to reply. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato

Re: Recommendations on new hardware

. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Recommendations on new hardware

a xserve, one of the older ones, but still, not a bad piece of hardware at all. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List

Total newb at performance tuning mysql

, and if there are any questions that would help me get a better answer, please let me know. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing

Re: Recommendations on new hardware

. Sorry if this is boneheaded here, but are there non g4 bit variants you can run on a G5 if you just want the stability until this is worked out? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com

Re: Trouble with revoke all

, REPLICATION CLIENT ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '' WITH GRANT OPTION This looks pretty much full access to me? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com

Re: Trouble with revoke all

Queries per second avg: 1.738 -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Trouble with revoke all

ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '' WITH GRANT OPTION And that is the odd thing, running that gives me: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) -- - Scott Haneda

Re: Trouble with revoke all

PRIVILEGES (but I'm suspicious something like that is how this started). I never fiddle direct like that, but there was that fix_privs_table script mysql provided I had to run at one time during an update. -- - Scott Haneda

Trouble with revoke all

out how to make this work. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Cleaning out old users

? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Insert decimals with rounding

in set (0.00 sec) So it would be something like: INSERT into table SET foo = ROUND(1.5467, 3); -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL

Re: select based letter

on 7/14/05 3:54 PM, Sebastian at [EMAIL PROTECTED] wrote: i have a text field column and i want to select the rows based on the first letter in this column, eg: SELECT field from table WHERE field LIKE 'M%' -- - Scott Haneda

Mixing conditions with NOT BETWEEN

, however, it also finds records where the status is NOT 'active', which I don't want. Swapping the order of the condition seems to give me an error as well, so I am stumped. -- - Scott HanedaTel

Conditions in selects

-- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Datediff

I am using 4.0.18-standard So I do not have `DATEDIFF`, but I need to ability to do so, anyone know some other simple trick to get days between two dates? -- - Scott HanedaTel: 415.898.2602 http

Shifting dates

and months to wrap as needed. I would love to do this in SQL, not in application. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List

server and my client in different time zone

, but there are reports and other things that really need this taken into consideration, if there is a way to tell a certain single database to oprtate 3 hours ahead, I am pretty happy. -- - Scott HanedaTel

possible join

) | | | || +---+-+--+-+-++ -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: possible join

not screaming out at me, or maybe I have it right, and my data is in duplication, any help is appreciated. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL

The age old delete duplicates

with this, is seems a wee bit more efficient that the temp table deal for my case? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List

Re: The age old delete duplicates

on 5/5/05 2:11 AM, Joerg Bruehe at [EMAIL PROTECTED] wrote: Hi Scott, all! Scott Haneda wrote: I have been researching on how to deal with duplicate data. [[...]] I am not in a situation where I can test for duplicates on insert, so the on duplicate key update deal does me no good here

Re: The age old delete duplicates

on 5/5/05 2:52 AM, Jigal van Hemert at [EMAIL PROTECTED] wrote: - Original Message - From: Scott Haneda on 5/5/05 2:11 AM, Joerg Bruehe at [EMAIL PROTECTED] wrote: Basically, I have a chopping cart, this one is a little weird, for reasons not worth explaining, you have a cart when

stability of mysql error strings

I have a unique key on username and email address in mysql. In my application logic, I want to test for that response on failed insert. Error number 1062 tells me there is a duplicate key, but no way to tell what key that is. The error string returned is more telling, but seems less than ideal

Re: stability of mysql error strings

on 5/4/05 7:22 PM, Paul DuBois at [EMAIL PROTECTED] wrote: At 19:09 -0700 5/4/05, Scott Haneda wrote: I have a unique key on username and email address in mysql. In my application logic, I want to test for that response on failed insert. Error number 1062 tells me there is a duplicate key

Re: Slow queries, why?

, it may get you where you need to be. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com

returning results in the order they were selected

mysql 4.0.18-standard I am running this select: SELECT a, b, c, from table where zip IN (94949, 94945, 94947) How can I get back a result set in the order of the `IN` part of the statement? -- - Scott Haneda

Re: returning results in the order they were selected

. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

little string patch job

. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: zip code search within x miles

be useful, but they would have to be separate from each other and from zip_code. Anyone willing to put up a final tested and optimized sql query? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com

zip code search within x miles

How are sites doing the search by zip and coming up with results within x miles? Is there some OSS zip code download that has been created for this? -- - Scott HanedaTel: 415.898.2602 http

word count

Is there a simple wat to get a word count out of a field in mysql, or to at least split on and tell me how many items in that array. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com

base 64 and mysql

as a blog and have it return an image, in my case it will be a png? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list

bulk download via php

? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

remove trailing character

I managed to mess up and email storage addresses are in the format of [EMAIL PROTECTED] How I can strip off the , it does not exist on all, only some. thanks -- - Scott HanedaTel: 415.898.2602 http

Help massage date import

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 thanks -- - Scott

wikipedia down, slashdot covering, mysql mentioned

sometimes have to reboot, it comes back up fine, I do however, do nothing special to shut down mysql, should I be? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax

aborting slipped keys

-- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com

Mysql hypothetical performance

? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com

Ignore

Please ignore -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Ignore

Please ignore -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

OT, can someone send me headers from two email messages

problem with resin http://lists.mysql.com/mysql/176238 Could someone please email me off list the full source of those 2 emails? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax

Securing mysql from remote access

it to? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Securing mysql from remote access

://www.securityfocus.com/bid/10654/discussion/ http://www.securityfocus.com/bid/975/discussion/ For which I just started wondering. I can easily block it out in the router, but it made me curious as to what other options there are. -- - Scott Haneda

How do I export a set of data nightly

me to the correct way? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General

Re: Outputting Data

-- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Group by and results

Are these 2 statements the same? tSql1 = select distinct foo, bar, baz from table tSql2 = select foo, bar, baz from table group by foo, bar, baz Why would I get different results? -- - Scott HanedaTel

Re: Proper parens in OR searches

, it is a little like php, a little like BASIC, a little like C, my favorite, but not well known... Yet :-) -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL

Order by with one exception

. I can not just order by subject, id, since not a subject could start with a letter after R. Suggestions? Thanks -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax

Re: Order by with one exception

: to the top. I can not just order by subject, id, since not a subject could start with a letter after R. Suggestions? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax

Proper parens in OR searches

ASC LIMIT 60 -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List

Update on condition

I need to do a certain update based on a condition: MySql4 Update table set bounce_count = bounce_count+1 is the basic query, somewhere in there I need to only do a if bounce_count+1 10 then update status = 'bounced_out' -- - Scott

Count() within Join

(DISTINCT a.status='optin') gives me 2 for some reason. Suggestions? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED

Export and destroy relation

though there can be many registered_serials. The result would be something like: Firsttablasttabemailtabserial1,serial2,serial3 Is this possible? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com

Export and destroy relation

though there can be many registered_serials. The result would be something like: Firsttablasttabemailtabserial1,serial2,serial3 Is this possible? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com

Best options for unique string

suppose there is any way to un-MD5 something? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A

Cant get this JOIN to work

is not what I want. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing

Is this result set possible

to give me a result with a count as a int Campaign_name records_in addresses_incampaign foo 15 bar 12 example 0 (safe to delete) anohther2 -- - Scott Haneda

Re: Last insert id problem/bug

on 7/22/04 10:56 PM, Scott Haneda at [EMAIL PROTECTED] wrote: I am not sure this is just how it is, my issue, or a bug, I searched the bugs database, but don't really know what to call this in order to properly look up the info: MySQL 4.0.18-standard Also note, I just tested this on 4.0.20

Optimizing my scenario, suggestions needed

on (i.campaign_id = c.id) WHERE i.campaign_id = '1' AND a.user_id = '1' AND i.user_id = '1' Thanks -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED

Re: Last insert id problem/bug

in this case, of hundreds of thousands of imported records in batch, it just not feasible. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED

Re: Another newbie question - using OR in WHERE clauses

on 7/23/04 3:00 PM, Paul Fine at [EMAIL PROTECTED] wrote: SELECT * FROM tablename WHERE columname = 'Bob' OR columname = 'Mike' OR columname = 'Betty' This is perfectly accurate -- - Scott Haneda

Best field type for status codes

? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Multiple inserts in one statement

I was just reading a forum post on mysql, someone said it was possible in mysql 4 to insert data into more than one table at once. Is this possible, if so, where in the docs can I see a example of this? -- - Scott Haneda

Multiple inserts in one statement

I was just reading a forum post on mysql, someone said it was possible in mysql 4 to insert data into more than one table at once. Is this possible, if so, where in the docs can I see a example of this? -- - Scott Haneda

Transactions and mysql insert it

', id = tID , address = tID); end repeat; mysqlQuery(tConn, COMMIT); -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED

Re: Transactions and mysql insert it

? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Another: LOAD DATA INFILE error.

or not, but if the error_log is a plain normal error log from OS 9 it would be: FIELDS TERMINATED BY '\t' LINES TERMINATED by '\r' If the error log comes from OS X it would be: FIELDS TERMINATED BY '\t' LINES TERMINATED by '\n' -- - Scott

Last insert id problem/bug

and suggestions? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List

Re: Removing a specific set of duplicates

, thanks again. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing

Database design questions

new method are appreciated. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL

Removing a specific set of duplicates

), but if there are more than 2 dupes, I want to keep the one with the highest bounce count. Any idea how I should be approaching this? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax

Re: Removing a specific set of duplicates

situation? I think you nailed it, I was not aware of this feature, any links that tell me more? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED

Re: Removing a specific set of duplicates

:-) -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Removing a specific set of duplicates

:-) -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http

Re: Removing a specific set of duplicates

. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http

Allowing user orderable sorting

of elegant, looking for some suggestions. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL

<    1   2   3   4   >