Timeline for How can we create a table from stored procedure?
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 1, 2015 at 20:51 | comment | added | Jehad Keriaki |
The answers below tell you how to create the table. However, regarding the error you are getting, it is because you didn't enclose the name in quotes. i.e. try create_tb_one('first');
|
|
| Sep 1, 2015 at 17:48 | answer | added | greenlitmysql | timeline score: 2 | |
| Sep 1, 2015 at 14:14 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 |
deleted 1 character in body; edited title
|
| Sep 1, 2015 at 14:09 | answer | added | RolandoMySQLDBA | timeline score: 1 | |
| Sep 1, 2015 at 13:40 | review | Close votes | |||
| Sep 1, 2015 at 14:33 | |||||
| Sep 1, 2015 at 13:34 | comment | added | Andriy M | You cannot parametrise a table name like that – therefore, you will certainly need dynamic SQL. Question is, though, whether you really need to use a stored procedure to create tables. What's wrong with creating them manually beforehand? Or why can't the calling application build an ad-hoc CREATE TABLE statement and pass it to MySQL for execution? | |
| S Sep 1, 2015 at 13:22 | history | suggested | oNare | CC BY-SA 3.0 |
Improved formatting.
|
| Sep 1, 2015 at 13:07 | review | Suggested edits | |||
| S Sep 1, 2015 at 13:22 | |||||
| Sep 1, 2015 at 12:41 | review | First posts | |||
| Sep 1, 2015 at 12:51 | |||||
| Sep 1, 2015 at 12:40 | history | asked | Kerati Naveen | CC BY-SA 3.0 |