Could someone explain the logic of how case sensivity works on stored
procedure formal argument names?
Example:
CREATE PROCEDURE sp_Test ( IN col1 INT,
IN col2 INT )
BEGIN
INSERT INTO Table
SET COL1 = col1,
COL2 = col2;
END
We've found that this is problematic in some cases because of the
case insensitivity of column names, so I'm looking to see if there's
a general logic for how to name formal arguments that have a similar
name to a table column name (we ended up putting a '_' in the
beginning of the argument name).
thanks!
-lev
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]