Temporary stored procedure or function?

Is there a way to create temporary stored proc or func so that it is store in memory rather than in the mysql.proc table? The result I am going for is to abstract some encryption functions, but I don't want the encryption process stored in the proc table; I was thinking if there was a way t

Re: Grant privs to multiple tables at once?

ders -- Anders Lundgren Master Software Engineer Viba IT Handelsbolag Web: http://www.vibait.se David Felio wrote: Assume database 'biggie' with 15 tables, 10 of which start with 'foo_'. I want the user 'foouser' to have access only to those tables that begin with

Grant privs to multiple tables at once?

Assume database 'biggie' with 15 tables, 10 of which start with 'foo_'. I want the user 'foouser' to have access only to those tables that begin with 'foo_'. I'm hoping that I am just being blind because I don't see anything in the manual or in the MySQL book on granting to multiple tables

Re: Database or table level logging?

tand you're on 5.0 not 5.1 but this could prove an elegant solution to your requirement, so an upgrade might be warranted depending on how badly you need it. Of course 5.1 isn't production yet but I've used pre-production releases and generally have found them to be quite stable

Re: Database or table level logging?

Right, sorry, this is 5.0.x (5.0.18 at the moment). Thanks for the pointer on 5.1.6, though that looks like it has the ability to log to a table instead of a file, not log access to a specific table. David On Jul 18, 2006, at 9:23 PM, Chris wrote: David Felio wrote: Is it possible to

Database or table level logging?

Is it possible to have general query type logging on just a specific database or table? I don't want all queries to all databases, I just need a log of accesses to a specific table. I figure I can use stored procedures or a separate mysql instance as a workaround if I need to, but would pre

Re: Errors 1005 and 1025 - but not foreign keys

Ah, it was an orphaned table due to a bad shutdown. Thanks. David On Mar 18, 2006, at 12:50 AM, Heikki Tuuri wrote: David, - Original Message - From: "David Felio" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Thursday, March 16, 2006 11:31 PM Subj

Errors 1005 and 1025 - but not foreign keys

I got an error 1025 trying to rename an InnoDB table. When I go to look in the database now, that table isn't there even though there is a .ibd file in the mysql data directory with the target name. If I try to create a table with the target name (as an InnoDB table), I get error 1005. I ca

Re: INSERT DISTINCT?

Try insert ignore. Check the manual page for insert syntax. On Wednesday, July 7, 2004, at 05:22 PM, Matt Chatterley wrote: This is certainly the first step. Also, if you want to "insert only those rows which are not already present", you can use something akin to: INSERT INTO table1 SELECT * FR

Re: Copy Records in a table...

Is the implementation of this different than the docs say? According to the manual, I didn't think this would work: "* The target table of the INSERT statement cannot appear in the FROM clause of the SELECT part of the query because it's forbidden in ANSI SQL to SELECT from the same table into

Re: Surrounding Rows

er. What I want to do is a query like "SELECT code FROM zip WHERE > zip=12345 SURROUND 5,5" or "SURROUND 10". At the moment, I create a new > table w/ an autoincrement and do a select...insert, then I select first the > id and then id-5 and id+5. This a a) very slow and

Re: Char vs Varchar field types

hen is it appropriate to use Char instead of Varchar and vice versa? > > Thanks > Luke David Felio Software Developer Information Network of Arkansas http://www.AccessArkansas.org - Before posting, please check: http://www.my

Re: Begin work

work and commit will do nothing for you. 2) With autocommit off, you start transactions with "begin work" you end transactions with "commit" or "rollback". If you "begin work" and then "begin work" again, the first transaction is implicitly co

Re: Foreign keys in mysqldump?

onday. If you want to take part in the beta testing, look at > http://www.innodb.com sql David Felio Software Developer Information Network of Arkansas http://www.AccessArkansas.org - Before posting, please check: http

Re: flexible foreign keys?

and then deleting the key? I don't use InnoDB, so I don't know if it will > work, but it's worth a try... > > Thanks, > --jeff > > - Original Message - > From: "David Felio" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent:

flexible foreign keys?

ng numbers. Now I want to delete it from my local copy, but can't because it is linked via the foreign key to the transaction on 2/27/2002. Can someone help me with a solution here? David Felio Software Developer Information Network of Arkansas http://www.Acc

foreign keys to what end?

there no such thing? Should things like this always be handled by foreign keys instead of error checking in the program? The indexing along would seem to get fairly large in the transactions table if I set them all up as foreign keys. David Felio Software Developer Information Network of Arkansas http

Static or Dynamic rows -- which is faster?

ave dynamic columns, > you should try to put them in a table separate from your static columns > (slides 67 and 68 for those who have them). Has this changed? David Felio Software Developer Information Network of Arkansas http://www.AccessArkansas.org -

Re: MySQL ORDER BY or PHP Sort? Oops.

way I'd like. Does anyone know if it's possibly to do > this in the Select statement itself? (I'd rather do it that way, than > resort in PHP.) > > Thanks! > > ...Rene > > --- > René Fournier > [EMAIL PROTECTED] David Felio Software Developer Informati

Re: can auto_increment wrap?

uot;Duplicate entry" error when I hit the max. Was this "feature" eliminated? -- David Felio Software Developer [EMAIL PROTECTED] Information Network of Arkansas http://www.AccessArkansas.org -