How can I see the query from a remote session against my server

people that expect miracles in the next 5 minutes here! Bill

RE: How can I see the query from a remote session against my server

log working if possible as it sounds pretty useful, so thanks again. Bill -Original Message- From: Jerry Schwartz [mailto:je...@gii.co.jp] Sent: 09 June 2010 16:43 To: 'Anirudh Sundar'; mysql@lists.mysql.com Subject: RE: How can I see the query from a remote session against my server

Query Question

I am in need of some help for the following: Say I have a table with 1M rows. Users are being added constantly (not deleted) during the queries that I am about to explain. The pk is uid and appid. I need to run queries in increments of 100K rows until reaching the end without duplicating

Re: Finding not quite duplicates

alias_for_a.prod_num IS NULL ORDER BY b.prod_pub_prod_id; US Data Export wrote: -Original Message- From: Bill newton [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 18, 2008 6:49 PM To: Jerry Schwartz Cc: 'mysql' Subject: Re: Finding not quite duplicates I'm having a little trouble

Re: Finding not quite duplicates

IF(a.prod_num IS NOT NULL,IF(a.prod_discont = 0,a.prod_num,discontinued),) as prod_num FROM b LEFT JOIN a ON b.prod_pub_prod_id = a.prod_pub_prod_id ORDER BY b.prod_pub_prod_id; You can nest IF statements in mysql queries. Hope it helps, Bill Jerry Schwartz wrote: As usual, my head is twisted

Re: normalised designs: customer database

had to choose one of those, Id go with the dual foreign keys. #3 Thanks for the meaty question, Bill metastable wrote: Hello all, I have a question that's been bugging me for quite some time. Let's say we have a small business that has both private and corporate customers. We want to store

Re: MySQL Sort by Array

in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.8.2/1739 - Release Date: 10/22/2008 7:23 AM -- Bill Newton Network Merchants Inc. http://www.nmi.com (847) 352-4850 ext 141/ Tel (888) 829-3631/ Fax -- MySQL General Mailing List For list

Re: Why people don't use engine named BDB?

will be removed. * Note that, as of MySQL 5.1, BDB isn't supported any longer. http://dev.mysql.com/doc/refman/5.0/en/bdb-storage-engine.html But you're right that as a storgage engine, there have been very few questions related to it, on this mailing list anyway. -- Bill Newton Network

Re: Find two sets of records

Try using the sub query as a derived table ala: SELECT eo_name_table.eo_name, eo_name_table.eo_pub_date FROM eo_name_table LEFT JOIN (SELECT prod.prod_title FROM prod WHERE prod.prod_discont = 0) fake_prod on eo_name_table.eo_name = fake_prod.prod_title WHERE prod.prod_title IS NULL I'm not

Re: LEFT JOIN problem

Hi Jerry, I think the problem is that NULL is not less than or greater than your prod_published date. So you probably have eo_pub_date set to NULL in 56 of your rows. so for eo_name_table.eo_pub_date prod.prod_published or eo_name_table.eo_pub_date = prod.prod_published mysql will

Re: Auto Fill blank Rows

To get a blank line instead of NULL you could simply wrap the reference in an IFNULL function: select dummy.row_id,IFNULL(real.reference,'') as Reference from dummy left join real on real.row_id=dummy.row_id; Phil wrote: you could do something like select dummy.row_id,real.reference

Re: Is there any workbench or development studio available for Linux?

From the download page: Please note that at this point only the Windows Beta version is available. Linux and OS X releases will be available in 2008. It looks nice, I was looking for a similar tool 5 -6 years ago. It looks like what I would have wanted at the time. legolas wrote: Is

mysql-table-checksum with mixed storage enginges

Will mysql-table-checksum from mysql toolkit work with setups that have different Master/ Slave storage engines? Are there any things to consider when using it between two different engines ( say Innodb master and MyIsam slave)? Thanks in advance, Bill Newton -- MySQL General Mailing

Re: it doesn't return from the mysql_query processing

Hi Koki, You have to re- establish the database connection in each child process. Otherwise the packets get mangled and you get the errors you're seeing. Koki Takeda wrote: I hope that my contacting you is not an imposition in any way. My name is Koki Takeda. This time, I made the php

Re: MySQL 5 et les charset sur debian etch

transfert des données à partir d'une base de données à l'autre. Comment avez-vous copié les données ? Vous pourriez examiner insérer de nouvelles données dans chaque base de données et voir si elle semble correcte. Bill Gilles MISSONNIER wrote: Hello, j'ai 2 machines Linux debian etch, avec

Order By and Ignore Punctuation

I would like to perform a query of a personnel database with an ORDER BY clause that ignores punctuation. For example, O'shea would sort after Osbourne, not to the beginning of the Os. Is this doable in the query? -= Bill =- -- You can tell a lot about a man by the way

using DISTINCT after the ORDER BY clause has been applied

to me as if your query returned exactly what you asked for. It found the first two rows (other rows are not distinct), and then ordered them in descending order by time stamp. Descending is largest to smallest. TS for row 2 is larger than TS for row 1. -= Bill =- -- You

Re: www.innodb.com

makes me think that it still should, and it doesn't now. That is the issue that I raised. I am guessing, given Reimer's insight, that the domain name registration has expired and someone needs to renew it. I hope they plan to do that because I found the site useful. Bill Riemer Palstra wrote

www.innodb.com

What happened to the Innodb web pages? What comes up for be is a search page with a bunch of related links on it. I wanted to pull down a copy of ibbackup documentation and it isn't there anymore. Bill +--- | Bill MacAllister, Senior

Re: www.innodb.com

--On Thursday, November 09, 2006 08:37:01 PM +0200 Onur [EMAIL PROTECTED] wrote: Bill MacAllister wrote: What happened to the Innodb web pages? What comes up for be is a search page with a bunch of related links on it. I wanted to pull down a copy of ibbackup documentation and it isn't

Default Column Value

),substr(start_date,6,2)). Something like ALTER TABLE events ALTER start_yr_mo start_yr_mo SET = concat(substr(start_date, 1, 4),substr(start_date,6,2)); -= Bill =- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Client being locked out by aborted connections

