RE: SQL wrapper for MySQL

Is there a program/project/software suite out there that traps/wraps MS SQL commands (or database calls/commands/etc) and wraps that into MySQL commands? I'd like to trick a program that requires SQL (MSDE). I'm not just talking about porting the data, but a run-time solution... I suppose

Going from 3.23 to 4 - sql statement errors

with 3.23, but doesn't with 4? The fields are varchar types, a few with default values. Considering there isn't anything that unusual, I'm having a hard time figuring this one out! :\ Thanks for any help! -Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Going from 3.23 to 4 - sql statement errors

that unusual, I'm having a hard time figuring this one out! :\ Thanks for any help! -Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Security

From: Mulugeta Maru [mailto:[EMAIL PROTECTED] Hi Mike, I am sorry for the confusion I might have caused. May be it would help to give a clear example. Table - Customers (CustomerID, CustomerName, Address, etc) Table - Transaction(TransactionID,CustomerID,Date,Amount) Note

RE: Query with IF acting wierd.

. It's worh a shot at least. 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: Query with IF acting wierd.

From: Mike Johnson SELECT main.id, IF(main.type,categories.name,items.name), IF(main.type,cat,item) AS type FROM main, IF(main.type,items,categories) WHERE IF(main.type,categories.id,items.id)=main.id; Oh, my mistake. I just realized I reversed items and categories in the IF clause

ANN: VBMySQLDirect API

. VBMySQLDirect is available at http://projects.vbmysql.com/vbmysqldirect 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]

RE: Security

client for limiting access to data in commonly-used tables. It begs the question why you're giving your clients access to the native mysql client itself rather than developing an application to do this, in which you could quite easily limit such access. -- Mike Johnson Web Developer Smarter Living

ANN: New VBMySQLDirect API

. VBMySQLDirect uses a more recent MySQL API as it's basis as well and therefore supports more recent functionality than MyVbQl. VBMySQLDirect is available at http://projects.vbmysql.com/vbmysqldirect Regards, Mike Hillyer www.vbmysql.com -- MySQL General Mailing List For list archives: http

RE: SQ puzzle

Of course the problem cannot be solved with M$ SQLServer :-) And why pray tell is that? I suppose if Vladimir and wife were very prolific then (4, 3, 3) will also work, which is 10 windows on the building, not 13 (9, 2, 2) I also happen to be one of those who have two children about 11

Re: quot;hotquot; innodb backup options

. -- Regards, Mike Hillyer Webmaster/Moderator http://www.vbmysql.com Read my blog at: http://www.vbmysql.com/mike/blog -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Can't enable replication !

in the master.info file - Any ideas would most excellent ! cheers Mike Rabbitt I.T. Applications Manager Legal Advice Bureau : 0845-055-0505 http://www.legaladvicebureau.co.uk This email and any files transmitted with it are confidential and intended solely for the attention and use

Disabling logging for connection

insert gueries to be logged. Best regards and please help Mike __ Do you Yahoo!? Yahoo! Mail SpamGuard - Read only the mail you want. http://antispam.yahoo.com/tools -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

RE: disabling optimizations to identify slow queries

/en/Query_Cache_Status_and_Maintenance.html And here: http://www.mysql.com/doc/en/SELECT.html 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

Encrypt data

running a server with RedHat 9.0/MySQL version 4.0.16. Thanks in advance, Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

run query second time

Hello Today I run large query. It took more than 1 minute to start printing the results. The output was about 5 rows. However, when I run the query second time it took a couple of seconds before printing the results. Why is that? Because data still in the RAM? Thanks

RE: How do I unsubscribe

