Regular Expression Reference

I'm sure this is sitting inches from my nose but I just can't see it. In Appendix G of the manual it states: This is a simplistic reference that skips the details. To get more exact information, see Henry Spencer's regex(7) manual page that is included in the source distribution. I can't seem

Help Exporting Tables/Data

does mysql provide a command to export table structure and data? i can't seem to find anything like this in the manual. i'm trying to export tables and data created on my desktop to my isp...help! Jeff - Before posting, please

Help Transferring Data from MS Access to mySQL

I'm very new to mysql and haven't got much of a background in databases generally, so thanks in advance to any who have the patience to deal with my question. I'm trying to get data from ms access 97 to mysql by exporting to a text file then using the load data command to import it. The data in

RE: LEFT JOIN in MySQL Version 3.22.32

Careful here, a left join is not necessarily the same as a join. In particular a left join will return rows for the left table even if there are no matching rows in the right table. Under many conditions the two are identical but definitely not always. That being said, maybe one could use temp

RE: index troubles

In your query your still asking for all rows in the table. To utilize an index, a restrictive query often works for example: Assuming you have an index on distance --- SELECT * FROM loeb WHERE distance = 2; The random tottid results from your grouping by distance. In effect you have made

64MB Limit on MyISAM indexes?

. Are MyISAM tables able to handle large indexes? I hope I don't have to go back to ISAM tables... Any suggestions? Thanks, Jeff Brewer Spam filter bypass: (database,sql,query) - Before posting, please check: http://www.mysql.com

mysql.host table

) doesn't always give me the same set of access rights. Can anyone provide an example of using the host table to grant permissions? Especially useful would be an example in which using the db table alone would not achieve the same results as using the db/host tables. Thanks, Jeff Brewer

RE: mysql.host table

or tails of it. -Jeff Brewer -Original Message- Did you read chapter 6 in the manual? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

RE: Problem with Mysql

There should be no password for root@localhost initially. Try $mysqladmin -u root password 'thisIsMyNewPassword' instead. The password mysqladmin is asking for is the current password. The one on the command line is the new one. In your situation the current password is nothing. -Jeff

RE: mysql.host table

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gerald L. Clark Sent: Friday, March 09, 2001 4:02 PM To: Jeff Brewer Cc: MySQL Mail List Subject: Re: mysql.host table Then run some GRANT commands, and see what they do to the privilege tables. Chapter 6