If statement in a where query....

this logic using an if statement in the where statement? TIA! -- Cheers Mike Morton * * Tel: 905-465-1263 * Email: [EMAIL PROTECTED] * Indeed, it would not be an exaggeration to describe

Select member when it meets two requirements

| | ++---+--+-+-+--- -+ How would I select all distinct member_id that have a specialty_id of 6 and 33? Thanks! ~ Mike - Mike Zornek Web Designer, Media Developer, Programmer and Geek Personal site: http://MikeZornek.com

SQL question.... Trying to improve upon my PHP solution.

seconds but this machine is faster than server. Is there a simpler / faster SQL query I could use? Thanks! ~ Mike - Mike Zornek Web Designer, Media Developer, Programmer and Geek Personal site: http://MikeZornek.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: SQL question.... Trying to improve upon my PHP solution.

On 11/29/04 12:27 PM, mos [EMAIL PROTECTED] wrote: Mike, Your solution is way too complicated (it makes my head hurt).g Try this: set @n=0; update tmp set rnd = @n := @n + 1 order by RAND() Mike I'll give this a shot. Follow-up question: I've had a lot of trouble with RAND

Re: SQL question.... Trying to improve upon my PHP solution.

. Our idea is to nightly order the members at random and when showing results. I call this shuffling only to make the metaphor. I really mean setting randomized values in a extra column which will be sorted when the user asks for random results. Thanks for you help. ~ Mike - Mike Zornek Web

Re: Delete duplicate records

Manish wrote: I have got few duplicate record in my DB as follows.- Let's say record_no is the unique id of duplicate records. So I have fields ID, record_no , X and Y. (ID is a dif filed and is a primary key) To find duplicates I do following - select record_no,count(record_no) from mytable group

temporary tables, replication, and innodb tables

is to increase innodb_lock_wait_timeout to a large enough value that it will be longer than any potential select for the temporary table? All innodb tables, MySQL 4.1.7 for both master and slaves. Thanks. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

RE: What's MYSQL equivalent to Oracle's TRUNC(date_time_var)?

, you can use DATE(date_time_var) to return the date portion. HTH! -- Mike Johnson Smarter Living, Inc. Web Developerwww.smarterliving.com [EMAIL PROTECTED] (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

RE: Suppress the 0 value

the result from the select is 0 it should be NULL). How can this be done within the select-statement? SELECT IF(id = 1, NULL, id) AS id ... The usage of IF() is IF(expression, true value, false value). -- Mike Johnson Smarter Living, Inc. Web Developerwww.smarterliving.com

RE: Suppress the 0 value

