Re: Lock Tables Question

Once you issue a LOCK TABLES command, you may not access any tables not in the LOCK statement. You must lock *ALL* tables you will use, perform your updates, and then UNLOCK TABLES. I didn't know that. I reviewed the documentation. Thanks. OK, then my only remaining question is how many

Trigger question

Hey all, I asked this before (a while back) and have gotten some answers that solve my problem partially only. --- old message -- I have a table with 205 columns. When an update statement updates a row in this table I want a trigger that creates a record of the old row in a separate

Re: Trigger question

Hi, Olaf Stein wrote: Hey all, I asked this before (a while back) and have gotten some answers that solve my problem partially only. --- old message -- I have a table with 205 columns. When an update statement updates a row in this table I want a trigger that creates a record of

RE: Trigger question

www.giiexpress.com www.etudes-marche.com -Original Message- From: Olaf Stein [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 30, 2007 2:05 PM To: MySql Subject: Trigger question Hey all, I asked this before (a while back) and have gotten some answers that solve my problem partially only

Re: Trigger question

Baron, Thanks a lot Adding the columns to the end works... Olaf On 5/30/07 2:13 PM, Baron Schwartz [EMAIL PROTECTED] wrote: Hi, Olaf Stein wrote: Hey all, I asked this before (a while back) and have gotten some answers that solve my problem partially only. --- old message

A question about how to debug the error 2013, 'Lost connection to MySQL server during query'

no corresponding errors in the error log. The question is : how do I go about debugging this problem? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: A question about how to debug the error 2013, 'Lost connection to MySQL server during query'

-warnings set to 3, but I get no corresponding errors in the error log. The question is : how do I go about debugging this problem? the most common error in this case is a crash of the thread processing your query -- Sebastian Mendel www.sebastianmendel.de -- MySQL General Mailing List

InnoDB and raw devices and DRBD question

Hi ALL, I would like to use INNODB with raw devices for tablespace in the innodb_data_file_path both on MySQL 5.0.x and MySQL 5.1.x. Is it possible to use DRBD (Distributed Raw Block Device) with InnoDB and raw devices. If yes, which are the constraints ? Thanks in advance for your

Select question

I have three tables, all of which have a 'name' column. If I do: select table1.*, table2.*, table3.* from I'll end up with a result set that has three 'name' fields, but no way to distinguish which table the field belongs to. I know I can select individual columns like: select

Re: Select question

Erich, Is there a way to set a prefix for each table so that the results come out like tablename.column? Use a scripting or application language to automate parameterise query generation. SQL is just a partial computing language. PB - Erich C. Beyrent wrote: I have three tables, all

Re: Newbie Question connecting with windows named pipes (resolved)

Thanks Sebastian, that did the trick. The full command I use is: $mysqli = new mysqli(., $username,$password, $database,null,/tmp/mysql.sock); Regards, JC Sebastian Mendel wrote: John Comerford schrieb: Hi Folks, I have a database running on Window XP, that I want to disable network

Re: Newbie Question connecting with windows named pipes (resolved)

John Comerford schrieb: Thanks Sebastian, that did the trick. The full command I use is: $mysqli = new mysqli(., $username,$password, $database,null,/tmp/mysql.sock); there is no need for the socket, their are no sockets on windows $mysqli = new mysqli('.', $username, $password, $database);

Re: Newbie Question connecting with windows named pipes (resolved)

Hi Sebastian, I did read somewhere that sockets was not valid for windows, and '/tmp/mysql.sock' doesn't resolve to anything on my machine. But I have tried the following commands: $mysqli = new mysqli(., $username,$password, $database); or $mysqli = new mysqli(., $username,$password,

Re: Newbie Question connecting with windows named pipes (resolved)

John Comerford schrieb: Hi Sebastian, I did read somewhere that sockets was not valid for windows, and '/tmp/mysql.sock' doesn't resolve to anything on my machine. But I have tried the following commands: $mysqli = new mysqli(., $username,$password, $database); or $mysqli = new

Re: Newbie Question connecting with windows named pipes (resolved)

Hi Sebastian, That was it alright. I commented out the socket lines from mysql.ini (restarted it) and changed my php command to: $mysqli = new mysqli(., $username,$password, $database); and all seems to be working fine now. Thanks again for your help, much appreciated. Regards, John

Newbie Question connecting with windows named pipes

Hi Folks, I have a database running on Window XP, that I want to disable network connections to and enable 'named pipes'. I am running MySQL 5.0.27 and my.ini looks like... [client] #password= your_password port= 3306 socket= /tmp/mysql.sock [mysqld] #port=

Re: Newbie Question connecting with windows named pipes

John Comerford schrieb: Hi Folks, I have a database running on Window XP, that I want to disable network connections to and enable 'named pipes'. I am running MySQL 5.0.27 and my.ini looks like... [...] I can connect to the DB using the GUI tools if I set my pipe name to

BLOB Storage question

hello: i have the following table in the database test_transaction -- -- Table structure for table `test_blob` -- CREATE TABLE `test_blob` ( `f1` blob NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; i saw the files in the mysql var directory $ ls -l test_transaction/test_blob.frm -rw-rw

Re: BLOB Storage question

Hi, hello: i have the following table in the database test_transaction -- -- Table structure for table `test_blob` -- CREATE TABLE `test_blob` ( `f1` blob NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; i saw the files in the mysql var directory $ ls -l test_transaction/test_blob.frm

Re: Question on InnoDB support

Hi Waldo, all! [EMAIL PROTECTED] wrote: I'm making an assessment of MySQL possible official adoption in my company. A question I have is: with InnoDB codebase being owned by Oracle, is there any impact to its reliability and support? Any other issues? The developers of InnoDB have never

Trigger OLD question

Hi All, I have a table with 205 columns. When an update statement updates a row in this table I want a trigger that creates a record of the old row in a separate table. The following works fine when not too many columns need to be written into the other table CREATE TRIGGER track_table BEFORE

Re: Trigger OLD question

At 4:59 PM -0400 5/9/07, Olaf Stein wrote: Hi All, I have a table with 205 columns. When an update statement updates a row in this table I want a trigger that creates a record of the old row in a separate table. The following works fine when not too many columns need to be written into the

RE: Trigger OLD question

You might try: INSERT INTO table_track select OLD.*; -Original Message- From: Olaf Stein [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 09, 2007 2:59 PM To: MySql Subject: Trigger OLD question Hi All, I have a table with 205 columns. When an update statement updates a row

Question on InnoDB support

I'm making an assessment of MySQL possible official adoption in my company. A question I have is: with InnoDB codebase being owned by Oracle, is there any impact to its reliability and support? Any other issues? Waldo Tumanut Database Analyst

Re: IS NULL Question

I'm having problems understanding NULL. I grasp what a NULL value is, Actually, you don't :-) NULL is not a value, it's the lack of value and a state. A column can have 2 states: NULL or NOT NULL, which is part of the reason why SQL allows for the IS NULL and IS NOT NULL clause as opposed

Re: IS NULL Question

By chance when you set them as null did you use null or 'null' setting it as a string value? __ Lucas Heuman Phone 609.485.5401 Martijn Tonies [EMAIL PROTECTED] 05/01/2007 04:45 AM To MySQL mysql@lists.mysql.com cc Subject Re: IS NULL Question I'm having

Re: IS NULL Question

At 9:06p -0400 on 30 Apr 2007 John Kebbel wrote: I'm having problems understanding NULL. I grasp what a NULL value is, A NULL value is rather an oxymoron. It'd be more accurate to say that NULL means absence of a value. but I can't get NULL to perform correctly. For instance, if I do a

Re: IS NULL Question

Kevin Hunter wrote: At 9:06p -0400 on 30 Apr 2007 John Kebbel wrote: I'm having problems understanding NULL. I grasp what a NULL value is, A NULL value is rather an oxymoron. It'd be more accurate to say that NULL means absence of a value. but I can't get NULL to perform correctly.

RE: IS NULL Question

Question At 9:06p -0400 on 30 Apr 2007 John Kebbel wrote: I'm having problems understanding NULL. I grasp what a NULL value is, A NULL value is rather an oxymoron. It'd be more accurate to say that NULL means absence of a value. but I can't get NULL to perform correctly. For instance, if I

Re: IS NULL Question

Caveat emptor: I haven't tested this in about a year. Are you perchance using a table type of MyISAM? I seem to recall that MyISAM has a hard time actually representing NULL internally. [ ... Thinks for a minute ... ] I remember something about spaces, like, I think I did INSERT (

Re: IS NULL Question

Jerry Schwartz wrote: We use NULL all the time with MyISAM tables, and I've never noticed a problem. I think there was a bug at one point dealing with NULL and empty strings, but it strikes me that it was a bug in the new client/server protocol that was introduced in (4.1? 5.0?). So, it

Re: IS NULL Question

It looks like it was a string named NULL posing as a null value. I got 0 for ISNULL(suffix), which I assume means false. I tried this command ... update persons set suffix = 'Empty' where suffix = ''; It changed the NULLs to Empty. On Mon, 2007-04-30 at 18:12 -0700, Jeremy Cole wrote: Hi

IS NULL Question

I'm having problems understanding NULL. I grasp what a NULL value is, but I can't get NULL to perform correctly. For instance, if I do a Select statement, I see that I have columns with a NULL value. select first, last, suffix from persons LIMIT 5; +---+--++ | first |

Re: IS NULL Question

Hi John, Are you sure they are actually NULL and not NULL (i.e. the string NULL)? Try this: SELECT first, last, ISNULL(suffix), LENGTH(suffix) FROM persons LIMIT 5; Regards, Jeremy John Kebbel wrote: I'm having problems understanding NULL. I grasp what a NULL value is, but I can't get NULL

Re: Update question

On Wednesday 25 April 2007 23:14, you wrote: try this: update table1, table2 set table1.value = table2.value where table1.id = table2.id Thanks for the replies... It was late evening when I tried to figure out how to do this. Today I found the answer myself, which is exactly as described

Update question

Please, I nedd help!! I have two tabels: table1: id value table2: id value Both tables has a lot of records with identical IDs. I need to update the table1.value with the table2.value where the id are identical. But I cannot find any UPDATE query that can do

Re: Update question

On Wed, April 25, 2007 23:10, Jørn Dahl-Stamnes wrote: Please, I nedd help!! I have two tabels: table1: id value table2: id value Both tables has a lot of records with identical IDs. I need to update the table1.value with the table2.value where the id are

Re: Query question

Can you post your table definitions and some sample data. Also what is the end requirement - how should the end result look like? Anoop On 4/23/07, Clyde Lewis [EMAIL PROTECTED] wrote: Guys, I have the following table that contains some information about a cars. I'm trying to write a query

Query question

Guys, I have the following table that contains some information about a cars. I'm trying to write a query to determine: the number of make(name of car), number of models per make(name of car) and the average number of models/make(name of car) sold in a particular period. The two queries

Grouping Question

I have a contact table looks like id type owner_idowner_type value 11email21 person [EMAIL PROTECTED] 12phone 21 person 303-777- 13PO Box18 business 220 14cell

Re: Grouping Question

On 4/22/07, YL [EMAIL PROTECTED] wrote: I have a contact table looks like id type owner_idowner_type value 11email21 person [EMAIL PROTECTED] 12phone 21 person 303-777- 13PO Box18

Re: Grouping Question

On 4/22/07, Christian High [EMAIL PROTECTED] wrote: On 4/22/07, YL [EMAIL PROTECTED] wrote: I have a contact table looks like id type owner_idowner_type value 11email21 person [EMAIL PROTECTED] 12phone 21

Re: Grouping Question

Thanks a lot CJ. That's the cost of flexibility:-) - Original Message - From: Christian High To: YL Cc: mysql@lists.mysql.com Sent: Sunday, April 22, 2007 12:45 PM Subject: Re: Grouping Question On 4/22/07, YL [EMAIL PROTECTED] wrote: I have a contact table looks

Query Question

I have a couple of very simple tables to handle a client signin site: The client table has the following fields: client_id int(11) primary key auto_increment first_name char(90) last_name char(90) The signin table has the following fields record_id int primary key auto_increment client_id

Re: Query Question

Hi Aaron, Aaron Clausen wrote: I have a couple of very simple tables to handle a client signin site: The client table has the following fields: client_id int(11) primary key auto_increment first_name char(90) last_name char(90) The signin table has the following fields record_id int

RE: Configure options question

PROTECTED] Subject: RE: Configure options question -Original Message- From: Lopez, Denise [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 12:51 PM To: [EMAIL PROTECTED] Subject: Configure options question I have a beginner question for you all. I recently took over a server

Re: Configure options question

Lopez, Denise wrote: I am sorry if I was vague. I know my version of PHP supports .png images. My developers are having issues with extracting .png images files from a mysql database that's why I wanted to make sure it wasn't a support issue with mysql. They can upload the files into the

RE: Configure options question

-Original Message- From: Lopez, Denise [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 2:07 PM To: [EMAIL PROTECTED] Subject: RE: Configure options question I am sorry if I was vague. I know my version of PHP supports .png images. My developers are having issues

Query Question

Hi, Suppose that there are two tables book and author: book id title author_id author - od title I want a query that returns all the books, but if there are more than 3 books with the same author_id, only 3 should be returned. For example if this is the contents of the book

Re: Query Question

Behrang Saeedzadeh wrote: Hi, Suppose that there are two tables book and author: book id title author_id author - od title I want a query that returns all the books, but if there are more than 3 books with the same author_id, only 3 should be returned. For example if this is

Re: Query Question

second question, I can't think of a way to do this. It sounds like you're getting into the realm of formatting something for visual display, which is not what SQL is best used for in my opinion. Regards Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Query Question

... To answer your second question, I can't think of a way to do this. It sounds like you're getting into the realm of formatting something for visual display, which is not what SQL is best used for in my opinion. Yeah, you're right. The problem is that I need to know for which authors the number

Configure options question

I have a beginner question for you all. I recently took over a server and would like to determine what configure options were given when MySQL was compiled. Currently the MySQL version is 4.1.10 and I would like to know whether the mysql server was compiled with .png support. Thanks in advance

RE: Configure options question

-Original Message- From: Lopez, Denise [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 12:51 PM To: [EMAIL PROTECTED] Subject: Configure options question I have a beginner question for you all. I recently took over a server and would like to determine what configure

Re: dumpfile question

-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com Related question. does mysqldump properly escape blobs so that they can be restored via 'mysql -u xxx -p databaseName dumpFile' ? -- William R. Mussatto Systems Engineer http://www.csz.com 909-920

Re: dumpfile question

no, please use load data infile function. - Original Message - From: Wm Mussatto [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, April 12, 2007 12:44 AM Subject: Re: dumpfile question On Tue, April 10, 2007 19:45, Paul DuBois said: At 10:15 AM +0800 4/11/07, wangxu wrote

dumpfile question

follow is my sql: select * into dumpfile '/home/wangxu/test4.data' from mytable ; mysql server report: Result consisted of more than one row why?how to use the select into dumpfile?

Re: dumpfile question

At 10:15 AM +0800 4/11/07, wangxu wrote: follow is my sql: select * into dumpfile '/home/wangxu/test4.data' from mytable ; mysql server report: Result consisted of more than one row why?how to use the select into dumpfile? From the manual: If you use INTO DUMPFILE instead of INTO

Fw: dumpfile question

? - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Wednesday, April 11, 2007 10:45 AM Subject: Re: dumpfile question At 10:15 AM +0800 4/11/07, wangxu wrote: follow is my sql: select * into dumpfile '/home/wangxu/test4

question about Queries per second avg

Hi List, Using printf( System status: %s\n, mysqli_stat($link)); in a PHP script, says: Queries per second avg: 0.051. This means that a query takes about 20 seconds ? But the query result is given immediately. How should I interpret Queries per second avg ? I'm using version 5.0.15 NT. Regards,

Re: question about Queries per second avg

C.R.Vegelin wrote: ... How should I interpret Queries per second avg ? How about as 'queries per second on average' :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: question about Queries per second avg

Thanks Christophe, Question rephrased: how do you explain 0.05 q/s = 20 s/q with an immediate response ? Cor - Original Message - From: Christophe Gregoir [EMAIL PROTECTED] To: C.R.Vegelin [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Friday, April 06, 2007 8:35 AM Subject: Re

Re: question about Queries per second avg

tables: 1 Open tables: 64 Queries per second avg: 0.549 The number of queries would be Questions + Slow queries. See if you can spot where mysqladmin gets its time count and use it to divide the previous sum. Your box isn't underperforming, it just isn't under a high load. Question answered

Re: question about Queries per second avg

sum. Your box isn't underperforming, it just isn't under a high load. Question answered ? grtz C.R.Vegelin wrote: Thanks Christophe, Question rephrased: how do you explain 0.05 q/s = 20 s/q with an immediate response ? Cor - Original Message - From: Christophe Gregoir [EMAIL

Re: question about Queries per second avg

It's just telling you how many queries per second on average the server is receiving. This says nothing about how long it takes to execute a particular query. -Micah On 04/06/2007 01:22 AM, C.R.Vegelin wrote: Hi List, Using printf( System status: %s\n, mysqli_stat($link)); in a PHP script,

Re: question about Queries per second avg

the previous sum. Your box isn't underperforming, it just isn't under a high load. Question answered ? grtz C.R.Vegelin wrote: Thanks Christophe, Question rephrased: how do you explain 0.05 q/s = 20 s/q with an immediate response ? Cor - Original Message - From: Christophe

RE: question about Queries per second avg

Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: C.R.Vegelin [mailto:[EMAIL PROTECTED] Sent: Friday, April 06, 2007 4:46 AM To: Christophe Gregoir Cc: mysql@lists.mysql.com Subject: Re: question about Queries per second avg Thanks

Privileges question.

Hi all, I am trying to create a user with only SELECT,INSERT,UPDATE,DELETE privileges on a database. My question is when I type show grants for the user I create, it says the user has full privileges over the database and I only want them to have the ones listed above. mysql grant SELECT

RE: Privileges question.

, Denise [mailto:[EMAIL PROTECTED] Sent: Thursday, April 05, 2007 4:08 PM To: mysql@lists.mysql.com Subject: Privileges question. Hi all, I am trying to create a user with only SELECT,INSERT,UPDATE,DELETE privileges on a database. My question is when I type show grants for the user I create, it says

mysql question.

hi i need help regarding a sql query in my php app. the query is : $SQL = SELECT DISTINCT(EMail) FROM mena_guests WHERE Voted = 'yes' LIMIT $startingID,$items_numbers_list; i want to sort this query by the number of the repeated EMail counts. can anyone help me with that please ?

Re: mysql question.

Hmmm, using distinct email in a query where you want to count email won't work. select mail, count(mail) as mailcnt from guest where voted='yes' group by mail order by mailcnt; should do the trick. On Tue, April 3, 2007 12:51, Me2resh Lists wrote: hi i need help regarding a sql query in my

database replication question

Hi, As I know, master will replicate all database to the slave in default. If I want to replicate only specified database, we can use parameter in master. binlog-do-db=databasename I found that we can also use parameters to replicate database even table in slave. replicate-do-db=db_name

Describe question

Hi All, Is there a way to influence the order in which columns are returned in a describe table statement. Basically I want the same order that I get in the mysql client (Field, Type, Null, etc) in a little script I am writing, so I can use the Column headers dynamically. Thanks Olaf -- MySQL

Re: Describe question

-Detected Subject: Describe question Hi All, Is there a way to influence the order in which columns are returned in a describe table statement. Basically I want the same order that I get in the mysql client (Field, Type, Null, etc) in a little script I am writing, so I can use the Column headers

RE: Database creation question

: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 21, 2007 7:09 AM To: Lopez, Denise; mysql@lists.mysql.com Subject: Re: Database creation question You might try issueing a FLUSH PRIVILEGES command instead of restarting. This is supposed to be implicit when you use the GRANT statement

ORDER BY question

Hello everybody, I got a small problem with ordering on en ENUM field. The values in this field are: - to be started - started - finished - canceled And i want to order on this field, but in the direction the are above here (and not alpabetically). Is that possible? - Mike -- Medusa,

Re: ORDER BY question

Hey Mike, Sounds like you would be better of with an ENUM of integers, e.g. ENUM(-1,1,2,3) where -1 stands for to be started, 1 for started and so on. To answer your question: ORDER BY `status` = 'to be started', `status` = 'started', `status` = 'finished', `status` = 'canceled' Mike van

Re: ORDER BY question

on. To answer your question: ORDER BY `status` = 'to be started', `status` = 'started', `status` = 'finished', `status` = 'canceled' Mike van Hoof wrote: Hello everybody, I got a small problem with ordering on en ENUM field. The values in this field are: - to be started - started - finished

Re: Database creation question

: Database creation question Denise, Hola!. 1) Connect to the system like root user 2) $ chown -R mysql:mysql /usr/local/mysql/ 3) In oder to create user use : mysql GRANT ALL PRIVILEGES ON DATABASENAME.* TO USERNAME@% IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION; Regards, Juan

Re: Database creation question

] To: mysql@lists.mysql.com Sent: Tuesday, March 20, 2007 7:55 PM Subject: RE: Database creation question That still didn't work. I think I just need to restart the mysql service. Denise Lopez UCLA Center for Digital Humanities Network Services Systems Engineer 337 Charles E. Young Drive East PPB 1020 Los

RE: ORDER BY question

to the enum list via ALTER TABLE. -Original Message- From: Mike van Hoof [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 21, 2007 3:19 AM To: Christophe Gregoir Cc: mysql Subject: Re: ORDER BY question Thanks, that is also a solution. Friend of mine pointed me to the following

Database creation question

Hello everyone, I had a really weird thing happen and I was wondering if anyone has seen anything like this. From a shell command line I connected to a running instance of mysql with the mysql -u root -p command. I successfully get to a mysql prompt. I needed to create a new database and user for

Re: Database creation question

Denise, Hola!. 1) Connect to the system like root user 2) $ chown -R mysql:mysql /usr/local/mysql/ 3) In oder to create user use : mysql GRANT ALL PRIVILEGES ON DATABASENAME.* TO USERNAME@% IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION; Regards, Juan Eduardo On 3/20/07, Lopez,

RE: Database creation question

Moreno [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 20, 2007 4:03 PM To: Lopez, Denise Cc: mysql@lists.mysql.com Subject: Re: Database creation question Denise, Hola!. 1) Connect to the system like root user 2) $ chown -R mysql:mysql /usr/local/mysql/ 3) In oder to create user use

Posting A Question

Hi... How do I go about posting a question about MySQL? Thank you, John Sutton -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Posting A Question

Just like you did this right now :) Ales. On 3/19/07, John Sutton [EMAIL PROTECTED] wrote: Hi... How do I go about posting a question about MySQL? Thank you, John Sutton -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Posting A Question

John Sutton wrote: Hi... How do I go about posting a question about MySQL? I think you're getting the hang of it. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL

performance of big tables - fundamental question on how to design a database

Hello list, I'm currently developing a newsletter tool allowing customers to send their newsletters to their clients and get all kinds of statistics. For each customer of ours, I need to save up to five different lists of newsletter recipients with their email addresses and some other stuffs

Specific mysql Trigger question

mysql ver 5.0.26 standard Can a trigger call a procedure that returns a result set? I am trying to get around this error msg. ERROR 1415 (0A000): Not allowed to return a result set from a trigger Thanks -winn Below is a more concise description of my issue and logic pattern when a record is

Stored proc permissions question

I have a set of tables that contain sensitive user information. I need to use this data for validation BUT I don't want the end user to have access to read this data. In MSSQL I used to be able to create a stored proc to do the work (even though the user didn't have access to the table). I was