In response to Bill Moran [EMAIL PROTECTED]: In response to Dan Buettner [EMAIL PROTECTED]: Bill, you can up the value of 'max_connect_errors' (default is 10 it appears) to make this problem appear less frequently while you troubleshoot. Thanks for the thought, Dan. Before I do

Client being locked out by aborted connections

: FreeBSD 5.3-RELEASE-p37 mysql-server-4.1.21 -- Bill Moran Collaborative Fusion Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Client being locked out by aborted connections

In response to Dan Buettner [EMAIL PROTECTED]: Bill, you can up the value of 'max_connect_errors' (default is 10 it appears) to make this problem appear less frequently while you troubleshoot. Thanks for the thought, Dan. Before I do that, I'll just add a cron job to do the flush-hosts every

RE: SELECT counting chars with LEFT()

You know, this works just fine for me -- when you say it is NOT working, what do you mean exactly? Are you getting an error? Or results that you don't expect? Bill Tantzen University of Minnesota Libraries [EMAIL PROTECTED] 612-626-9949 (office) 612-250-6125 (cell

Re: text mode listing

Hi obed I looked many times in the commands list and maybe I didn't wat to see it !!! The answer is a '\G' appended at the end of the line. Thanks for the help Bill Can you remind me how to tell mysql to list vertically instead of horiz in text mode? List of all MySQL commands

text mode listing

Hi Can you remind me how to tell mysql to list vertically instead of horiz in text mode? Ex: select all * from a_tablesends field1 field2 . I want field1 field2 field... Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Limit characters in a long text

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html I recommend LEFT( ). If you are looking to do it in PHP then this is the wrong email list. Good luck. b. CodeHeads wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello all, Have a question: I would like to limit the

