RE: Converting MyISAM to InnoDB

If you have a column defined as auto_increment, there must be a key on it. This is true both in myisam and innodb. If you need further help, please show us the full structure of the real table you're operating on (not the one from your sandbox), the statement you run, and the error message. R

Re: How do I get a list of all defined UDF's known to the system?

mysql> DELIMITER // mysql> CREATE PROCEDURE test.sp1() SELECT 'Hello!' AS Msg; -> // Query OK, 0 rows affected (0,00 sec) mysql> SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES; -> // +--+ | ROUTINE_NAME | +--+ | sp1 | +--+ 1 row in set (0,

Re: how to get distinct values in the following scenarion

MuraliKrishna wrote: Hi I have table like as following.. Cust_id Visited_date 1 2-1-2010 2 3-1-2010 3 4-1-2010 4 5-1-2010 6 6-1-2010 1 7-1-2010 2 8-1-2010 These visitor ids with visited date. but I want only all the customers with fi

Re: hi.. is it possible

MuraliKrishna wrote: Hi is it possible to have two instances of mysql over single windows xp. because I want to workout with those as server and client. please help me regarding this. Sure you can! Read this and get back to us with questions: http://dev.mysql.com/doc/refman/5.1/en/multiple-s

Converting MyISAM to InnoDB

Hello again! I am trying to convert my tables to InnoDB, and i am getting an error... Error: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key Now, I converted a table in my sandbox earlier this morning to do some testing, and it worked fine... mi

RE: MyISAM no table lock

Wow... maybe i should have re-evaluated my php script that does all this... It is VERY in-efficient, ever look back at your code/script and think... WHAT WAS I THINKING? Well, this is one of those occasions... Basically, what i was doing, was running though my freeradius radius accounting tabl

Re: MyISAM no table lock

On Mon, Feb 8, 2010 at 3:37 PM, Steve Staples wrote: > Hi there. > > I was reading last week (and of course, i can't find it now) something > about > 'nicifying' a query, so taht it doesn't lock the table... > > How is this done? I've read so much stuff lately, that i can't find it > for > the

RE: dumping error

>-Original Message- >From: Thiyaghu CK [mailto:theyaho...@gmail.com] >Sent: Saturday, February 06, 2010 6:16 AM >To: MuraliKrishna >Cc: mysql@lists.mysql.com >Subject: Re: dumping error > >I hope you are executing the command from 'D:\', mysqldump has to be >executed for the directory bin w

MyISAM no table lock

Hi there. I was reading last week (and of course, i can't find it now) something about 'nicifying' a query, so taht it doesn't lock the table... How is this done? I've read so much stuff lately, that i can't find it for the life of me, and google is not being my friend :( Steve. -- MySQL

Re: ERROR

the oom-killer is a kernel function that shoots down [large|random] processes when you start running out of memory. Google is your friend, as are RAM vendors :-) On Mon, Feb 8, 2010 at 8:22 AM, Krishna Chandra Prajapati < prajapat...@gmail.com> wrote: > Hi List, > > I am getting the below error