Re: Stored proc permissions question

On 2007-02-28 Gary W. Smith wrote: Basically, here is the stored proc. It works, but only for root. Is it possible to allow user to execute this without having SELECT access to the table users? If so, how? Do you know about the SQL SECURITY { DEFINER | INVOKER } options to CREATE

RE: Stored proc permissions question

Is this correct? The next question is what permissions do I need to give [EMAIL PROTECTED] to just access that one permission? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Stored proc permissions question

The next question is what permissions do I need to give [EMAIL PROTECTED] to just access that one permission? The sound of that thump thump thump is my head hitting the wall. There is like a single small line in the GRANT section of the how to that mentioned TABLE|PROCEDURE|FUNCTIO but none

Re: Stored proc permissions question

On 2007-02-28 Gary W. Smith wrote: ... If I'm understanding the docs correct (which I'm probably not), I should create the procedure with [EMAIL PROTECTED] CREATE [EMAIL PROTECTED] PROCEDURE Better add SQL SECURITY DEFINER to it. .. The next question is what permissions do I need to give

RE: Stored proc permissions question

Better add SQL SECURITY DEFINER to it. I noticed that it works with and without this. I have added it to the procedure. Another quick question though. Since I have added the end user that will execute the procedure it works fine, until I drop the procedure and recreate it then I have to read

