Re: Download older versions

Jim - Original Message - From: Jim Winstead [EMAIL PROTECTED] To: Mike Blezien [EMAIL PROTECTED] Cc: MySQL List mysql@lists.mysql.com Sent: Thursday, April 13, 2006 7:28 PM Subject: Re: Download older versions On Thu, Apr 13, 2006 at 07:13:55PM -0500, Mike Blezien wrote: Hello

Days in Month

Hello, is there a MySQL function to determine the total days of any given month, IE if current month is April, is there a function or query to find the total days of the month? TIA, Mike(mickalo)Blezien === Thunder Rain Internet Publishing Providing Internet

Getting number days between 2 dates

, Mike(mickalo)Blezien === Thunder Rain Internet Publishing Providing Internet Solution that Work === -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Getting number days between 2 dates

Jorrit, - Original Message - From: Jorrit Kronjee [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, April 01, 2006 7:46 AM Subject: Re: Getting number days between 2 dates Mike Blezien wrote: Hello, I'm sure this is a simple query but haven't come up with a good approach

Re: Getting number days between 2 dates

thx's Keith, another option :) Mike - Original Message - From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, April 01, 2006 10:52 AM Subject: Re: Getting number days between 2 dates Use SELECT DATEDIFF('new_date', 'old_date'); mysql SELECT DATEDIFF('2006-04-01

Re: stunningly slow query

Can you post the output of SHOW FULL PROCESSLIST during the time when both sets of queries are running? Also what storage engine are you using for your tables? Chris Kantarjiev wrote: We're having some serious problems with concurrent queries. This is a dual-processor amd64 machine with 16GB

Re: stunningly slow query

Chris Kantarjiev wrote: Can you post the output of SHOW FULL PROCESSLIST during the time when both sets of queries are running? That throws out my first theory about table locks. What do vmstat and top say? Is it CPU bound? I/O bound? Also you might want to do a show status before and

Re: stunningly slow query

It doesn't really answer your question, but have you tried INSERT DELAYED as a work around? Also the updated status is strange, because that generally indicates that its looking for the record to be updated, but since the record is new, there is no record to be updated. Could it be checking

Update multiple tables

Hello, I'm alittle unclear on how too update multiple tables. We have two tables with the same column name: account.state account_service.state when we update the account table, we also need to update the account_service table with the same value for the 'state' column. Can this be done with

Re: Problem restarting server

Yes, that was the problem, the my.cnf file was missing, replace it, restarted and all is well :) thx's Mike - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, March 22, 2006 2:10 AM Subject: Re: Problem restarting server Mike

Problem restarting server

= How can this problem be fixed so we can restart MySQL server, kind of in a bind here now... TIA, Mike Mike(mickalo)Blezien === Thunder Rain Internet Publishing Providing Internet Solution that Work http://www.thunder-rain.com

Perl MySQL

this, something to do with the DBD version used. Or is this something too do with the MySQL version we are using? Any info be much appreciated. TIA, -- Mike(mickalo)Blezien -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Database design help

datetime NOT NULL default '-00-00 00:00:00', exported varchar(10) default NULL, affid int(6) unsigned NOT NULL default '0', PRIMARY KEY (visitorid), KEY email (email), KEY affid (affid) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; TIA, -- Mike(mickalo)Blezien

Re: Database design help

OK, I think I got it now. Thanks for the additional info, that helps alot. Rhino wrote: - Original Message - From: Mike Blezien [EMAIL PROTECTED] To: MySQL List mysql@lists.mysql.com Sent: Friday, February 17, 2006 7:49 AM Subject: Database design help Hello, we currently have

Installed CompleteMySQL 4.0.21 - now cant login to terminal

I installed MySQL, which runs an initialize script everytime I launch the terminal, and it automaticlly logs me out, so I cant use the terminal locally. I uninstalled MySQL, now I need to get rid of the script and what calls it. I get the following when I launch the terminal: Last login: Fri Jan

Show Description options??

Hi I was looking for a command that will list the names of my columns only. I have investigated show columns but there seems to be no way to return just the names. Any suggestions?? Thanks Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Histogram from tables.

