-
Passing table names to functions as parameters
I have a function to split a string in MYSQL.
After splitting the string I store them in a temporary table.
I plan to use it in different SPs.
So I plan to pass the string to be split, the delimiter and the table name.
Please help me. If you know of some link where I can learn more of this, please get me the link.
-
Prepared Statements
You could try to use prepared statements
first :
SET @sql = CONCAT("INSERT INTO TABLE ",tblname," VALUES('",string,"')");
PREPARE stmnt FROM @sql;
EXECUTE stmnt;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|