Re: innodb in 4.1.18

Marten Lehmann wrote: I had a lot of trouble today because the InnoDB integration in MySQL is lousy. I read the manual and worked with innodb_per_file_table. So when I shutdown mysql I should be able to delete ib_logfile0, ib_logfile1 and ibdata1, because all table-data should be stored in

Re: innodb in 4.1.18

InnoDB always needs the shared tablespace because it puts its internal data dictionary and undo logs there. The .ibd files are not sufficient for InnoDB to operate. well, thats what I found before. But it doesn't explain why InnoDB does need a logfile even when all transactions are

Re: copy one field value to another

UPDATE table SET field_a=field_b; b. Ravi Malghan wrote: Hi: is there a way to copy all field values from one field to another from the mysql prompt? Thanks Ravi __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection

Upper Limit to max_join_size? (4.1.18)

to avoid using SET SQL_BIG_SELECTS=1. I know in earlier versions (perhaps 4.0.x?) I could increase the value to what I wanted. I will happily add the output from show variables if that will help. Thanks in advance for your help. --Bill Welcome to the MySQL monitor. Commands end with ; or \g

Re: Backups

Hi I'd say that you have an ideal situation to use a Raid level 1 system. Rick Dwyer [EMAIL PROTECTED] a écrit dans le message de news: [EMAIL PROTECTED] Hello all. I am looking into the different back up methods available for safeguarding my MySQL databases. Ideally, I would like to have

Re: temporary table issue

. Xiaobo -- Bill Dodson Parkline, Inc. http://www.parkline.com phone: 304-586-2113 x149 fax: 304-586-3842 email: [EMAIL PROTECTED] Email Disclaimer The information in any email is confidential and may be legally privileged. It is intended solely for the addressee. Access to the email message

Re: Converting decimal to binary

); And have a result that looked like this +---+---+---+---+---+---+---+---+ | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 | +---+---+---+---+---+---+---+---+ | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | +---+---+---+---+---+---+---+---+ - Thanks -- Bill Dodson Parkline, Inc. http://www.parkline.com phone: 304-586-2113

Re: Hijackers?

the HTML conversion functions to convert to quot; etc. I found this helpful: http://www.unixwiz.net/techtips/sql-injection.html -- Bill Dodson Parkline, Inc. http://www.parkline.com phone: 304-586-2113 x149 fax: 304-586-3842 email: [EMAIL PROTECTED] Email Disclaimer The information

'GROUP BY' behavior

) timestamp GROUP BY qtreename,hostname My questions: From which of the several averaged rows do 'allocated' and 'available' come in the results? Can I control this? I would like the row with maximum timestamp. Thanks, Bill

RE: 'GROUP BY' behavior

Shawn, That's a very reasonable answer. Thanks for pointing me to the examples. This one addresses the second question: http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row. html . There is no example answering both questions in one query. Regards, Bill

How do you set a Primary Key when uploading data into a table?

How do you load data into a table and generate a primary key which increments by 1. I want to end up with a primary key value of int 1, 2, 3, 4, and so on. My table has three rows, Id, Code, Description. I'm loading data from a text file into the table like this: load data local infile

How do you set a Primary Key when uploading data into a table?

How do you load data into a table and generate a primary key which auto increments by 1. I want to end up with a primary key value of int 1, 2, 3, 4, and so on. My table has three rows, Id (pri_key), Code, Description. I'm loading data from a text file into the table like this: load data

Newbie MySQL/PHP question re output formatting

get $ number_format(7842554.24, 2) in the cell where I would expect to get $ 7,842,554.24 Any idea what I'm doing wrong? Clearly, I don't understand arrays very well. Thanks VERY much for any help on this. bw --- Bill Whitacre [EMAIL PROTECTED] -- MySQL General Mailing List For list archives

