chrisknyfe
New Member
- Messages
- 7
- Reaction score
- 0
- Points
- 0
Hi x10,
So far, love the hosting. I'm on the corporate plan, and I want to run database creation scripts on it. First, I tried to run these scripts by copy-pasting into phpmyadmin's query browser. Delimiter commands seemed to malfunction and run my script in some kind of weird loop where it would repeat code between a delimiter command and the next semicolon three times before it caused an error.
So, I ditched that effort and tried to use the import feature. Once again, delimitier commands caused syntax errors.
It's looking like I won't be able to create triggers... this is a problem for me since I use triggers to enforce creation/revision dates, createdby/revisedby, and a table with two foreign keys to the same table which I want to enforce unique pairs of unordered foreign keys on.
Help?
Thanks,
Zach
So far, love the hosting. I'm on the corporate plan, and I want to run database creation scripts on it. First, I tried to run these scripts by copy-pasting into phpmyadmin's query browser. Delimiter commands seemed to malfunction and run my script in some kind of weird loop where it would repeat code between a delimiter command and the next semicolon three times before it caused an error.
So, I ditched that effort and tried to use the import feature. Once again, delimitier commands caused syntax errors.
It's looking like I won't be able to create triggers... this is a problem for me since I use triggers to enforce creation/revision dates, createdby/revisedby, and a table with two foreign keys to the same table which I want to enforce unique pairs of unordered foreign keys on.
Help?
Thanks,
Zach
. I don't have that much time right now to research it but I'll leave this open for a bit, please post back if you don't figure it out or if you do.