Another stored proc question

This is a follow-up to the earlier stored proc question. I have a stored proc, with user level permissions for execute. If I drop the stored proc and then create it again, the user level execute permissions go away. What is the proper way to edit/alter a store proc without losing

on duplicate key question

This is somewhat related to my last question RE conflicting procedure argument names, but in regards to multi-row inserts... suppose the following procedure: DROP PROCEDURE IF EXISTS sp_ImportedUpdate | CREATE PROCEDURE sp_ImportedUpdate () DETERMINISTIC CONTAINS SQL MODIFIES SQL DATA

Restore Question

We're in the process of changing our InnoDB databases to file-per-table. I started last night with our test server. It went pretty smoothly, except for one stupid mistake on my part. I backed up all databases, deleted he data and log files, re-created the MySQL database from the script, then

Re: Restore Question

In news:[EMAIL PROTECTED], [EMAIL PROTECTED] [EMAIL PROTECTED] typed: After creating a new mysql db from the script, should I have first restored the old mysql database, then the user databases? You should first restore mysql database just to be on the safe side, but I don't think the import

stored proc question.

I have a string (word word bob jack) such that I want to pass to the store proc as a single entity, split it in the store proc, and do a specific action for each word. Any advice on how to do this? There is more going on that just that single word so multiple calls isn't practical and they

<    5   6   7   8   9   10   11   12   13   14   >