MySql hanging

| | interactive_timeout | 28800 | I tried this in MySQL 4.1.8, 4.1.12, and 4.1.14. Any help would be appreciated, Bill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: MySql hanging

of circumstances though, I think rewriting it is the way to go. Thanks again, Bill Quoting [EMAIL PROTECTED]: Bill Duffy [EMAIL PROTECTED] wrote on 08/31/2005 11:32:02 AM: When I run a query like this DELETE FROM test_P_Cookie WHERE ViewID IN (SELECT ViewID FROM test_x_RM_4508_48875

Re: MysqlI

Hi Did someone use MySQLI in production environment ? Is the transactions aspect reliable ? (bugs etc) Thanks. Sorry I should have specified that it's in the PHP environment. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: MySQL

Hi Shawn The short answer is Yes. Do you want a list of companies from the Fortune 100 or are you interested in a particular business area? There are some huge names (http://www.mysql.com/customers/) that use MySQL for critical, public-facing, and infrastructure applications. Many of them

Re: MySQL

Hi Shawn, Are transactions stable and supported (production ready) in MySQL? Yes, with one caveat. You must keep your data in InnoDB tables in order to get full commit/rollback support. MyISAM does not support automatic rollbacks. Is mysqli_xx written to properly use the built-in transaction

MysqlI

Hi Did someone use MySQLI in production environment ? Is the transactions aspect reliable ? (bugs etc) Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SELECT vs SET for creating variables

(@neededStep, ' ', @startOfCenter) ); It would seem that SET is a better way to create variables from constant values, but I would like to understand why. Does anybody know what is happening here? Thanks for your time! bill -- Bill Dodson Parkline, Inc. http://www.parkline.com phone: 304-586-2113 x149

getLong() vs getInt() result differs on unsigned field

void main(String[] args) { long theLong = 4294967298L; System.out.println((int) 4294967298L = + (int) theLong); } } C:\javaboxjava TestLong (int) 4294967298L = 2 HTH Bill == original message follows == Date: Mon, 11 Jul 2005 13:54:12 -0400 From: Kevin McAllister [EMAIL

db/mysql rookie request

the time to develop some SQL to get the data I would like to get. However, I want to do this with a Korn shell script that emails the report to a list of internal customers. Any help you can provide would be greatly appreciated. Thanks in advance, Bill

mysqldump, --single-transaction and --flush-logs

If I use the options --single-transaction and --flush-logs with mysqldump and InnoDB tables, does the new log file start at the same time as the transaction? If not, is it known for sure if the log file is switched before the transaction starts or if it is switched after the transaction starts?

Re: Need help coverting MDB SQL

a '#' in literals when you specify them. The good think about using perl is that you can handle all of these problems. Hope that helps, Bill +--- | Bill MacAllister | 14219 Auburn Road | Grass Valley, CA 95949 --On Saturday, March 26, 2005 10:35:04 AM -0500

the new Connector J

(EventDispatchThread.java:145) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137) at java.awt.EventDispatchThread.run(EventDispatchThread.java:100) SQLException: SQLState(S1009) Thanks bill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: EBCDIC collation sequence

Bill Maidment wrote: Hi There doesn't appear to be any info. on the archives regarding this, so does anyone know what character set/collation sequence to use for EBCDIC rather than ASCII collation? I discovered the /usr/share/mysql/charsets directory and added a latin1_cp500_ci collation entry

EBCDIC collation sequence

Hi There doesn't appear to be any info. on the archives regarding this, so does anyone know what character set/collation sequence to use for EBCDIC rather than ASCII collation? Cheers Bill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: global object-id

Well, the answer is no--there's no magic way to have an auto_increment do what you want. You could use a GUID--basically a pseudo-random number such the expected time to pick a duplicate is on the order of the lifetime of the universe. But GUID's are big and ugly, and it would be nice to just

Re: Max connections being used every 10-12 day.

