Get count of number of lines from mysql stored procedure

Hi All,I want to find out number of lines are there in all stored procedure written.Is it possible to get the number of lines using a SQL query.Thanks in advance. -- Regards, Manasi Save

Re: how things get messed up

Dear Jerry Schwartz We have applications for colleges in India. The same idea of having single table for manipulating students records. but we are not following archiving concept. Ex stupersonal. and stuclass these tables are playing wide role in our application. After 7 years now there are 90

auto_increment weirdness

Hi, for some reason, I have an auto_increment field that's magically bumped up to the next biggest power of 2 after a big INSERT...SELECT that inserts a bunch of tuples (into an empty table). Is this expected behavior? I couldn't find any mention of this from the docs (using the MySQL 5.4.3 beta).

Re: Uprading from mysql 5.0 to mysql 5.1

Hi Machiel, all! Machiel Richards wrote: > [[...]] > > We are looking at upgrading a clients' MySQL 5.0 to version > 5.1. Good. > > They are running the following version: mysql Ver 14.12 > Distrib 5.0.72sp1, for unknown-linux-gnu (x86_64) using readline 5.1

dynamic sql using INTO

I have a function built that will get me X percentile from my history table for last X days. It works fine as long as I hard code the certain values in where they go... what I really need to know is how can I make dynamic sql still do a select into a variable? simply replacing the '31' below wit

RE: compare column value to anything in a list of values

[snip] IN('value1','value2') should work for exact matches, also works for integer values. [/snip] IN will not open and read his CSV file... [snip] Is there a simple function or method to compare a value in a column to one or more items in a comma separated list? [/snip] In order to do this you

Re: compare column value to anything in a list of values

On Wed, February 17, 2010 09:24, Cantwell, Bryan wrote: > Is there a simple function or method to compare a value in a column to one > or more items in a comma separated list? > > select * from table where value > ('apple','orange','banana'); > > and say value may = something like > 'produce(grape

RE: compare column value to anything in a list of values

A simple IN would not match if the actual value of the values column is litterally ''produce(grape,orange,pear,apple,lettuce)' and you want to see if any one of ('apple','orange','banana') is in there From: dryd...@optonline.net [dryd...@optonline.net] Sent:

compare column value to anything in a list of values

Is there a simple function or method to compare a value in a column to one or more items in a comma separated list? select * from table where value ('apple','orange','banana'); and say value may = something like 'produce(grape,orange,pear,apple,lettuce)' -- MySQL General Mailing List For list a

Re: Information_schema permission error

Thanks for the answer. ZK --- On Wed, 2/17/10, Mikhail Berman wrote: > From: Mikhail Berman > Subject: Re: Information_schema permission error > To: "Zakai Kinan" > Cc: mysql@lists.mysql.com > Date: Wednesday, February 17, 2010, 5:49 AM > On 02/16/2010 17:30, Zakai Kinan > wrote: > > I am gett

Re: how things get messed up

Hi, The problem of BLOB storage with MySQL is not the actual storage of the BLOB data, it is the getting BLOBs to and from the client. Traditionally MySQL treats the BLOB data as any other data and as a result there can be major memory usage and performance issues as the BLOB is passed back to th

Stored Procedure/Function Question

Hi there, I have a WEIRD question, that I can't find an answer too... Here is my stored function: DELIMITER $$ USE `mydatabase`$$ DROP FUNCTION IF EXISTS `SPLIT_STR`$$ CREATE definer=`thisus...@`%` FUNCTION `SPLIT_STR`( X VARCHAR(255), delim VARCHAR(12), pos INT ) RETURNS VARCHAR(255) CH

Re: Information_schema permission error

On 02/16/2010 17:30, Zakai Kinan wrote: I am getting this error - mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES. I am using 5.1.45. I don't understand what is causing this problem. Does anyone have a clue? TIA,

Uprading from mysql 5.0 to mysql 5.1

HI All Maybe you can assist. We are looking at upgrading a clients' MySQL 5.0 to version 5.1. They are running the following version: mysql Ver 14.12 Distrib 5.0.72sp1, for unknown-linux-gnu (x86_64) using readline 5.1

Re: mysql and tomcat

There is a file called /etc/rc.local. You can set the mysql start here, before starting tomcat during system or server reboot. regards anandkl On Wed, Feb 17, 2010 at 6:25 AM, Joerg Bruehe wrote: > Ted, all, > > > Ted Yu wrote: > > Hi, > > In our deployment, mysql needs to be started before tom

Re: mysql and tomcat

Ted, all, Ted Yu wrote: > Hi, > In our deployment, mysql needs to be started before tomcat automatically > after server restart. > > If you know how this order can be specified, please share. > > We use tomcat6 on Linux tyu-linux 2.6.18-128.2.1.el5 #1 SMP Tue Jul 14 > 06:36:37 EDT 2009 x86_64 x

Re: count children nodes

Thanks! 2010/2/16 Peter Brawley > David, > > >I need count the messages don'tread in a thread. > > Have a look at the edge list examples at > http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html. > > PB > > - > > David Arroyo Menendez wrote: > > Hello, > > I've the next table s