Hot answers tagged schema
As it appears on the manual, use the option --difftype=sql in order to obtain the results as ALTER TABLEs. You have an example on a recent MySQL Performance Blog post: $ mysqldiff --force --difftype=sql \ --server1=root:email@example.com:21489 \ --server2=root:firstname.lastname@example.org:21490 \ employees:employees
How large do you expect the data to grow? No harm in keeping older data in the same table. You could plan to use partitioning and implement date range partitions (per year). Using WHERE statements is completely natural in SQL so don't consider this as "messy" at all.
I am reluctant to post this as an answer, because I don't have a tangible example to post with code, but I pointed Mark to Erland Sommarskog's great article, Giving Permissions through Stored Procedures, which has a section on Signing Procedures with Certificates. Cert signing seems to be the right approach for forcing data access through a procedure ...
From my answer on stack overflow: http://stackoverflow.com/a/29772759/2534472 Ok, let's have a look at your 2NF attempt: Student studentID | studentName | courseCode | modCode | resultCode Course courseCode | courseTitle Module modCode | modTitle | credits Let's talk about Student first. Your key cannot be studentID, because ...
Only top voted, non community-wiki answers of a minimum length are eligible