MySQL Sidu FAQ and Tutorial
Q: How can I save MySQL connection to server?
A: Please check folder user and any files in this folder RW by your apache user
Q: Why it is an err: select now();##comment here?
A: It is an MySQL error, not Sidu error. You can put your SQL script comment at a new line
Q: Can I run multiple SQL scripts?
A: Yes you can. Make sure each SQL terminated by semicolon and new line
Q: I have inserted several rows and clicked save, but I want to edit the newly-added rows, why it gives me an MySQL error?
A: Sidu uses cache, please refresh data in this case, by clicking on table name or sorting data, will refresh cache
Q: Can I export data to xls as well?
A: Yes you can. Try to seperate fields by "," and lines by "\n" and save result as .csv file
Q: NULL or NOT NULL?
A: NULL does not produce any benefit. So it is a good idea to avoid using NULL in your data. Only table without primary key/unique key will be affected in GUI mode. You can still handle your NULL in SQL windows. The import/export will be affected.
Q: How can I alter table, column or index?
A: Please copy templates (Fn+T) into SQL window, edit and run. I'd like to keep you smart