I have a large table of filenames and creation dates from which I want to produce a histogram. SELECT year(date), quarter(date), count(0) FROM pics WHERE date(date) '2000' AND date(date) ' 2005' GROUP BY year(date), quarter(date) Gets me close, but to simplify plotting, I want to include

Help crafting an SELECT

Hi List! Please forgive me if I'm asking the wrong list (and please guide me to the right place). I have two tables (simplified for this example) pics and tags like so: pics: picid photo 1Mustang 2Apple 3Rock 4Beetle tags: tagid picidtag 11 Car 21

Re: Help crafting an SELECT

On 1/11/06, Gordon Bruce [EMAIL PROTECTED] wrote: I assume you are looking for both red and car. You can not use IN because that is implicitly an IN. You hae to join the tags table to itself using 2 different aliasis. {If you required 3 things then you would join it 3 times etc..} SELECT *

Re: working w/UK postcodes

increase east to west and _usually_ have a numeric difference somewhat related to their geographic distance, this isn't always true. I know of two island zip codes (unrelated to those that surround it) in New York State. -- Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain

Re: working w/UK postcodes

State. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http

Re: Cant access my files through the web site

Hi The problem here does not involve mysql. For better advice, try an apache or PHP group. From what I know, I would check directory permissions in the apache conf file. Mike - Original Message - From: ghislain groulx [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: January 8

UK Postcodes

someone on the list may have worked with UK postcodes and may have some info on the best way to query these postcodes for locating closed location, distances,.etc? thx's -- Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions

UK Postcodes

someone on the list may have worked with UK postcodes and may have some info on the best way to query these postcodes for locating closed location, distances,.etc? thx's -- Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions

UK Postcodes

someone on the list may have worked with UK postcodes and may have some info on the best way to query these postcodes for locating closed location, distances,.etc? thx's -- Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions

Testing

is the list still working ? -- Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://thunder-rain.com/ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- MySQL General Mailing List For list archives: http

working w/UK postcodes

this in the same manner one would do it with US zipcodes? thx's -- Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://thunder-rain.com/ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- MySQL General Mailing List

innobase_query_caching_of_table_permitted error?

to narrow it down to a single query yet, I was hoping someone had already seen this. I'm running FreeBSD 5.4. Thanks. Mike

Re: Band width consume

I don't have any stats but I would assume it's as big as your select statement plus as big as the result set. Mike - Original Message - From: Luiz Rafael Culik Guimaraes [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: December 4, 2005 7:02 AM Subject: Band width consume Dear Friends

ERROR 2003 (HY000): Can't connect to MySQL server on 'gandalf' (111)

hosts from both hosts. I can ping each host ( by name ) both ways. I can ssy ( by name ) between both hosts. Thanks, Mike __ Start your day with Yahoo! - Make it your home page! http://www.yahoo.com/r/hs -- MySQL General Mailing List For list

Re: UPDATE and INDEX updates

. Is it the row changed flag or is there a column changed flag ??? Mike - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: November 23, 2005 5:51 AM Subject: Re: UPDATE and INDEX updates Hello. don't think I will find the answer

Re: UPDATE and INDEX updates

I understand that MySQL returns the # of rows changed. What I am wondering is if I change only one value, therefore a row change, but leave the rest, what happens. Does the row get removed from the index and re-placed?? Does MySQL look at each column value first to compare?? Mike

Re: UPDATE and INDEX updates

. I don't think I will find the answer to this question in the normal manuals but rather from someone / place that deals with the internals of the system. Mike - Original Message - From: sheeri kritzer [EMAIL PROTECTED] To: Mike OK [EMAIL PROTECTED] Cc: MySQL List mysql@lists.mysql.com Sent

UPDATE and INDEX updates

but want to make sure I need to before going ahead. Mike

upgrade RH 7.3

, and was wondering if there are any problems encountered with RH 7.3 and MySQL 4.1+ that we should be aware prior to upgrading. Which rpms should we use to do the upgrade? we run the std MySQL server. TIA, -- Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing

Re: Financial return calculations help please

Jim Seymour wrote: I have researched repeatedly and cannot find an answer to the following. I need to do something like the following (There is probably an easier way). end_date - start_date = diff / start_date = return for period The table contains 401k investment values. Ideas, pointers,

Help with tricky query

used to tie(join) too a `school_profile` table(all personal data) any help with optimizing a single query would be appreciated. TIA, -- Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://thunder-rain.com

Re: Help with tricky query

Hello, [EMAIL PROTECTED] wrote: Mike Blezien [EMAIL PROTECTED] wrote on 10/04/2005 08:34:56 AM: Hello, I am trying to put together a single query from across 4 tables and not having a problem getting the results needed. table structure

Re: Help with tricky query

[EMAIL PROTECTED] wrote: Mike Blezien [EMAIL PROTECTED] wrote on 10/04/2005 10:08:24 AM: Hello, [EMAIL PROTECTED] wrote: Mike Blezien [EMAIL PROTECTED] wrote on 10/04/2005 08:34:56 AM: Hello, I am trying to put together a single query from across 4 tables and not having

Re: Storing manually diggested Passwords with MD5

C.F. Scheidecker Antunes wrote: I am sorry. I meant another thing and wrote something else. If I issue: INSERT INTO table1 values ('username',MD5('password')) I will have the password stored in the database with MD5. What I actually need is a manual way to get the password back, that is

Re: why does this query run slowly at times

Kishore Jalleda wrote: Try two things. First: EXPLAIN SELECT title, template FROM template WHERE templateid IN

Re: why does this query run slowly at times

. Thanks Kishore Jalleda On 8/9/05, Mike Wexler [EMAIL PROTECTED] wrote: Kishore Jalleda wrote: Try two things. First: EXPLAIN SELECT title, template FROM template WHERE templateid

4.1 and unions

! -- Mike Johnson Smarter Living, Inc. Web Developerwww.smartertravel.com [EMAIL PROTECTED] (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: 4.1 and unions

, interesting. My next question was going to be if the second syntax is correct (all subqueries enclosed in parens), but looks like it's good. Thanks, Scott. -- Mike Johnson Smarter Living, Inc. Web Developerwww.smartertravel.com [EMAIL PROTECTED] (617) 886-5539 -- MySQL

Issues on Debian-AMD64 - looking for ideas or help.

I'm compiling my mysql server from source. I have started noticing this as of 4.1.10 - in fact, I was running 4.1.12 and it's changed the LinuxThreads detection (since LT does not exist on amd64) - and 4.1.12 kept locking up after only a few minutes of uptime consistently. Once I figured this

Complex Query

with a workable solution to do this. And was hoping someone could suggest a feasible query to do this or do I need to restructure the tables that are being searched on?? Hope this is clear :) TIA, -- Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet

RE: DB design question

design, but you need to not `select *' but the specific fields you'd like. An example of might be: SELECT s.name, s.age, a.street_name, n.num, n.extension FROM students s JOIN address a ON a.student_id = s.student_id JOIN phone_num n ON n.student_id = s.student_id HTH! -- Mike Johnson

RE: DB design question

From: Mike Johnson [mailto:[EMAIL PROTECTED] From: Koon Yue Lam [mailto:[EMAIL PROTECTED] the problems is, when I want to query both student, address and phone num, the sql will be select * from student s, address a, phone_num n where s.student_id = a.sudent_id and s.student_id

Using AVG

Hello, when using the AVG function like this: SELECT AVG((5+8+10)/3) AS rate; it returns NULL?? the AVG can be used to do a literal math calculation ?? TIA -- Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work

Re: Using AVG

Simon Garner wrote: Mike Blezien wrote: Hello, when using the AVG function like this: SELECT AVG((5+8+10)/3) AS rate; it returns NULL?? the AVG can be used to do a literal math calculation ?? TIA That doesn't make any sense... AVG is a GROUP BY function. If you have 3 rows with values 5, 8 and 10

Re: TOP N record

SELECT date1, process, wip, worm FROM table WHERE field=value ORDER BY otherField DESC LIMIT N Seena Blace wrote: Hi, how to get top N records from table ? columns of table id date1 process wip worm I need output date1 process wip worm 5/5/05

Multi-Language setup

that will be used to store this type of data with various language being stored due to the various unique characters used in many languages. TIA, -- Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://thunder

Multi-Language setup

that will be used to store this type of data with various language being stored due to the various unique characters used in many languages. TIA, -- Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://thunder

Re: Multi-Language setup

Gleb Paharenko wrote: Hello. Unicode is usually used in such cases. Mike Blezien [EMAIL PROTECTED] wrote: Hello, we are working on a project that will be using multiple languages to be displayed and stored in a database, for producing various text strings in english and the language associted

same-table join

a 'foo' action but not a 'baz' action (those being b and c). I know I know the answer to this, but I'm drawing a blank at the moment. Thanks in advance if someone could give me a hand. -- Mike Johnson Smarter Living, Inc. Web Developerwww.smartertravel.com [EMAIL PROTECTED

Comparing to null queries

these versions or is this a bug? I couldn't find anything specific to this on the archives. TIA -- Mike Rykowski NU-IT Telecommunications and Network Services -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

insert based on a select?

all members found. So I'd need to do a select based on the found ID and delete all rows that were returned. I'm doing this now in PHP using multiple SQL calls but when I get into the 1,000 of members it's taking longer that I can accept. Any help is appreciated. Thanks! ~ Mike Zornek

MySQL Functions

Hello, Sorry for the slightly OT question :) Hoping we have some expert MySQL Function to perl function people on the list. Is there an equivelant function in perl for converting IP's, the same as MySQL functions: INET_ATON('IP_ADDRESS_STR') and INET_NTOA('STR') TIA, -- Mike(mickalo)Blezien

mysqldump privileges

no will not allow them access to their respective database any more. We get alot of access denied to databases... lock tables.. or other options. TIA -- Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http

Table handler errors

if anyone may have some insight on how to remedy this type of error. TIA, -- Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- MySQL General Mailing List For list archives

Re: Table handler errors

Jigal van Hemert wrote: From: Mike Blezien we started getting these table handler errors 12, not all the time, but just now For errors from the operating system you can use perror to find out the description of the code: http://dev.mysql.com/doc/mysql/en/perror.html Regards, Jigal. Yes, I've

RE: Query Performance

to (most likely PHP or Perl), it may be quicker to do those calculations in the wrapping script (if there is one, that is). HTH! -- Mike Johnson Smarter Living, Inc. Web Developerwww.smartertravel.com [EMAIL PROTECTED] (617) 886-5539 -- MySQL General Mailing List For list

RE: Query Performance

`result` separately may not help at all. Might be worth a shot, though, if you have the disk space and time to play around with it. -- Mike Johnson Smarter Living, Inc. Web Developerwww.smartertravel.com [EMAIL PROTECTED] (617) 886-5539 -- MySQL General Mailing List For list

MySQL problems on SuSE 9.0

to completely remove all traces of MySQL from this box and give it a fresh, clean reinstall. BTW when I use the mysqld command, or the mysql command from the root directory, it says command not found, if that helps anyone. Thank you for any help that you may give Mike Brown

Re: Measuring query progress

On Thu, 7 Apr 2005, Gleb Paharenko wrote: Hello. If you're using an InnoDB tables you could monitor the progress with SHOW INNODB STATUS using the number of proceeded rows. See: http://dev.mysql.com/doc/mysql/en/innodb-monitor.html Thanks. I'll give it a shot. Mike Mike

Measuring query progress

as I can tell. Is there some way I can compare the output from the 'explain' of the query with the output of 'show status' to estimate how far along the query is? There have been no other queries processed so that everything in the status variables is a result of this query. Thanks Mike -- MySQL

Convert historical dates from UTC

datetime and does this? TIA - Mike Rykowski IT - Telecommunication and Network Services (847) 467-7335 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Convert historical dates from UTC

At 10:28 AM 3/22/2005, [EMAIL PROTECTED] wrote: What do you mean by historical? Are we talking 20th century dates or something BCE? Dates that could be a couple of years old. - Mike Rykowski IT - Telecommunication and Network Services (847) 467-7335 [EMAIL PROTECTED] -- MySQL General

RE: Passing Arrays between pages

INPUT NAME = \kcompany[]\ TYPE = \hidden\ VALUE=\Apple\; echo INPUT NAME = \kcompany[]\ TYPE = \hidden\ VALUE=\Banana\; echo INPUT NAME = \kcompany[]\ TYPE = \hidden\ VALUE=\Peach\; At that point, if you call: echo $kcompany[1]; after the form submit, you'll get Banana. HTH! -- Mike Johnson

Re: Another ./CONFIGURE issue

Here is the contents of the err log: 050311 12:12:08 mysqld started 050311 12:12:08 [ERROR] Can't start server : Bind on unix socket: Permission denied 050311 12:12:08 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 050311 12:12:08 [ERROR] Aborting

Re: Fwd: ./configure issue

the server is shutting down. -- Original Message -- From: OpenView Mike To: mysql@lists.mysql.com Date: Friday, March 11, 2005 04:01:56 PM -0800 Subject: Fwd: ./configure issue Dear Sirs: I attempted another mysql install on an exact same system that failed, although

Re: Fwd2: ./configure issue

cabuov02:/tmp# ps -eaf | grep mysql root 14530 13637 0 12:36:16 pts/tb0:00 grep mysql cabuov02:/tmp# ll /tmp/mysql* /tmp/mysql* not found But there was a pid file: /var/opt/mysql/hvu03931.pid So, I renamed it, and tried starting mysqld again - it still fails. Michael [EMAIL

Re: Another ./CONFIGURE issue

running, so there's already a socket. 2) mysql doesn't have permission to write to /tmp. As you've eliminated #1, #2 is the likely problem. If so, you'll need to fix that. Run chmod 1777 /tmp as root (or with sudo). Michael OpenView Mike wrote: Here is the contents of the err log: 050311

Fwd: ./configure issue

/data STOPPING server from pid file /opt/apps/mysql/data/cabuov02.pid 050311 12:12:08 mysqld ended Any insight you could give me on this matter would be HIGHLY APPRECIATED, and thanks! Stay Strong, Michael OpenView Mike Stoller Walt Disney Studios IPNS West Enterprise Management Team

./configure issue

/data STOPPING server from pid file /opt/apps/mysql/data/cabuov02.pid 050311 12:12:08 mysqld ended Any insight you could give me on this matter would be HIGHLY APPRECIATED, and thanks! Stay Strong, Michael OpenView Mike Stoller Walt Disney Studios IPNS West Enterprise Management Team

Re: Correct way to use innodb_file_per_table?

/db/mysql/MyDatabase/MyTable1.ibd, /var/db/mysql/MyDatabase/MyTable2.ibd, etc it sounds like. Is there a way to split those table files? So I could have something like /data/disk1/MyTable1.ibd, /data/disk2/MyTable2.ibd? Thanks for your help. Mike -- MySQL General Mailing List For list archives

Correct way to use innodb_file_per_table?

, current ibdata file is about 25 gb. Thanks for any pointers. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: timediff and subtime: when is the result negativ?

This is not surprising behaviour. If you subtract 12 from 10, you get -2 every time. If you want your result to be positive, make it the first parameter and subtract the smaller (earlier) time from it. If your result is negative, then you know you have crossed into another day (13:00:00 -

Re: Effect of VARCHAR length?

I've just been wondering if the length parameter of a VARCHAR column has any effect on storage efficiency or space requirements. Afaik, VARCHAR columns only store the amount of data actually written into them and require no significantly more memory. So to be especially flexible with a

Re: Effect of VARCHAR length?

I'm just curious to know if the length of the indexes on a varchar column work in the same way or if they have a fixed lenght. anybody knows ? I don't see how they could be fixed length, since VARCHAR itself is not fixed-length. Ergo, it makes sense that the prefix limitation is the upper

Re: Avoiding filesort #2

- Original Message - From: Homam S.A. [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: February 22, 2005 8:12 PM Subject: Avoiding filesort #2 Actually with the query below it does avoid filesort, but once I use anything other than the equal operator (e.g. ColC 5), it reverts back

Re: Avoiding filesort #2

. This could confuse the index selection process and have MySQL decide to use no index in some situations. Mike - Original Message - From: Homam S.A. [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: February 22, 2005 8:12 PM Subject: Avoiding filesort #2 Actually with the query below

Re: how to write this query?

SELECT start_date, end_date, DATEDIFF(end_date, start_date) - (WEEK(end_date) - WEEK(start_date)) * 2 AS business_days FROM DateDiffs ORDER BY start_date; +-+-+---+ | start_date | end_date|

Re: how to write this query?

On Sat, 19 Feb 2005 14:01:05 +, Jerry Swanson [EMAIL PROTECTED] wrote: I have two dates (start_date, end_date). Datediff() function returns difference in days. I need the difference but not including Satuday and Sunday. Any ideas? C:\Program Files\MySQL\MySQL Server 4.1\binmysql -utest

Re: Question!

I was wondering if you could tell me of three or four alternative software options that can be used for this middle layer. What are the costs involved with any of these. Also if you could supply me with a sample script for inserting data using these alternative scripting languages, as I have

Re: select only values 0

Dear All, from a single row of a table, I have to select only the column, which have a value larger '0' into an outfile. How can I manage it with 'select'? Thanks, Jan SELECT CASE can do that sort of thing for you. Here's a simplistic example: CREATE TABLE `test` ( `i1` int,

RE: LOAD DATA INFILE Opposite

to donwload? Thanks for your help SELECT ... INTO OUTFILE is what you want. It's sort of covered in the SELECT syntax documentation: http://dev.mysql.com/doc/mysql/en/select.html Pretty handy at times. HTH! -- Mike Johnson Smarter Living, Inc. Web Developer

optimize table and replication failure

on the slaves. I just want replication to continue. MySQL versions 4.1.7 on the master, 4.1.9 on the slave. Thanks. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Barcode

Arthur Maloney wrote: Hello mysql, Scanned Barcodes I will be scanning barcodes and putting them into a innoDb table Does anybbody have knowledge re: the best columnType, length or other properties etc Generally bar codes contain text or numbers and have specific length limitations.

RE: DATE problem

for. HTH! -- Mike Johnson Smarter Living, Inc. Web Developerwww.smartertravel.com [EMAIL PROTECTED] (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Export database to XML/UML/Webpage?

Hello, I am looking to export a mysql database to a gui type interface. Basically i'm looking at a big database and I wanna dump it to a webpage/uml where I can add notes on what each table is and what it does, even just dumping to a webpage would be fine cause i can edit from there. is

MySQL Windows Bot Alert - Secure Your Servers

. If not, take the necesscary steps now to ensure that your system is not infected. -- Mike Hillyer, Technical Writer MySQL AB, www.mysql.com Office: +1 403-380-6535 Mobile: +1 403-330-0870 MySQL User Conference (Santa Clara CA, 18-21 April 2005) Early registration until February 28: www.mysqluc.com

Need help forming SQL query

= updatehistory.member_id_editor ORDER BY email.email_address; How would I get the emails for every member who does NOT have a row in updatehistory? ~ Mike - Mike Zornek Web Designer, Media Developer, Programmer and Geek Personal site: http://MikeZornek.com -- MySQL General Mailing List For list archives

Re: Need help forming SQL query

| text | | | | | ++--+--+-+-+ - Original Message - From: Mike Zornek [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, January 20, 2005 11:01 AM Subject: Need help forming SQL query

Estimating disk-space usage using LENGTH(BLOB)

shown above give a reasonable estimate of disk-space usage? Ta, -- Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Definition of password hashing algorithm in 4.1.7

, but the code is somewhat opaque. Is this algorithm native to MySQL or is it just an implementation of a published algorithm? Is it worth my time trying to track down the intriguing 'Monty' code mentioned in Util.java? Ta, -- Mike -- MySQL General Mailing List For list archives: http

Re: Definition of password hashing algorithm in 4.1.7

Mark Matthews wrote: [ ... ] Mike Moran wrote: I've been looking into what algorithm MySQL 4.1.7 uses for password hashing/encryption, with a view to ascertaining how secure it is. Does it conform to any combinations of published Specs e.g. MD5/SHA-1/etc? [ ... ] Mike, MySQL-4.1.7 uses SHA-1

Connect issue

that indicates a missing table / field. I wonder if anyone has any ideas ? Cheers, Mike !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Strict//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd; html xmlns=http://www.w3.org/1999/xhtml; head titleOur List of Jokes/title meta http-equiv=content-type content

ORDER BY sorting

ver. 4.0.20 TIA, -- Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://thunder-rain.com/ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Sum problem....

... Any suggestions? TIA! -- Cheers Mike Morton * * Tel: 905-465-1263 * Email: [EMAIL PROTECTED] * Indeed, it would not be an exaggeration to describe the history of the computer industry

<    1   2   3   4   5   6   7   8   9   10   >