Re: Records Mysql can handle??

http://www.mysql.com/doc/en/Table_size.html On Sunday, August 31, 2003, at 01:07 PM, Binay Agarwal wrote: Hi All, Can any body tell me how many records mysql can hold efficiently. i.e Is there any boundation on number of records mysql can handle? Please let me know ... Thanks Binay -- MyS

Re: UPDATE based on value in another table

On Monday, August 25, 2003, at 03:26 PM, Dan Jones wrote: [snip] To make this a tad clearer, I have two tables: Title and Author. Author consists of the Author's name and an AuthorID. Title includes an AuthorID from the Author table. Some of the Author's have been deleted from the Author tab

Re: Is query possible? (Newbie)

On Thursday, August 14, 2003, at 08:04 PM, Jennifer Goodie wrote: I have 2 tables used for an online calendar... first table fields: primary_key , start_date, event_name, event_description second table fields: primary_key, end_date Tables fields are shortened and can't be changed. My second tab

Re: Fixing autoincrement

On Tuesday, August 12, 2003, at 09:46 PM, Andrew Rothwell wrote: Hello List, I have a movies database, that I had an autoincrementing field for counting purposes.What I did though was remove some of the rows out of the table, now my table is reporting an incorrect number of movies listed.What I a

Re: Multiple items in an ALTER TABLE statement

states that: You can issue multiple ADD, ALTER, DROP, and CHANGE clauses in a single ALTER TABLE statement. This is a MySQL extension to SQL-92, which allows only one of each clause per ALTER TABLE statement. but it doesn't give the syntax for doin

Re: Fixing autoincrement

On Tuesday, August 12, 2003, at 09:59 PM, otherguy wrote: On Tuesday, August 12, 2003, at 09:46 PM, Andrew Rothwell wrote: Hello List, I have a movies database, that I had an autoincrementing field for counting purposes.What I did though was remove some of the rows out of the table, now my

Re: mysql and Access

The simplest way, if you have the ability to make an ODBC connection to the mySQL box, would be to create an ODBC linked table in access and then run an append or make-table query against the linked table, as per your situation requires. I assume that you could write a macro that would run the

Re: A Complicated Join

I've been working on something similar to this for quite a while (few more steps, maybe), and this list helped me through it, so I suppose I can at least return the favor. You basically need to do the following (I'm using temporary tables to help me think through it - and because of the lack of

Re: Single Record Locking - Permanent?

2 methods I can think of: 1) Move the records into a different table, and set permissions accordingly (allow updates on for managers on that table) 2) Control authentication and access in your program. -Cameron Wilhelm On Tuesday, July 15, 2003, at 11:03 AM, Dan Ullom wrote: Is it possible t

Re: Advanced Query Help (My brain hurts!)

On Saturday, June 28, 2003, at 07:15 PM, Bruce Feist wrote: otherguy wrote: On Saturday, June 28, 2003, at 03:43 PM, MyLists wrote: That gets me halfway there BF: Does it? No, I don't think it does, upon further consideration and testing... I thought it did b/c I read

Re: Advanced Query Help (My brain hurts!)

On Saturday, June 28, 2003, at 03:43 PM, MyLists wrote: otherguy wrote: That gets me halfway there Does it? Yes, it does. No, I don't think it does, upon further consideration and testing... I thought it did b/c I read, and misinterpreted the UNION documentation In your ori

Re: Advanced Query Help (My brain hurts!)

need, then you can just "append" the two results by using UNION. Good Luck! Dennis - Original Message - From: "otherguy" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Cc: "Terry Vanstory" <[EMAIL PROTECTED]> Sent: F

Advanced Query Help (My brain hurts!)

Hey guys, I'm about to dump a doozy on your collective knowledge and goodwill, and hope for some help or some pointers. I'm not great with advanced SQL, and I've gotten as far as my brain and the resources I've been using will allow me to get for the time being. I need help with two things: 1)

Re: SSL and Windows

http://www.google.com/search?q=openssl+windows&ie=UTF-8&oe=UTF-8 On Monday, June 9, 2003, at 01:43 PM, Sparky Kopetzky wrote: Does anyone know how to turn the SSL on for mySql for Windows?? I need to encrypt and decrypt certain items in a database and the manual says add the OpenSSL package bu

Re: database permissions

On Wednesday, May 28, 2003, at 08:16 PM, otherguy wrote: ps -U httpd I screwed this up. It's been a long day. Of course it should be: ps -U mysqld sorry about that -Cameron Wilhelm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: database permissions

On Wednesday, May 28, 2003, at 07:40 PM, [EMAIL PROTECTED] wrote: On Wednesday, May 28, 2003, at 06:31 AM, Jon Haugsand wrote: * [EMAIL PROTECTED] What the permissions/ownership be on my database directory? I think is the cause of my problem of only being able to startup mysqld as 'root'. On my