Algorithmic Trading Group Forum

Algorithmic Trading Group Forum
https://www.algotradinggroup.com/cgi-bin/yabb2/YaBB.pl
Trading Strategies >> Software Infrastructure >> Advanced MySQL Trigger Help
https://www.algotradinggroup.com/cgi-bin/yabb2/YaBB.pl?num=1287099624

Message started by Ryan on 10/15/10 at 00:40:23

Title: Advanced MySQL Trigger Help
Post by Ryan on 10/15/10 at 00:40:23

I am working on setting up a mysql database to store all of my historical stock data. I want to organize it such that there is a table of contents table that contains the ticker, name, and date range of prices for each security in the database. I also want this table to have a trigger that creates a new table each time a new row is inserted. This table name would be based on a the primary key of the new row and would be used to store the price data for the security listed in the row.

My proplem is that mysql does not allow triggers to create tables. When I try to create a trigger such as this I get the following error.

Error 1422: Explicit or implicit commit is not allowed in stored function or trigger.

Does anyone know a workaround for this limitation?