From: Tim V [mailto:[EMAIL PROTECTED] How do I unsubscribe? This message should have a To unsubscribe link at the bottom (if you haven't already noticed it on every other message you receive). -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing

Re: Safe Database Problem

; -M From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Safe Database Problem Date: Fri, 13 Feb 2004 13:38:50 +0200 Mike Miller [EMAIL PROTECTED] wrote: Hi, I believe I've done everything from the book and have been fighting with the same problem for about 6 hours

order by: more that one field

Have some questions about Order By: Can a mysql query be order by more than one field? If this two queries will give different result or not? #1 select * from t1 Order by id, username; #2 select * from t2 Order by id _ Choose now

MySQL RPM Upgrade

Hello, we are currently running MySQL 4.0.15 w/InnoDB tables on a RH/Linux 9.0 and would like to upgrade. the current RPM's installed are: MySQL-client-4.0.15-0 MySQL-embedded-4.0.15-0 MySQL-devel-4.0.15-0 MySQL-shared-compat-4.0.15-0 MySQL-shared-4.0.15-0 MySQL-server-4.0.15-0

Safe Database Problem

Hi, I believe I've done everything from the book and have been fighting with the same problem for about 6 hours thus far. I just upgraded from MySQL 3.23.56 to 4.0.17. In the old system, I prevented show databases from ordinary users using skip-show-databases. In order to upgrade I used

Thread Stack

I receive the following warning in my hostname.err file after upgrading from 3.23.56 to 4.0.17. Any ideas what's causing it and how to fix it? Warning: Asked for 196608 thread stack, but got 126976 Trying to find the source- maybe a setting is too high? Linux 2.4.x Thanks in advance, -M

Re: Unique IDs

code it within your program. If this is in fact a primary key (whcih you seem to describe it as), then it should be distinct anyway. So do an INSERT IGNORE or even just an INSERT. It will fail upon duplicates. Check the affected rows or the insert_id (using whatever API you use to access

Re: MySQL RPM Upgrade

Thx' Alex. do the old RPM's need to be removed first before upgrading ?? -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Quality Web Hosting http://www.justlightening.net MSN:

Re: Connect to MySQL via PHP

The _only_ real benefit of Apache2 over Apache1 is it's thread-based model. So why leave a stable, tried-and-true, robust Apache1 platform for no additional benefits at all? Why break compatibility? Why use the Apache2 branch if you don't need it? PHP itself works quite fine in a threaded

RPM upgrade

Hello, we are currently running MySQL 4.0.15 w/InnoDB tables on a RH/Linux 9.0 and would like to upgrade. the current RPM's installed are: MySQL-client-4.0.15-0 MySQL-embedded-4.0.15-0 MySQL-devel-4.0.15-0 MySQL-shared-compat-4.0.15-0 MySQL-shared-4.0.15-0 MySQL-server-4.0.15-0

Re: There has to be a way to do this

with what is returned. Neither 0 or count(*) 0 seem to work. So, does anyone have an idea as to what I need to put in for the comparison? Mike From: gerald_clark [EMAIL PROTECTED] Date: Mon, 09 Feb 2004 14:28:27 -0600 To: Mike Tuller [EMAIL PROTECTED] Cc: MySql List [EMAIL PROTECTED

There has to be a way to do this

a way to go about this in SQL, or in a shell script? I don't want to do it in Perl or PHP. Thanks, Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: There has to be a way to do this

though. This is the same problem I had when I tried to do it this way, but I am not knowledgeable in shell scripting yet to know what I am doing wrong. From: gerald_clark [EMAIL PROTECTED] Date: Mon, 09 Feb 2004 11:11:24 -0600 To: Mike Tuller [EMAIL PROTECTED] Cc: MySql List [EMAIL PROTECTED

Re: There has to be a way to do this

the line for RESULT=, and then did echo $RESULT. It returns nothing. Not a 0 or a 1, nothing. From: gerald_clark [EMAIL PROTECTED] Date: Mon, 09 Feb 2004 14:28:27 -0600 To: Mike Tuller [EMAIL PROTECTED] Cc: MySql List [EMAIL PROTECTED] Subject: Re: There has to be a way to do

maximum number of mysql connections and process

I have some general questions: #1 How many simultaneoulsy connection can mysql server handle? #2 Is there a limitation in how many processes can mysql handle? Thanks _ Keep up with high-tech trends here at Hook'd on Technology.

Re: replication: slave returns a 1236 error_code.

seemed to work - in any case there was no error 1236. My MySQL is 4.0.15-9, his is 4.0.17. My Linux is SuSE 8.2, his is 7.3 Any further thoughts, we are snookered at the moment and haven't got much of a notion what to do next (other than radical re-installations). Regards, Mike Anderson

RE: Error creating database

Make sure that you have persmission to create database. Check MySQL manual: http://www.mysql.com/doc/en/index.html From: mysql [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Error creating database Date: Sat, 7 Feb 2004 19:00:54 -0500 HI everyone: I am using a dual 800 MHz power mac G4 in

RE: Just simple question...

You can install MYSQL on your Windows machine and use this user interface for managing the database http://www.mysql.com/downloads/mysqlcc.html From: Dusan Spisak [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Just simple question... Date: Fri, 06 Feb 2004 16:03:23 +0100 Hello everybody! I

RE: What field lengths to use

the records going in the column are 10 characters, use a CHAR(10): http://www.mysql.com/doc/en/CHAR.html HTH! -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539

RE: Just simple question...

. However, if you're turned off by having to either work on the command-line console or run a local webserver to use a GUI, I can't say that MySQL is necessarily what you're looking for. Good luck in your decision, though. -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539

RE: Query matching

, pages.mls_4, pages.mls_5, pages.mls_6, pages.mls_7, pages.mls_8, pages.mls_9, pages.mls_10, pages.mls_11, pages.mls_12 ); -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com

RE: What replaces IN?

supported for a while, but subselects have not. SELECT * FROM table1 WHERE item_id IN (1, 2, 3, 4, 5) should work, but not a subselect. I'm not sure of subselect syntax, actually, or what (recent) version in which it was introduced. -- Mike Johnson Web Developer Smarter Living, Inc. phone (617

If statement

if this is not the case? Mike Tuller -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Newbie query question...

') ^^ AND approved='1' ORDER BY year,month,day ASC Previously, it was going through all the ANDs and then saying oh, /or/ I can grab rows with a catid of 5 (hence the inclusion of that first row). HTH! -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL

RE: Mysql error message

today's and tomorrow's dates, respectively). Can you elaborate on the problem? Where do you get this error? -- 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

Replication

that database manually ??? Thanks for any tips. Regards Mike Anderson / Germany -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Oracle Question

will want things like rowids. You'll also have to write your own on-Login. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ERROR 1205: Lock wait timeout exceeded; Try restarting transaction

I did similar insert minutes ago with no problems. Now I try to do the same insert just with differnet parameters and got such error message. insert into users(first_name, last_name) values('john', 'smith'); ERROR 1205: Lock wait timeout exceeded; Try restarting transaction Any ideas how to fix

Create users : with password

','test', password('123456'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); and specy the password , I cannot login t the database [EMAIL PROTECTED] mike]# mysql -h localhost -u test -p Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES

Slave crashed: error 'The table 'users' is full' on query..

I have more than enough space on the box. At the beginnig I check table status and got no error messages. Any ideas what can cause such error. I use mysql 4-0.13. The documentation http://www.mysql.com/doc/en/Full_table.html refer to older version of mysql. Any ideas how to fix the problem?

Error: 1062 Duplicate Entry '252' for key 1

Hello The slave server stop working today and I looked to the error log and the the error message is Error: 1062 Duplicate Entry '252' for key 1 And than it shows the query and time when it happens. My question is why no error messages on master server just on slave server? As I understand ,

Are you willing to test a free product?

Our product, although written in .NET can be used to create anything, stored procedures, data objects, business object that map database tables to properties and so on. We support MySql, Microsoft SQL, DB2, Oracle and Access. We are very interested in supporting the MySql community and plan

RE: Read Slaves, and load balancing between them...

! -- 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: Read Slaves, and load balancing between them...

From: James [mailto:[EMAIL PROTECTED] Mike Andrew, Excellent ideas... The reason I am considering checking the log location, is because normal lusers will be using this software, so it won't be too good for them to see errors about the slave being out of synch. (Some 20 people

RE: Paging!

sort of frontend with this database? PHP, Perl, Java, etc? -- 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: Paging!

From: Mike Johnson From: Adel Ardalan [mailto:[EMAIL PROTECTED] When I select a rather large table to be shown, the rows are going very fast and I can't see the rows at the beginning. Also, I can't scroll up. How can I view the results page by page? I can only assume you're

RE: Paging!

From: Dan Greene [mailto:[EMAIL PROTECTED] another option is to set your pager option: mysql pager more then re-run your query Wow. You learn something new every day. Thanks! -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List

Re: Error: 1062 Duplicate Entry '252' for key 1

Thanks for explanation. But I don't insert anything at all to the SLAVE. It is 100%. Can the problem be problem be relative to Mysql 4.0.13 ? Thanks From: Jigal van Hemert [EMAIL PROTECTED] To: Mike Mapsnac [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Error: 1062 Duplicate Entry '252

RE: Error: 1062 Duplicate Entry '252' for key 1

From: Mike Mapsnac [mailto:[EMAIL PROTECTED] Thanks for explanation. But I don't insert anything at all to the SLAVE. It is 100%. Can the problem be problem be relative to Mysql 4.0.13 ? Thanks Out of curiosity, what's the data type of this column? -- Mike Johnson Web Developer

RE: HELP! Select queries for tables that has fields with # characters

with a column with a # in the name. However, have you tried enclosing the column name in backticks? SELECT * FROM table WHERE `FILE#`=1332; -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Error: 1062 Duplicate Entry '252' for key 1

| Thanks From: Jigal van Hemert [EMAIL PROTECTED] To: Mike Mapsnac [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Error: 1062 Duplicate Entry '252' for key 1 Date: Thu, 29 Jan 2004 14:32:51 +0100 From: Mike Mapsnac [EMAIL PROTECTED] The slave server stop working today and I looked to the error

Re: updates on slave server??

Is there a way to check that data on slave server is the same as data on master ? Thanks From: Paul DuBois [EMAIL PROTECTED] To: Mike Mapsnac [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: updates on slave server?? Date: Mon, 26 Jan 2004 21:58:42 -0600 At 0:49 + 1/27/04, Mike Mapsnac

Re: If Else statement

is the only way (or the best) I will have to upgrade the server. If there is another way to do the same thing, please let me know. Mike From: Egor Egorov [EMAIL PROTECTED] Date: Mon, 26 Jan 2004 15:40:54 +0200 To: [EMAIL PROTECTED] Subject: Re: If Else statement Mike Tuller [EMAIL

Index on a bit?

in its own TINYINT? Thanks for the advice! Mike Boone http://boonedocks.net/mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Database design, which is better

of smaller identical tables it would be a tradeoff of speed vs. complexity. Normalization can go a long wat to helping. Check out: http://www.vbmysql.com/articles/normalize.html Regards, Mike Hillyer www.vbmysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

How to do a check to see if I update or insert

I am stuck on this problem, and know there has to be a solution. I have a shell script, where I want to check to see if a record exists, and if it does then update the record with new information. If it doesn't then insert the information gathered by a script. How, in MySql, using a shell

updates on slave server??

Hello I found today that some data on slave server were different than on master server. I don’t know how that can happen. Slave server was running, show slave status show no errors If I make some updates on slave server. Does this updates will be reflected on master server? Or slave cannot

How to write such query?

I want to get distinct title from table titles. But there are two differnt titles (new and used).So I need somehow join all three tables where user_tiles status='true' and titles are distinctive. Thanks titles

temporary tables

Which of these three joins are using temporary table? # 1 Inner Join # 2 Left Join #3 Outer Join Thanks

If Else statement

I am trying write a shell script to check to see if a record exists and if it does, update information, and if it doesn't insert information. Is there a way to do an if else statement in MySql? I'm stuck on how to do this. I don't want to write it in perl. Mike -- MySQL General Mailing List

Select help

Hello I want to select from the table sum of logins for each day. For example: Date Logins 2004-01-22 10 2004-01-23 12 Any ideas if such select is possible? +--+--+ | Field| Type |

Left Outer Join?

What is the difference between Left Join and Left Outer Join? Thanks

Replace to update records

location='my location' WHERE ethernet_address='$ethernet_address Else INSERT hardware_assets (ethernet_address, location) VALUES ($ethernet_address, $location) Could someone help me finish these statements or show me a better way of doing this? Mike Tuller -- MySQL General Mailing List

Kill alter table process?

I run alter today on table with 380,000 records. 'Alter' was adding column to the table. It took 10 minutes and server load went up to 15. alter table info add column interactive_email enum('on','off') NOT NULL default 'on'; Here comes my questions: #1 If I kill the process after it was running

Re: Kill alter table process?

Thanks for good explnation. Some more questions: #1Does 'update' also create temporary table? #2What happend with old table after alter? From: mos [EMAIL PROTECTED] To: Mike Mapsnac [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Kill alter table process? Date: Wed, 21 Jan 2004 19:12:07

query syntax help

Hello all, I've been looking at this SQL query a dozen times or more, but keep getting a syntax error message, Query: SELECT ai.affilid,ai.create_date,CONCAT(ai.fname,' ',ai.lname) AS name,aw.siteid,ai.email,as.username,as.status FROM affiliate_info ai,affiliate_signup as,affiliate_website aw

Increment value

In the table value login_count is int(4). For example if value login_count equal to 3 and each time user login I want to increment by one. update customer set login_count='how? where id=12121212; What function I should use in order to icrement the value?

Re: query syntax help

Internet Solutions that work! http://www.thunder-rain.com Quality Web Hosting http://www.justlightening.net MSN: [EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Fred van Engen wrote: On Tue, Jan 20, 2004 at 04:10:44PM -0600, Mike Blezien wrote: I've been looking at this SQL query a dozen times

Re: Increment value

I know that. I'm lookign for mysql function that will increment the value. From: Tobias Asplund [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Mike Mapsnac [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Increment value Date: Tue, 20 Jan 2004 23:36:22 +0100 (CET) On Tue, 20 Jan 2004

Re: table info

: Mon, 19 Jan 2004 14:10:37 +0200 Mike Mapsnac [EMAIL PROTECTED] wrote: Is it possible to find out when the table was created? How to get information about the table? SHOW TABLE STATUS command provides info about table: http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html -- For technical

Re: Removing default MySQL install

Try using this command instead: rpm -e --nodeps (the RPM you want to remove) Eve Atley wrote: I've been trying to install a later version of MySQL (4.0.16). The Redhat default install is 3.x, and using rpm -e fails to remove the default packages due to 'dependencies'. How can I safely and

Re: Mysql Installation on Linux: ERROR 2002: Can't connect tolocal MySQL server

Weird. I cannot find the my.cnf (configuration file).. How that's possible? Thanks From: Victor Medina [EMAIL PROTECTED] To: Mike Mapsnac [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Mysql Installation on Linux: ERROR 2002: Can't connect tolocal MySQL server th Date: Sun, 18 Jan 2004

table info

Is it possible to find out when the table was created? How to get information about the table? Thanks

Mysql Installation on Linux: ERROR 2002: Can't connect to local MySQL server th

I just install MYSQL on Linux (Red Hat 9) using this manual:http://www.mysql.com/doc/en/Installing_binary.html Have no idea what's wrong. I looked on the mysql.log file and the file is empty. ERROR MESSAGE: [EMAIL PROTECTED] bin]# ./mysql ERROR 2002: Can't connect to local MySQL server through

RE: Selecting by date

-mm-dd hh:ii:ss stamp (whereas CURDATE() returns just -mm-dd). MySQL handles it silently just fine, but it's a good habit to get into. -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

RPM upgrades

Hello, we are in the process of upgrading our machine and currently running the following RPM's MySQL-server-4.0.15-0 MySQL-bench-4.0.15-0 MySQL-embedded-4.0.15-0 MySQL-devel-4.0.15-0 MySQL-client-4.0.15-0 MySQL-shared-compat-4.0.15-0 MySQL-shared-4.0.15-0 this is on a RH/Linux 7.3(i686) do we

grants for START/STOP SLAVE

SUPER that grants permissions for START/STOP SLAVE? Is this actually documented anywhere? Thanks in advance! -- 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

RE: grants for START/STOP SLAVE

From: Paul DuBois [mailto:[EMAIL PROTECTED] At 11:31 -0500 1/15/04, Mike Johnson wrote: This is in reference to 4.0.16, FWIW... I can't find any direct references to the actual grant permission for controlling a slave thread in the online docs. The closest I saw was the 5th paragraph

RE: Question about IF statements...

for any help! SELECT project_id, IF (SUM( time_worked ) '0.00', SUM( time_worked ),'NULL') AS total FROM time_daily WHERE user_id = 'clh' AND period_id = '27' AND total IS NOT NULL GROUP BY project_id; That should work, though I haven't tested it. -- Mike Johnson Web Developer Smarter Living

Re: Connecting to remote server

I have the user hardware set to be able to connect to the database from any host. That is why I am so confused as to why this doesn't work. Mike From: Andrew Boothman [EMAIL PROTECTED] Date: Wed, 14 Jan 2004 01:04:36 + To: Mike Tuller [EMAIL PROTECTED] Cc: MySql List [EMAIL PROTECTED

Replication errors

different character sets on databases. How do I check what the default character set is? Failing that... any other areas that might cause a similar problem. I've already tried set slave skip Rgds Mike E-mail: [EMAIL PROTECTED

RE: Moving Bookmark Table Data

, and import it. If you had indices on the original table, you'll have to manually create them on the new table -- CREATE TABLE ... SELECT FROM doesn't carry those over. HTH! -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list archives

RE: Using BETWEEN or = =

']} BETWEEN start AND end ; -- 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: Implement one statement w/o subqueries.

Properties P1 INNER JOIN Items I ON I.id=P1.Item INNER JOIN Properties P2 ON P2.Item=I.id WHERE P1.Name='Color' AND P1.Value='Gray'; -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: hierarchical records, I need some help!! ;(

I want to have all the items into a recorset with only one query like Select id, reference, component from NOMS where reference = '4' but i want not only the primary relations, i want all relations. Could somebody help a newbie like me? It can also help to change the way you look at the

Connecting to remote server

And then enter my password. What is the difference? Mike Tuller -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MYSQL problem

about PHP's planned interactions with MySQL. 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]

Optimization help

an index for Budget, knowing it shouldn't help, and it didn't. FWIW, the Webpage fields average about 5K characters, but can be as much as 40K. Mike Schienle, Custom Visuals http://www.customvisuals.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Optimization help

incident within a large date range. Since your query has a specific incident number, indexing that field would probably help a lot. Thanks for the help, Douglas. That was the ticket. We're back under a second for queries now. Mike Schienle, Custom Visuals http://www.customvisuals.com/ -- MySQL

RE: Strange ORDER BY question

: SELECT tablename.*, MemberLevels.description FROM tablename, MemberLevels WHERE tablename.MemberLevelRank=MemberLevels.rank ORDER BY MemberLevels.rank ASC; As said, I imagine the previous solution would be better, but it never hurts to suggest another way. :) -- Mike Johnson Web Developer

RE: Strange ORDER BY question(SOLUTION)

-Paying' DESC; Thanks again Mike! Thanks for posting it, actually, as I wasn't aware of that solution until your question prompted me to go looking. -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com

mysql.sock

What is the purpose of mysql.sock file in mysql? A lot of problems are assosiate with this file.

Re: Certification Question

have a nice certificate on my wall, a couple of MySQL pens in my drawer, some MySQL stickers on my monitor, and my daughter plays with the MySQL beachball (of course they may have changed the souveniers but I am sure you will get the certificate. Regards, Mike Hillyer www.vbmysql.com -- MySQL

Ann: New article at www.vbmysql.com

be useful even to those who do not use VB as their language of choice. I hope you like it! 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]

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