is going to first consider the join and then consider the use of indexes for the where clause--so it ends up with the full table scan. HTH, Bill = original message follows = From: Fredrik Carlsson [EMAIL PROTECTED] To: Donny Simonton [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re

Re: ORDER BY sorting

Mike, Try select * from foo order by x+0, x; x+0 converts x to an integer by taking the digits from the beginning of the string. == original message follows == Date: Sat, 11 Dec 2004 15:36:34 -0600 From: Mike Blezien [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Subject:

Yet another LEFT JOIN question

the clicks, then left join that with the views. HTH Bill From: Ron Gilbert [EMAIL PROTECTED] Subject: Yet another LEFT JOIN question Date: Sat, 4 Dec 2004 12:08:43 -0800 I have three tables, 'Ads' is a list of ads, 'Clicks' is a simple list of every time a Ad was clicked on with the Ads ID

Re: Yet another LEFT JOIN question

) solution looks at more rows; on the other hand, subqueries may not get as much optimization. I'd claim that the subquery describes better what you want, while the count(distinct) is a kludge to avoid the subquery. - Original Message - From: Ron Gilbert [EMAIL PROTECTED] To: Bill Easton [EMAIL

relay log file maintenance problem

the number relay log files so that someone doesn't have to check a replication server to see if the filesystem for the MySQL data directory hasn't been filled by old relay log files that haven't been accessed for some specified time? Thanks in advance, -bill -- MySQL General Mailing List For list

Re: Reorder a table

Martin, The following will do the resequencing you requested. Hope it helps. create table temporary_table select * from the_table; set @T=0; update temporary_table set id=(@T:=(@T+1)), the_time=the_time order by the_time; delete from the_table; insert into the_table select * from

Live in Puget Sound?

this person to be willing to come to my home in Des Moines, WA. I will pay travel time also. If interested contact Bill Cory at 253-946-0114

Re: Index not used for select distinct?

, as it only has to look for one of each possible IP in the larger table.) HTH, Bill Matthias Urlichs wrote: We have a slight opimization problem here. Given this table: CREATE TABLE `test` ( `IP` varchar(15) collate latin1_german1_ci NOT NULL default '', `Type` enum('WARN','ERROR','FATAL','UNKNOWN

Table doesn't exist on query replication problem...

it has no concept of the database named reporting. Is there a way to rework this query so that either there are no references to the reporting database or to configure my.cnf on the master and slave to handle this query? Thanks in advance, -Bill Thomason -- MySQL General Mailing List For list

Replication problem with a cross database query

relationships and uncovered the bug in doing so. Thanks in advance, -Bill Thomason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: A query to swap the data in two fields

normally get me an answer in minutes, is my question too easy? zzapper (vim, cygwin, wiki zsh) -- zzapper, Gee, have you paid your bill yet?g The only thing I've been able to come up with is: update table1 a, table1 b set a.beds1=b.beds2, a.beds2=b.beds1 where a.rcd_id=b.rcd_id You

Re: Query takes terribly long

AND (MONTH(putdatetime) 2 OR DAY(putdatetime) 29) ORDER BY putdatetime DESC LIMIT 0,30 HTH, Bill == Dirk Schippers wrote: == Date: Sun, 19 Sep 2004 18:35:24 +0200 From: Dirk Schippers [EMAIL PROTECTED] To: Jocelyn Fournier [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Query

Re: Query takes terribly long

. Maybe you only care about an approximate result, and none of this matters. - Original Message - From: Dirk Schippers To: Bill Easton Cc: [EMAIL PROTECTED] Sent: Monday, September 20, 2004 6:06 PM Subject: Re: Query takes terribly long Hello Bill, Your explanation gave

Re: can not find file *.MYI

InnoDB doesn't use any *.MYI, only *.FRM. The indexes are in the data files. You might check the 4th byte of the .FRM file. x'0C'=InnnoDB, x'09'=MyISAM. If the InnoDB data files are good, there was a post earlier this year from Heikki Tuuri about how to get the structure from there. If the

Re: please explain why this query isn't optimized

Well, actually, there are 2.878 Meg rows, or 2878k. What's happening is that it's using the index to find all of the rows where changed 0, then scanning for the maximum. If you just look for the maximum, then discard it if it's not greater than 0, it will be much faster. The following with

Re: huge innodb data files

Hmm, well... It really shouldn't take 2 min to select from an empty table, no matter what you have in my.cnf. So, something else is happening. One way that InnoDB can take forever to read from an empty table is if there's a transaction still in progress that was started some time ago. Perhaps

Re: Replication blocked

A few brief comments on this one... (1) Multi-threaded would probably cause thousands of problems Well, not necessarily. Currently, the slave reads transaction A from the relay log, executes its actions, commits it, then reads transaction B, executes and commits. It wouldn't be unreasonable

Count of two fields

select ListName, count(*), sum(Info is not null) from ListTable group by ListName = Original Message Follows = From: John Berman [EMAIL PROTECTED] Subject: Count of two fields Wonder if you can help I have a table with a number of fields but the List Name Member Info Ever member

Count even when empty

SELECT dbo.lists_.Name_, COUNT(dbo.members_.EmailAddr_) AS nojgid FROM dbo.lists_ INNER JOIN dbo.topics_ ON dbo.lists_.Topic_ = dbo.topics_.Title_ LEFT JOIN dbo.members_ ON dbo.members_.List_ = dbo.lists_.Name_ GROUP BY dbo.lists_.Name_, The first inner join gives you a

Last insert id problem/bug

. The reason for this is so that two threads can independently insert records with an auto_increment key without either one having to wait for the other. This can make a substantial difference to the concurrency of transactions. HTH Bill - original message follows -- Date: Thu, 22 Jul

Re: CocoaMySQL access to db

Your problem may have to do with the difference in how 4.1.x+ does password hashing and that method is incompatible with older clients. You might find some help with this document: http://dev.mysql.com/doc/mysql/en/Old_client.html Specifically check out the information regarding resetting the

Re: CocoaMySQL access to db

doing updates or installing some applications on OS X. Lastly, restart MySQL and you should be all set. On Jul 9, 2004, at 10:30 PM, Peter Paul Sint wrote: Bill, thank you for the prompt help. This works. I have just to find out how to get the Startup Item (or some replacement) to open MySQL

Re: CocoaMySQL access to db

Peter, My apologies on calling you Paul in my previous response instead of Peter. On Jul 9, 2004, at 10:30 PM, Peter Paul Sint wrote: Bill, thank you for the prompt help. This works. I have just to find out how to get the Startup Item (or some replacement) to open MySQL with --old_passwords

Re: Very strange database behavior

Paul, Has this class worked properly in the past? Have you tried executing the queries your class executes manually via the mysql client or a similar application removing your Java code from the equation? Have you run 'check table' if the table is either MyISAM or InnoDB? On Jul 7, 2004, at

Re: mysqld_safe in 4.1.2

--On Wednesday, June 30, 2004 07:36:23 PM -0500 Paul DuBois [EMAIL PROTECTED] wrote: At 13:58 -0700 6/30/04, Bill MacAllister wrote: Hello, I am a bit confused by processing of user= specifications in the mysqld_safe script. Here is what I see: * If user= is specificed in the [mysqld

[Stats] MySQL List: June 2004

3 -- - Bill Doerrfeld[EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.com/ - Build and serve

mysqld_safe in 4.1.2

? Bill + | Bill MacAllister, Senior Programmer | PRIDE Industries | 10030 Foothills Blvd, Dept 1150 | Roseville, CA 95747 | 916-788-2402 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

reading past bogus data in log event error in binary log in 4.0.18 ?

, the master server is running along just fine, writing new info into this log file just fine. Is there any way to get the slaves past this bad record, short of manually resyncing everything again? Thanks for your help! Bill Earl Network Admin www.bestbill.com

pashto/dari/arabic character sets question

? in earlier versions? and finally, is mysql 4.1 stable enough to use in a production environment, or is that ill-advised? thank you very much in advance, --bill french -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

[Stats] MySQL List: May 2004

3 -- - Bill Doerrfeld[EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.com/ - Build and serve

Re: optimizing inserts

On May 16, 2004, at 1:15 AM, Ron Gilbert wrote: I have a table that is: CREATE TABLE GPSData ( ID int(10) unsigned NOT NULL auto_increment, Lat decimal(9,5) default '0.0', Lon decimal(9,5) default '0.0', TDate datetime default NULL, PRIMARY KEY (ID), UNIQUE KEY ID (ID), KEY

Re: Sorting Varchar

. . . The non-numerics came out last (which I want). There are two zeros but no negative numbers. Any alternatives? Ken ** On Wed, 12 May 2004 07:47:11 -0400, Bill Easton [EMAIL PROTECTED] wrote: You could also use order by cost+0,cost. This puts the non-numerics first

Fw: Sorting Varchar

You could also use order by cost+0,cost. This puts the non-numerics first, then the numerics in numerical order. (You'd need to get fancier if there are non-numerics starting with a digit or numerics = 0.) From: Sasha Pachev [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: How do I set

[Stats] MySQL List: April 2004

4 -- - Bill Doerrfeld[EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.com/ - Build

Re: first LIMIT then ORDER

curious. From: Keith C. Ivey [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Fri, 23 Apr 2004 11:27:38 -0400 Subject: Re: first LIMIT then ORDER On 23 Apr 2004 at 7:23, Bill Easton wrote: The last suggestion is useful when you do care which entries you get, as you can use one order for limit

Re: first LIMIT then ORDER

The last suggestion is useful when you do care which entries you get, as you can use one order for limit and another for presentation. For example, if you'd like the LAST 10 rows, but sorted in FORWARD order, you can use something like (select * from HISTORY order by version desc limit 10)

Re: Randomly selecting from table

If you want to guarantee that the selections are different, rand() doesn't quite do it, as you will get a repeated value with the appropriate probability. You will need to keep a record of what values have already been seen. Then, use something like select ... from my_table left join

how to rewrite this query without using temporary table

for each appointment in the given range - a row for each patient who doesn't have an appointment Then the where clause throws away the ones with appointments. regards, Bill From: lorenzo.kh [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: how to rewrite this query without using temporary table

[Stats] MySQL List: March 2004

5 -- - Bill Doerrfeld[EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.com/ - Build and serve

using old frm files

created. (3) If the table you lost was InnoDB, change the 4th byte of the file from hex 0C to hex 09. (This makes it look like a MyISAM .frm) (4) You should be able to run show create table foo from the MySQL client. HTH Bill Easton Lexpar Date: Tue, 23 Mar 2004 11:04:49 -0500 (EST) From: dan

Re: Partial Replication ?

You can suppress writing the delete query to the binary log. mysqlset sql_log_bin = 0; mysqldelete ... ; mysqlset sql_log_bin=1; Bonnet R?my [EMAIL PROTECTED] wrote: Hello, I have a database which is flushed every four hours, and I want to replicate it without replicating the delete

[Stats] MySQL List: February 2004

6 -- - Bill Doerrfeld[EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.com/ - Build

Re: Setting variables on update

The following works on 4.0.16, for those of us who'd like to stick to the stable release: update controltable set nextid = 1 + (@prevval := nextid) Note. There was a problem with this in 4.0.13--namely, the value of @prevval sometimes was garbage. I reported this via the list, but got no

disabling optimizations to identify slow queries

to make my performance issue more reproducible? Am I missing something? -=bill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

  1   2   3   4   5   6   >