From: Mike Johnson [mailto:[EMAIL PROTECTED] From: Martin Rytz [mailto:[EMAIL PROTECTED] Hi MySQL-Users I have a simple select statement like 'select id from table'. The result is 0, becaues the id field is 0 (int-field). My problem is now how to suppress the 0 and give NULL

RE: Help with a DATETIME Query Please Using 3.23.54

(B.Booking_Start_Date)) / (60 * 60); Given values of '2004-11-01 10:00:00' and '2004-10-31 09:00:00', you end up with 25 (which I think is what you were looking for, not 24). As I said, there may be a more elegant way to do that, but this is the brute-force method that should work. HTH! -- Mike Johnson

Can't connect

I am trying to connect from my windows box at home using mysql.exe to a MySQL server at work on a Gentoo box. My command line is: mysql -h host.domain.com -u root -p (of course the host.domain.com is replaced with my server's FQDM) The output is: ERROR 2003: Can't connect to MySQL server

Fwd: Very slow query

The didn't show up on the list 2 days after posting it, so I'm posting it again. -- Forwarded message -- From: Mike Wexler [EMAIL PROTECTED] Date: Fri, 22 Oct 2004 14:39:49 -0700 Subject: Very slow query To: [EMAIL PROTECTED] The following query: CREATE TEMPORARY TABLE

Re: Sharing databases between win and linux

I also share databases Linux to XP. It could be an uppercase/lowercase issue, try adding to my.cnf: lower_case_table_names=1 Lau Sennels wrote: Hello. I am trying to set up a MySQL database shared between SuSE 9.1 and a Win XP (both 4.0.18 from binary). The database resides on a FAT32 partiton

query cache derived table

cachable. Can anybody help steer me to the general steps required to add this functionality? Thanks Sorry if I have duplicated my post, not sure if first attempt was delivered due to spam controls. -- Mike McMahon [EMAIL PROTECTED] ActiveWire 410-547-8277 x610 -- MySQL General Mailing List

RE: Converting date in MySQL

error-checking, anyway. -- Mike Johnson Smarter Living, Inc. Web Developerwww.smarterliving.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]

auto increment fields

hi. I have a rather childish question on tables and auto increment fields. Scenario: I have a table with an int auto increment primary key field. The deal is that everything works fine (I'm talking about the auto incrementation part) until I choose to delete a row. This creates a gap in the

About Mysql Security

Hi, Last week, the all tables in one database had been deleted, which is second times since I upgrade my operation system from NT 4.0 to Server 2003. Before that, they had been deleted many times. I just copied all table files to one database(one directory). They will work normally. I don't know

Re: Fulltext doesn't seem to find certain text

. Since you are using MySQL 3.23, you will need to recompile the binaries. With MySQL 4.x, you can simply change a variable in the configuration file and rebuild the fulltext indexes. Mike What variable setting is changed in the my.cnf, and is this under the mysqld group ?? What is the proceedure

Re: Problem with Replication - Slave Option replicate-ignore-tabl e and replicate-wild-ignore-table

-table=db.table1 replicate-ignore-table=db.table2 ... replicate-ignore-table=db.tablen And remove the other statements? -Original Message- From: Mike Lohman To: [EMAIL PROTECTED] Sent: 9/10/04 10:53 AM Subject: Problem with Replication - Slave Option replicate-ignore-table and replicate-wild

Open Source Survey

you share this information with them? Thanks. Mike Chan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem with Replication - Slave Option replicate-ignore-table and replicate-wild-ignore-table

sec) Thanks in advance. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Tricky Date Query

Michael, Michael Stassen wrote: Mike Blezien wrote: Hello, Not sure this is possible to do with SQL or if needs to be done with in the application programming language we're using(Perl), but I need to get the a weekdate, IE SELECT EXTRACT(DAY FROM NOW()) which would return 30 Now what I need

Tricky Date Query

Hello, Not sure this is possible to do with SQL or if needs to be done with in the application programming language we're using(Perl), but I need to get the a weekdate, IE SELECT EXTRACT(DAY FROM NOW()) which would return 30 Now what I need to do, is if the query above is greater or less then

Re: OT Gmail

Miles Keaton wrote: I have 7 invitations to give away. Feel free to ask, but include a sentence about why you want it. I have 6 invitations to give away. Available to the first 6 who ask. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Mysql command line queries not working....

without comments, as removing them every time there is a new dump will be tedious to say the least... 3. Am I a total idiot and have missed something dead simple? TIA! -- Cheers Mike Morton * * Tel: 905-465-1263 * Email: [EMAIL PROTECTED

Re: Mysql command line queries not working....

Message- From: Mike Morton To: [EMAIL PROTECTED] Sent: 8/26/04 12:05 PM Subject: Mysql command line queries not working I know the subject is not totally descriptive of the problem, but: mysql -h -u *** -p*** mikerocks latest_distribution.sql Is producing no results

RE: Sanity Check : Error in sql

in your code. It sounds like it's essentially generating this query: Select * from Education_table where TypeID = HS; instead of... Select * from Education_table where TypeID = 'HS'; HTH! -- Mike Johnson Smarter Living, Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: A new Machine

Chris McKeever wrote: On Sat, 21 Aug 2004 10:18:06 -0700, Info [EMAIL PROTECTED] wrote: After 2 days in Microsoft HELL with my SQLsvr databases, I'm ready to rob the piggy bank and build a new linux mysql server. Here's my problem: I have, at present, two rather large databases. (A:

Re: A new Machine

Chris McKeever wrote: RAID 5 is the wrong answer. If reliability is a big deal do mirroring. Otherwise get as much memory as you can afford and use any money left over to get the fastest disk drives you can afford. If you have multiple disks, spread things between different drives. OS on

Re: mysql 4.0.20 uses just one CPU on Gentoo (now: glibc patches)

Thanks Pete! I just recompiled mysql with the emerge installer with all gentoo.org patches - same result. Just one CPU works. I'll report BUG to both mysql AB and Gentoo. Thanks Mike Pete Harlan wrote: It would be nice if the manual were updated to say something about it, but here's

Re: mysql 4.0.20 uses just one CPU on Gentoo

Yes, of course - I started from mysql binary and compiled the new one only when it failed. It was in the beginning of the thread BTW - it compiled on Gentoo without a problem. Just emerge mysql-4.0.20.ebuild and it runs till the end. And works fine - but again - only on one CPU. Mike Donny

mysql 4.0.20 uses just one CPU on Gentoo

! -- == Mike Blazer [EMAIL PROTECTED] == -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql 4.0.20 uses just one CPU on Gentoo

Mike Blazer wrote: In addition to my previous posting - on this machine I have glibc.2.3.2 which was installed using the Gentoo emerge native installer. Dunno, the mysql manual says a lot about various bugs and patches for glibc (that influence the threads behavior) but it is all up to 2.2.2

Re: Importing from plain text?

It sounds like you want the LOAD DATA function, found at http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html As long as there is some wat of distinguishing the two fields in the file, you can load them into MySQL. Mike Hillyer Robin Lynn Frank wrote: -BEGIN PGP SIGNED MESSAGE- Hash

RE: distinct based on two fields--please help

1 B 50 2 How do I do this with one sql query? Thanks. SELECT name, SUM(price), type FROM tablename GROUP BY name, type; -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

RE: Finding duplicate values in a column

date_created, COUNT(*) AS num FROM tablename GROUP BY date_created HAVING num 1; HTH! -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Finding duplicate values in a column

From: Mike Johnson From: Robert Reed [mailto:[EMAIL PROTECTED] This seems like it should be easy, and I'd be happy for a simple reference to where in the manual or in Paul's book I can find the answer. I am wanting to find basically the inverse of a SELECT DISTINCT operation. I

Query Possible

Hello, MySQL version 4.0.20 I'm trying to figure out, if it's possible to do, with one query to update a single table. Query #1 select m.memid from members m left join active a on a.memid = m.memid where a.acct_days 0 and m.account = 1; Query # 2 update members set account = 2 where memid in

Re: Query Possible

Mike Blezien wrote: Hello, MySQL version 4.0.20 I'm trying to figure out, if it's possible to do, with one query to update a single table. Query #1 select m.memid from members m left join active a on a.memid = m.memid where a.acct_days 0 and m.account = 1; Query # 2 update members set account

MySQL Authentication Scheme Bypass

Hello, Happen to come accross this articale http://www.securiteam.com/unixfocus/5BP0420DFQ.html and was wondering, using 4.0.20, if we need to make some changes or has this been addressed by MySQL staff ?? TIA, -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet

DISTINCT issues with 3.23.54

this on MySQL 3.23.54-log I get 78 rows, with many dups. When I move the DB to MySQL 4.0.18-standard and run the query I get 21 rows, no dups. Is this a known bug? Is there any work around, besides upgrading (which is planned but not immediately). Thanks! ~ Mike - Mike Zornek Web Designer, Media

Query last record in table

Hello, what is the most effecient way to query the last record in a table, if querying the primary key(acctid) column ?? I've tried select *,max(acctid) as lastid from subscribers where acctid = 'lastid' group by acctid but this returns nothing ?? TIA :) -- MikemickaloBlezien

[Fwd: Query last record in table]

cancel this, found my problem :) this query worked: SELECT * FROM subscribers ORDER BY acctid DESC LIMIT 1 Original Message Subject: Query last record in table Date: Mon, 05 Jul 2004 13:52:28 -0500 From: Mike Blezien [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Organization

RE: Auto Date selection and format

Michael/Wesley, Thanks for your help. You got me going in the right direction! Thanks again!!! Mike -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 7:37 PM To: Mike Koponick Cc: [EMAIL PROTECTED] Subject: Re: Auto Date selection

Packet Errors

Hello, I recently noticed this error in our mysql error log file: Aborted connection 5439 to db: 'database_name' user: 'someuser' host: `localhost' (Got an error reading communication packets)

Re: Packet Errors

variable. Those searchable docs are very handy for looking up error codes, etc. David. Mike Blezien wrote: Hello, I recently noticed this error in our mysql error log file: Aborted connection 5439 to db: 'database_name

Auto Date selection and format

? Also, I looked for a way to format the output date to MM/DD/YY rather than -MM-DD. Any suggestions? Thanks in advance. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: OUTFILE to CVS with headers

Bob, That did the trick! Thanks! Mike -Original Message- From: Bessares, Bob [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 6:03 PM To: [EMAIL PROTECTED]; Mike Koponick Subject: RE: OUTFILE to CVS with headers well, you can easily output into a comma separated file

OUTFILE to CVS with headers

by ',' optionally enclosed by '' escaped by '\\'; All the lines run together so it makes it impossible to import. Thanks in advance for your help. Mike This email and any files transmitted with it are confidential and intended solely for the use

Intel Compiler

. */ char mysql_error(); int main() { mysql_error() ; return 0; } -Mike _ Add photos to your messages with MSN Premium. Get 2 months FREE* http://join.msn.com/?pgmarket=en-capage=byoa/premxAPID=1994DI=1034SU=http://hotmail.com/encaHL

Re: MySQL Web Clustering...

tell client1 to use database5 as their hostname for example. Replication requires that updates go to the master, which requires client-side code, or an intermediate daemon which analyzes the statement and forwards the request. -Mike From: Peter J Milanese [EMAIL PROTECTED] To: Roy Nasser [EMAIL

Re: MySQL Web Clustering...

it seamless. Would require some work to make one though. -Mike From: Jeff Smelser [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: MySQL Web Clustering... Date: Fri, 18 Jun 2004 11:43:05 -0500 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 18 June 2004 11:05 am, Mike Miller wrote

RE: Create table syntax question

is a reserved word (an abbreviation of DESCRIBE, used to show a table structure). Either change the name of that column or wrap it in backticks (`DESC`) whenever it's referenced. HTH! -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list archives

Correcting Time

Hello, Somehow the mysql server time is set 3 hours earlier than the system time(CDT), is there a way to correct this so they both are the same ? TIA -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work!

RE: MySQL -- SQL syntax error.....

BUSINESS_CATEGORY.BUS_CAT_ID = '733788' -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Codes for U.S. Counties

I don't know if this will help, but I had these links left over from some work I did a few years ago... http://www.itl.nist.gov/fipspubs/fip6-4.htm http://www.itl.nist.gov/fipspubs/co-codes/states.htm On Wed, 2 Jun 2004, David Blomstrom wrote: I have a big database focusing on U.S.

Re: Initiate perl script in linux from a Windows VBA program

! Canada Personals Why wouldn't you just use ODBC to connect to the server and work directly? Remotely initiating a perl script would involve creating a telnet or SSH session from within Excel using VBA, which would be a far more complex undertaking. -- Mike Hillyer, Technical Writer MySQL AB

MySQL Warnings

Hello, Noticed this morning when restarting MySQL, saw this in the error log file: Version 4.0.20(RPM's) --- 040601 9:17:17 /usr/sbin/mysqld: Normal shutdown 040601 9:17:18 InnoDB: Starting shutdown... 040601 9:17:20 InnoDB: Shutdown completed 040601 9:17:20

Re: MySQL Warnings

thx's for the input :) Mike Jigal van Hemert wrote: From: Mike Blezien [EMAIL PROTECTED] 040601 9:17:20 Warning: Asked for 196608 thread stack, but got 126976 Is this type of Warning something to be concerned about or is this common or how best to fix ?? --quote from Sergei Golubchik [EMAIL

MySQL update 4.0.20 w/RPM's

Hello, got this error when upgrading our MySQL: rpm -Uvh MySQL-shared-4.0.20-0.i386.rpm Preparing...### [100%] file /usr/lib/libmysqlclient.so.12.0.0 from install of MySQL-shared-4.0.20-0 conflicts with file from package

RPM install upgrade error / ver. 4.0.20

Hello, got this error when updating our MySQL: rpm -Uvh MySQL-shared-4.0.20-0.i386.rpm Preparing...### [100%] file /usr/lib/libmysqlclient.so.12.0.0 from install of MySQL-shared-4.0.20-0 conflicts with file from package

RE: Very Strange data corruption

). That's why that's what's getting inserted. Manual page is here: http://dev.mysql.com/doc/mysql/en/Numeric_type_overview.html Try converting the column to a BIGINT, the signed max alone is 9223372036854775807. -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General

RE: Very Strange data corruption

if I'm wrong, but isn't it considered best practice to validate data before it gets to the database? I can't seem to find a source for this after a quick search on Google, though... -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list

RE: Very Strange data corruption

is actually updated on any INSERT or UPDATE, not just given a value on the initial INSERT. :) -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: outer join

, Scott Purcell -- Mike Hillyer, Technical Writer MySQL AB, www.mysql.com Office: +1 403-686- The Open Source movement has become a major force across the software industry, and MySQL is the world's most popular open source database. --Fortune Magazine -- MySQL General Mailing List For list

RE: php mysql problem

Sounds as though PHP was installed without the MySQL library. I haven't done it myself in a while, but I believe it requires the --with-mysql flag. HTH -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: GUID storage

I would say easiest is best. There is no specific field for uniqueidentifier. Mike Hillyer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Inverted Index Query Formulation

-in fulltext features of various databases. Any web links are appreciated. Surely there's a way to do this efficiently using SQL queries. Thanks! Mike Boone http://boonedocks.net/mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Change Character Set for one user

Hello, is it possible to change the default character set for one mysql user without affecting the global character set setting, via the the user's .my.cnf option file ?? thx's -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet

Change Character Set

Hello, is it possible to change the default character set for one mysql user without affecting the mysql global character set setting, via the the user's .my.cnf option file ?? thx's -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing

Error: Too many open files

Hello, this maybe a more related issue with DBI API but I thought I try first posting here to see why we would be getting this error (24) - Too many open files Error Message: DBD::mysql::st execute failed: File './mysql/user.MYD' not found (Errcode: 24) What would be causing this type of

RE: Need correct 'order by' syntax where field does not contain NULL

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

RE: WHERE clause problem

while it may look like it makes sense in pseudo-code, on paper it's not how MySQL evaluates things. It builds the right side of the equality and then compares. Stick with your second query and you'll be fine, even if it is more typing. ;) HTH! -- Mike Johnson Web Developer Smarter Living

RE: urban myth?

. If this is documented online, I've yet to see it (though I haven't exactly gone looking for it). Someone else may have a more accurate description of the way it's done, though. -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list archives: http

mySQL error 1016

Hello, Trying to fix this problem mySQL error 1016 I found this at the InnoDB site. Another symptom of an out-of-sync data dictionary is that MySQL prints an error that it cannot open a file

Repair tables

Hello, What is the recommend alternative to REPAIR TABLE for InnoDB tables, this does not work with Innodb table types ?? TIA -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com

RE: Query help

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

RE: re-using a results set

From: Scott Swaim [mailto:[EMAIL PROTECTED] Thank you Chris for that answer. I did not know if it was a mysql problem or php problem. Again I apologize (especially to Mike Johsnon) for the multiple request. I was getting a return error on the list and I thought it was a configuration

Re: MySQL Website

FYI... Just connected to the www.mysql.com site this morning with no problems :) -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Quality Web Hosting http://www.justlightening.net

RE: If() syntax question

From: Don Dachner [mailto:[EMAIL PROTECTED] Is it possible to do something like this? If(select * from xxx, if record found..update it, if record not found ..insert it) Try the REPLACE INTO syntax: http://dev.mysql.com/doc/mysql/en/REPLACE.html -- Mike Johnson Web Developer Smarter

RE: re-using a results set

provide more details for your situation? Your code is a bit jumbled. We have no idea what pv() does, for instance. Nor db_query(). These are not standard PHP functions, so you'll have to forgive us if we're all a bit clueless and unwilling to help. -- Mike Johnson Web Developer Smarter Living, Inc

Re: Learning curve

and FM? I agree with standing on the shoulders of giants when it comes to developing new custom systems. Hey! I just saw you're living squarebanks, I used to live there too. How long have you lived there? How's the weather today? -Mike Caskey Joshua J. Kugler wrote: Mike - You didn't indicate

Re: Learning curve

Thanks for the info Daniel, Could you maybe link me to some of the projects you've seen for uploading images too? -Mike Caskey Daniel Kasak wrote: Mike T. Caskey wrote: Hi all! I'm wondering if anyone can help me find out how much time/training is needed to accomplish my task using MySQL

Re: Learning curve

resource for MySQL/PHP? Are there any good classroom-based training companies that don't charge an arm and a leg? Thanks, Mike Caskey Eric Frazier wrote: Hi, There is an alterative to the web/php type interface. It is only worthwhile if you already have some one with decent Access knowledge. Access

Re: Learning curve

Peter, I really appreciate your offer to help out! Since I'm fairly fresh in the area, I appreciate any help I can get. Can you recomend any formal online training resources for MySQL/PHP? Thanks, Mike Caskey Peter Lovatt wrote: Hi I would echo this. We are finding that applications based

Re: Learning curve

online where I might be reminded of the essential questions? I'm obviously wet behind the ears in this arena and have a lot of learning to do in many areas... project management, evaluation, development, testing, etc... Any information you can offer is priceless for me! Thanks, Mike Caskey

Group by for datetime

) Or something along those lines? 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

Learning curve

? I appreciate your time and information! Thanks, Mike T. Caskey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Long numbers

I think your looking for the ROUND(N,D) function, IE: select round('3.4285714285714',2) as miles; 3.43 miles MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Quality Web Hosting

ANN: uc2004.vbmysql.com - Conference Blog Collection and Image Gallery

encourage you to post your photos in the gallery. I hope everyone can benefit from this! Regards, Mike Hillyer www.vbmysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

myodbc - ms-access problem: table contents not shown

-view. This may as well be a generic ms-access problem or a codeweavers bug, but I can't find the anwer. Is there anyone on this list who known how to solve the problem? Thanks in advance. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Can't connect (error 2003) to mysql 5.0 on other server

) 13:50:32.732570 mycompA.mysql mycompBt.33431: R 0:0(0) ack 2312810185 win 0 (DF) Any suggestions? Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can't connect (error 2003) to mysql 5.0 on other server

Bingo!! With the installation of the 5.0 (I assume) skip-networking was set by default in /etc/mysql/my.cnf. That was it. Thanks. Mike I assume you have already verified that the mysql server is actually running on server A. Have you verified that server A is accepting tcp connections? Try

Calculation in a mysql column

I am using mysql 4.0.16. Is it possible to put a calculation of two other columns as the default value for a third column? Like: time = decimal 3,2 rate = decimal 3,2 totals = default is time * rate Thanks, -Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com

MySQL upgrade tips

Hello, we are currently running MySQL version 3.23.58, and plan to upgrade to 4.0.18 via the RPM's on a RH/Linux system,... can we retain all the user privileges and databases without loosing any data and our user privileges after the upgrade... we do have backups of all the databases. Is

Re: Transaction Not supported

] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Joshua J. Kugler wrote: Hmm...but it *should* work. DBI::mysql should implement those calls and transform them to BEGIN/COMMIT calls. I wonder why it doesn't. j- k- On Tuesday 30 March 2004 11:24 pm, Jonas Lindén said something like: Sorry Mike, Joshua is absolutly correct. Dont

MySQL 5.0 - What is really available?

I've downloaded and installed 5.0, it seems to be working fine. However, I need a graphical user interface to create tables and such (when I say I need, trust me, I need). I'm running on XP (that explains a lot I know) So: Is Control Center for 5.0 available? Is MyODBC 5.0 available? I'm having

Transaction Not supported

Hello, I keep getting this error when attempting to utilize a database that has Innodb tables, and using transactions. This is from a Perl/DBI script too: Error: Transactions not supported by database at module. bla..bla I realize this maybe a DBI question, but I thought I'd check here

RE: Going from 3.23 to 4 - sql statement errors

= '$cust_comments_edit', customer_id = '$customer_id_edit', shared = '$shared_edit', ip_address = '$ip_address_edit', server_name = '$server_name_edit', site_id = '$site_id_edit', host_price = '$host_price_edit' WHERE domain = '$domainhosted' -Mike -Original Message- From: Victoria Reznichenko [mailto

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