MySQL Windows Bot Alert - Secure Your Servers

d restarting the server. You can still connect via named pipes on an NT based system. If your server is behind a firewall, and you have a strong root password you are not vulnerible to this worm. If not, take the necesscary steps now to ensure that your system is not infected. -- Mike

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: 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 MyS

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 Mailin

Re: GUID storage

case 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]

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

ce, and I 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]

ANN: VBMySQLDirect API

yVbQl. 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]

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:

Ann: New article at www.vbmysql.com

t and should 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]

Ann: New Article At vbmysql.com!

For Windows package and also covers opening and closing SSH tunnels from within Visual Basic. In any case, I hope you find these of use! 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: Functions and Procedures in Mysql

You are correct. I interpreted "Function or a procedure" to be the questioner referring to stored procedures with two seperate terms. Mike Hillyer > -Original Message- > From: Dan Nelson [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 25, 2003 8:06 PM >

What is your hourly rate?

I know this is a little off-topic, but I have been approached to do some consulting to move an ISAM based app to MySQL. The potential customer is asking an hourly rate but as I have not done MySQL work as a consultant I am not sure what to charge. Any Ideas? Thanks, Mike Hillyer www.vbmysql.com

LEFT JOIN question

Hi all; I was given a query today of the following: SELECT record_id, record_title,artist_name,label_name,record_catalog FROM record_profile LEFT JOIN artist_profile,label_profile ON record_profile.artist_id = artist_profile.artist_id OR record_profile.label_id = label_profile.label_id GROUP BY r

RE: Question about InnoDB and external locking

At this point it is pure academic curiousity. I am putting together a cheap cluster to play with shared drive failover, and thought I would see what happens when I point two MySQL machines at the same drive while I'm at it. Mike > -Original Message- > From: Jeremy Zawodny [mailto:[EMAIL P

Question about InnoDB and external locking

a shared disk cluster? If not, would this ever be on a to-do list or is it too much trouble to implement? Thanks, Mike Hillyer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Has the list gone down...

Well, I saw your message. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Jay Blanchard [mailto:[EMAIL PROTECTED] > Sent: Monday, September 08, 2003 7:46 AM > To: [EMAIL PROTECTED] > Subject: Has the list gone down... > > > I haven't got

RE: Innodb multiple tablespaces

And will you be making your deadline? ;) > -Original Message- > From: Heikki Tuuri [mailto:[EMAIL PROTECTED] > Sent: Monday, September 08, 2003 10:38 AM > To: [EMAIL PROTECTED] > Subject: Re: Innodb multiple tablespaces > > > Sean, > > I am at this very moment programming them :). The d

RE: Backing up all MySQL DBs

Sure, use the --all-databases option instead of $DBNAME http://www.mysql.com/doc/en/mysqldump.html Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: René Mølsted [mailto:[EMAIL PROTECTED] > Sent: Monday, September 08, 2003 11:51 AM > To: [EMAIL PROTECTE

RE: Difference between Serializable and Repeatable Read with InnoDB

Conceptually, SERIALIZABLE just adds LOCK IN SHARE MODE to every SELECT query. Other than that there is not much difference. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Bill Todd [mailto:[EMAIL PROTECTED] > Sent: Monday, September 08, 2003 7:13 PM >

Re: How to Ask Questions the Smart Way...

After a few too many bad questions, I wrote something on a similar vein, but a little shorter: http://www.vbmysql.com/mike/blog/archives/11.php Regards, Mike Hillyer www.vbmysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

New Article on SET Datatype

. Thanks, 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: Regular expresion replace possibility?

You have to search for 'string functions' to find it. Problem is that a search for REPLACE will bring up the REPLACE syntax, not the REPLACE() syntax (not the brackets ;-) ) Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Dean Householder [mailto:

RE: Regular expresion replace possibility?

UPDATE mytable SET mytext = REPLACE(mytext,'"',''); Assuming you wised to strip a double quote, modify to suit. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Dean Householder [mailto:[EMAIL PROTECTED] > Sent: Monday, July 21, 2

RE: RESETTING AUTO_INCREMENT

way you can prevent some potential conflicts. You can reset the auto_increment with ALTER TABLE tablename AUTO_INCREMENT = 1; but know what you are doing when you do. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Miguel Perez [mailto:[EMAIL PROTECTED]

RE: Is it possible to dump images into a database?

Yes it is. If you are using VB look at www.vbmysql.com/articles/blobaccessvb.html Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Dan Anderson [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 09, 2003 8:49 AM > To: [EMAIL PROTECTED] > Subject: Is it p

RE: Can mysql handle this load?

the invoice number will not be unique, and the detail number will not be unique, but the combination of the two will be). As for question #2, if two fields, one on each table, will be used to join tables together, both fields should be indexed. Regards, Mike Hillyer www.vbmysql.com

RE: NAS vs SAN for data directory

Well, I would avoid NAS as it introduces unwanted overhead when accessing the data. As for SAN versus the internal RAID5, I am not sure, I would say benchmark the two and see which comes out better, or wait to see if there is anyone out there that has dealt with both. Regards, Mike Hillyer

RE: Newbie questions (3) - listeners / BLOB / PHP

No Yes www.php.net Regards, Mike Hillyer > -Original Message- > From: Jeremy [mailto:[EMAIL PROTECTED] > Sent: Monday, July 07, 2003 1:49 PM > To: [EMAIL PROTECTED] > Subject: Newbie questions (3) - listeners / BLOB / PHP > > > Hi I'm from an Oracle b

RE: My query string might be too long

Well, I have sent queries over 4 times as long without difficulty, so I do not think you are coming up against a limit on query length. I would not use MySQL 5 for any production or even development machines, as a development tree is not even guaranteed to work. Regards, Mike Hillyer

RE: Having MySQL Server and databases on different computers

degraded though. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Aleksandr Zingorenko [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 02, 2003 11:05 AM > To: [EMAIL PROTECTED] > Subject: Having MySQL Server and databases on different computers > >

RE: Newbie SELECT problem

sti_tracking WHERE sessionID IN (SELECT DISTINCT sessionID FROM sti_tracking WHERE userID = 99); Assuming you have MySQL 4.1 that is (which supports subselects). Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Tim Winters [mailto:[EMAIL PROTECTED] > Sent:

RE: More tables or more joins

ease. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Jackson Miller [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 02, 2003 10:47 AM > To: Jake Johnson > Cc: [EMAIL PROTECTED] > Subject: Re: More tables or more joins > > > I appreci

RE: Count Rows?

If your table is MyISAM, then SELECT COUNT(*) FROM tablename Will return a rowcount without a major performance hit as the rowcount is stored and a table scan is not needed. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Roy W [mailto:[EMAIL PROTECTED]

RE: Help with privilege tables - IMPORTANT

That is my conclusion as well. I think you should post it as such barring any comments otherwise. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Twibell, Cory L [mailto:[EMAIL PROTECTED] > Sent: Monday, June 30, 2003 4:51 PM > To: Mike Hillyer; [EMA

RE: Help with privilege tables - IMPORTANT

Hmm, if you have UPDATE privilege on A and SELECT on A and B then it should work. Do you have UPDATE granted on B (though I know you should not need it)? Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Twibell, Cory L [mailto:[EMAIL PROTECTED] > Sent: Monday

RE: Help with privilege tables - IMPORTANT

Well, with that in mind, does the user have the appropriate INSERT privileges? Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Twibell, Cory L [mailto:[EMAIL PROTECTED] > Sent: Monday, June 30, 2003 3:49 PM > To: Mike Hillyer; Twibell, Cory L; [EMA

RE: Help with privilege tables - IMPORTANT

privilege and a database SELECT privilege." http://www.mysql.com/doc/en/News-3.23.57.html But it depends on how you GRANTed UPDATE privileges. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Twibell, Cory L [mailto:[EMAIL PROTECTED] > Sent: Monday, Ju

RE: Is the MyODBC password encrypted?

Plain text. Use of the upcoming MyODBC 3.52 will make it in binary form, but not encrypted. Is the remote server MySQL 4.x? You could possibly use Stunnel (www.stunnel.org) to access the server via SSL. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Mike Fish

RE: .fil

In that case they are probably fixed width files. If they are not fixed with and are in fact delimited by tab or comma, you can use LOAD DATA to bring them in. See http://www.mysql.com/doc/en/LOAD_DATA.html Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Ben Fe

RE: error message

Sounds like a corrupt table, try REPAIR TABLE: http://www.mysql.com/doc/en/REPAIR_TABLE.html Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Steven Dowd [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 26, 2003 11:13 AM > To: [EMAIL PROTECTED] >

RE: Best Pratices for mySQL Backups in Enterprise

If your tables are InnoDB, you could look at InnoDB HotBackup: http://www.innodb.com/hotbackup.html Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: SAQIB [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 26, 2003 11:45 AM > To: [EMAIL PROTECTED] >

RE: Need your help in a search query

This may not help with the comma problem, but your app looks like a good candidate for FULLTEXT searching, check out http://www.mysql.com/doc/en/Fulltext_Search.html for information. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Tom Johnson [mailto:[EMAIL PRO

RE: use of UNION

. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Daniel Rossi [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 25, 2003 9:15 PM > To: [EMAIL PROTECTED] > Subject: use of UNION > > > hi there , i finally worked out union joines are supported in &g

RE: MySQL 3.51.06 thru Lotus Approach

Sounds like your windows install process is not complete, check http://www.mysql.com/doc/en/Windows_installation.html for more info. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Russ Guillemot [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 25, 2003 4:1

RE: Updating MySQL db's

://www.mysql.com/doc/en/mysqldump.html for info. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Leo Genyuk [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 25, 2003 12:54 PM > To: MYSQL-List (E-mail) > Subject: Updating MySQL db's > > > I ha

RE: MySQL 4.0.13 GRANT syntax

Does enclosing the username and host in single quotes help? I.E. GRANT SELECT ON *.* TO 'update'@'localhost' IDENTIFIED BY 'update'; Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Adam Lawrence [mailto:[EMAIL PROTECTED] > Sent

RE: Query Execution Time in mysql

You may want to try disabling the index during the insert: ALTER TABLE table1 DISABLE KEYS; insert into table1 select * from table2; ALTER TABLE table1 ENABLE KEYS; And see what that does. See: http://www.mysql.com/doc/en/ALTER_TABLE.html Regards, Mike Hillyer www.vbmysql.com > -Origi

RE: datetime column dummy question

The TIMESTAMP column type does this for you: See: http://www.mysql.com/doc/en/DATETIME.html Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: MaFai [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 24, 2003 11:01 AM > To: [EMAIL PROTECTED] > Subject:

RE: Initializing primary key values for existing table

You need simply add the column predefined as AUTO_INCREMENT and PRIMARY KEY: CREATE TABLE incrtest ( name varchar(100) NOT NULL ) TYPE=MyISAM; INSERT INTO incrtest VALUES("ben"); INSERT INTO incrtest VALUES("bob"); INSERT INTO incrtest VALUES("bom"); INSERT INTO incrtest VALUES("gddo"); INSERT

RE: Subselect functionality

I am not sure that could be viewed as a subselect, as it in not a SELECT within an SELECT, but is instead a SELECT within a CREATE. I would imagine that the SELECT within the CREATE is easier to implement that the actual SELECT within a SELECT. Regards, Mike Hillyer www.vbmysql.com

RE: Dumping data

to create/write a file at the location you specify. You will also want to look at http://www.mysql.com/doc/en/mysqldump.html Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Rob [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 25, 2003 1:57 AM > To: My

RE: MyISAM

MyISAM tables do not support row-level locking, only table locking. See http://www.mysql.com/doc/en/Table_locking.html Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Cedric Gavage [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 25, 2003 2:14 AM >

RE: Large file : InnoDB or MyISAM

In a situation with many concurrent reads and writes an InnoDB table would be preferable. See http://www.mysql.com/doc/en/Table_types.html Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: JOUANNET, Rodolphe [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 2

RE: SCO UnixWare porting of MYSQL

I simply followed the directions listed here: http://www.mysql.com/doc/en/SCO_UnixWare.html And I had no problems. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Sudhipan Sharma [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 25, 2003 3:08 AM >

RE: user@"%" vs user@"localhost" question

> I believe "%" doesn't include "localhost", but I could be wrong. "%" Does indeed include localhost. At least it does on 4.0.13. Regards, Mike Hillyer www.vbmysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

RE: Strange "Mull" in show fields and table keeps crashing

MUL indicates a that the column is part of a composite INDEX. SHOW INDEX FROM tablename Should let you know what columns make up the MUL column INDEX. If this was not supposed to be indexed, your table is corrupt, best try MyIsamChk Regards, Mike Hillyer www.vbmysql.com > -Origi

RE: Confused about MyISAM vs InnoDB tabel types

You should find the following informative: http://www.mysql.com/doc/en/Table_types.html InnoDB offers transaction support, and seems to recover better from crashes. You do sacrifice some speed and features such as FULLTEXT index support. Regards, Mike Hillyer www.vbmysql.com > -Origi

RE: multiple mysql instances and virtualhosts

It is definitely possible, see http://www.mysql.com/doc/en/Multiple_servers.html Of course, you could save yourself some trouble and just setup a separate database on the same instance. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: electroteque [mailto:

RE: UPDATE and ORDER BY

Then you do need it, but like Paul said, you need MySQL 4.x, or you need to run two queries, one to retrieve the row you want to update, and one to do the update. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

RE: SQL query - 3 tables - 3rd one conatins records to not display

block information form the block table, or NULL. The try putting the AND penpals_privmsgs_block.blocked_id IS NULL line back in? Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: vernon [mailto:[EMAIL PROTECTED] > Sent: Monday, June 23, 2003 9:26 AM >

RE: varchar restriction

Perhaps you better watch your language and better explain your question because if I did not answer your question than I do not know what you are asking. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Andrew [mailto:[EMAIL PROTECTED] > Sent: Monday, June 2

RE: Replacing text on query..

Take a look at the REPLACE() function: http://www.mysql.com/doc/en/String_functions.html#IDX1202 Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Nick Stuart [mailto:[EMAIL PROTECTED] > Sent: Monday, June 23, 2003 8:58 AM > To: MySQL List > Subject: Re

RE: varchar restriction

more clear? Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Efficient E [mailto:[EMAIL PROTECTED] > Sent: Monday, June 23, 2003 8:50 AM > To: Mike Hillyer; [EMAIL PROTECTED]; MySQL-Lista > Subject: RE: varchar restriction > > > not sure I un

RE: SQL query - 3 tables - 3rd one conatins records to not display

_name = useronline.uname AND penpals_fav.user_id = $colname AND penpals.privmsgs_block.something IS NULL Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: vernon [mailto:[EMAIL PROTECTED] > Sent: Monday, June 23, 2003 8:42 AM > To: [EMAIL PROTECTED] > Subject: SQL query

RE: varchar restriction

It will not. If such a change is desirable, you will have to make the change in the related table as well. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Andrew [mailto:[EMAIL PROTECTED] > Sent: Monday, June 23, 2003 7:57 AM > To: MySQL-Lista > S

RE: Driver 3.51 Not Found

using ODBC, then you need not worry about that message. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Ellen Cain [mailto:[EMAIL PROTECTED] > Sent: Saturday, June 21, 2003 10:05 AM > To: [EMAIL PROTECTED] > Subject: Driver 3.51 Not Found > >

RE: Driver 3.51 Not Found 2

For automated setup under windows, the MyODBC-3.51.06.exe file should be downloaded. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Ellen Cain [mailto:[EMAIL PROTECTED] > Sent: Saturday, June 21, 2003 4:37 PM > To: [EMAIL PROTECTED] > Subject: Driver

RE: Connecting ASP

subscribe to the MyODBC list at lists.mysql.com Here's a sample linked to from the MyODBC FAQ: http://www.devarticles.com/art/1/50 Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Jorge Cornejo [mailto:[EMAIL PROTECTED] > Sent: Friday, June 20, 2003 1:44 A

RE: SQL query question

Well, from what limited info I have, it looks like your image tag is not closed properly. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Rolf C [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 19, 2003 2:57 PM > To: [EMAIL PROTECTED] > Subject: SQL

RE: Complex SQL involving 10 checkboxes

ny checks, and because you rip the last or and replace it with an and, you are always Ok for what follows. > -Original Message- > From: vernon [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 19, 2003 1:49 PM > To: Mike Hillyer > Subject: RE: Complex SQL involving 10

RE: Complex SQL involving 10 checkboxes

long to more than one agegroup. If so you better post what the table looks like. Regards, Mike Hillyer > -Original Message- > From: vernon [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 19, 2003 1:25 PM > To: [EMAIL PROTECTED] > Subject: RE: Complex SQL involvin

RE: Complex SQL involving 10 checkboxes

nd send the resulting string to the server. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: vernon [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 19, 2003 12:53 PM > To: [EMAIL PROTECTED] > Subject: Complex SQL involving 10 checkboxes > &g

RE: Help me!!!

mailto:[EMAIL PROTECTED] This is what I found at lists.mysql.com Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Luis Enrique Bauzá Peña [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 19, 2003 10:00 AM > To: Lista Mysql Inglés > Subject: Help me!!

RE: selecting PRIMARY KEY when there is no unique value

guess. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Mojtaba Faridzad [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 19, 2003 9:16 AM > To: [EMAIL PROTECTED] > Subject: selecting PRIMARY KEY when there is no unique value > > > Hi, > >

RE: suggestions - server options/mysql variables

If you have queries that are only selects, in small tables, with few rows, you should have very fast performance as is. Are your queries properly indexed? What hardware are you running on? What do these queries look like? Regards, Mike Hillyer www.vbmysql.com > -Original Message- >

RE: Is There An Automated Way To Convert A Well-structured XML File T o Its Corresponding Tables In A MySQL Database ?

You need only ask once. This article by Paul Dubois may help :http://www.kitebird.com/articles/mysql-xml.html This Google search resulted in hundreds of resources: http://www.google.com/search?hl=en&edition=ca&q=convert+xml+to+mysql&btn meta%3Dsearch%3Dsearch=Search+the+Web Regards,

RE: DELETE or RENAME tables?

DROP TABLE tablename; ALTER TABLE tablename RENAME newname; http://www.mysql.com/doc/en/ALTER_TABLE.html http://www.mysql.com/doc/en/DROP_TABLE.html Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednes

RE: SHOW PROCESSLIST

This is a know bug that has been addressed in version 4.0.13, you will need to upgrade. See http://bugs.mysql.com/bug.php?id=164 Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Shane Kirk [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 17, 2003 12:25 PM >

RE: RAID hardware suggestions/experience

gards, Mike Hillyer www.vbmysql.com > A significant question remains for SATA: basic drive > reliability. Related > to that is length of time drive will remain available. A > dirty secret of > RAID is that when a drive goes it must be replaced you must replace it > with

RE: RAID hardware suggestions/experience

llent performance at a great price. I would also look at Opteron based servers if you are looking for performance for a good price. Regards, Mike Hillyer www.vbmysql.com -Original Message- From: David Griffiths [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:59 AM To: [EMAIL PROT

RE: mysql design question ?

What you need to do is specify username in your select query and JOIN the two tables together. Marks table: User_id | Marks User Table User_id | Name Query: SELECT User.Name, Marks.Marks FROM User, Marks WHERE User.User_id = Marks.User_id Regards, Mike Hillyer www.vbmysql.com

RE: Please help me!

, Mike Hillyer www.vbmysql.com -Original Message- From: Varghonan [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 10:36 AM To: [EMAIL PROTECTED] Subject: Please help me! Hi! I am new here and wonder if anyone could help me with a problem in my community. The adress is http

RE: fulltext searching and query order question

('word1 word2' in boolean mode) order by field1,field2,field3 Regards, Mike Hillyer www.vbmysql.com -Original Message- From: H M Kunzmann [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 10:33 AM To: [EMAIL PROTECTED] Subject: fulltext searching and query order question Hi

RE: Access denied

GRANT SHOW DATABASES will allow a user to see all databases, whether the user can access them or not. -Original Message- From: Ronan Lucio [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 8:56 AM To: Mike Hillyer Cc: [EMAIL PROTECTED] Subject: Re: Access denied Mike, On Fri, 13

RE: Access denied

Did you GRANT SHOW DATABASES to the user? If not then they will not be able to use the command. The SHOW DATABASES GRANT clause is a new addition. Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Ronan Lucio [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 8:34 AM To

RE: again with SELECT

Rather than using primes, you could use the SET datatype http://www.mysql.com/doc/en/SET.html This allows for a color to be zero or more values at the same time. SELECT * FROM tbl_name WHERE color = '1,2,3,n' Regards, Mike Hillyer www.vbmysql.com -Original Message- From: K

RE: DATE

Use the ALTER TABLE syntax, see http://www.mysql.com/doc/en/ALTER_TABLE.html Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Wong Zach-CHZ013 [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 3:43 PM To: 'Paul DuBois'; [EMAIL PROTECTED] Subject: DATE H

RE: query question

SELECT * FROM mytable WHERE LENGTH(phone) < 10; http://www.mysql.com/doc/en/String_functions.html Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Susan Ator [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 11:23 AM To: [EMAIL PROTECTED] Subject: query quest

RE: "in" in where

Subselects such as this are only available in MySQL 4.1 and higher. You can upgrade, or rewrite this query as follows: SELECT tblSiteConfig.fldSiteID FROM tblSiteConfig, tblServerConfig WHERE tblSiteConfig.fldServerName = tblServerConfig.fldServerName Regards, Mike Hillyer www.vbmysql.com

RE: delete record

That depends, do you have a backup tape? ;) Unfortunatly a DELETE is a one-way trip. In theory the data is still there is the spot on the hard-drive has not been overwritten, but there are no tools (that I know of) to retrieve that row. Regards, Mike Hillyer www.vbmysql.com -Original Message

RE: empty a table

Try TRUNCATE TABLE tablename-->http://www.mysql.com/doc/en/TRUNCATE.html Or DELETE FROM tablename Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Fabio Bernardo [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 3:33 PM To: Mysql (E-mail) Subject: empty a ta

RE: Other front ends (Was: RE: I need advice. MSAccess frontend to PH P/MYSQL. ANyone done this?)

It depends on what you want to do with the font end. You would always look at MyCC and SQLyog at http://www.mysql.com/products/mysqlcc/index.html and http://www.webyog.com/ respectively. Regards, Mike Hillyer www.vbmysql.com -Original Message- From: David Brodbeck [mailto:[EMAIL

RE: InnoDB

inventory tables be innodb and take advantage of transactions, but keep your log tables in MyISAM for extra speed and fulltext searching (just an example). Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Mojtaba Faridzad [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003

RE: Practice test

most certification tests are a brain-dump, but hey, most HR people do not have the knowledge to check whether you know what the job descriptions need to know, so you have to have something to show you meet the requirements in a job description. Regards, Mike Hillyer www.vbmysql.com -Original Me

RE: INT type

generates temporary tables for some complicated joins, as in these cases MySQL trusts that the data did fit into the original column width. --END QUOTE-- Regards, Mike Hillyer -Original Message- From: Mojtaba Faridzad [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 11:26 AM To

RE: Turning off column and value reconciliation

There is no way to turn it off (well, no practical way, with open source nothing is impossible). Can you add dummy columns to the mysql table to the insert statements match up? Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Campbell D. McCausland [mailto:[EMAIL PROTECTED

RE: SSL and Windows

, Mike Hillyer www.vbmysql.com -Original Message- From: Sparky Kopetzky [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 1:43 PM To: My Sql List Subject: SSL and Windows Does anyone know how to turn the SSL on for mySql for Windows?? I need to encrypt and decrypt certain items in a

RE: Turning off column and value reconciliation

Why not just specify what columns you are inserting into? This check has to be in place, because in the case of a mismatch MySQL would not know which value goes into which column. Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Campbell D. McCausland [mailto:[EMAIL

RE: **field type for large amount of text***

Well, that would be TEXT, MEDIUMTEXT, or LARGETEXT, they hold 65535, 16777215, and 4294967295 characters accordingly. I personally would stick to TEXT, maybe MEDIUMTEXT. Regards, Mike Hillyer www.vbmysql.com -Original Message- From: DuSTiN KRySaK [mailto:[EMAIL PROTECTED] Sent

RE: fastest way to get last row

SELECT * FROM table ORDER BY id DESC LIMIT 1; Regards, Miek Hillyer www.vbmysql.com -Original Message- From: Chris Edwards [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 12:23 PM To: MySQL List Subject: fastest way to get last row Hi Does anyone have tips on the fastest way t

  1   2   >