Documentation:MySQL–notes to support the use of MySQL with MDriven
Hand on heart – I use SQLServer most of the time. When I am asked questions about MySQL, I always need to step out of my comfort zone.
This article can hopefully help me in my efforts with this and be useful to you as well.
- Make sure you have MySql installed – the server and not only the connectors; you need both for local work.
- Start a cmd window as an admin and cd to c:\program files\MySql\MySql server <version>\bin
- Start mysql.exe – if asked for a password, it is probably “root”.
- You should now have a mysql> prompt
- Create a database called my1: CREATE DATABASE my1;
- Use a database called my1: USE my1
Okay – now, we have the database – switch back to MDriven:
We want to use the my1 db:
Change to PersistenceMapperMySql, and make sure it is used in EcoProject1.PersistenceMapper= PersistenceMapperMySql1. Set its connection string to “server=localhost;database=my1;User Id=root;password=root; Charset=utf8”
- Generate code if you have not already
- Compile if you have not already
- Then, generate the database.
If you get this error:
… it is due to the SupportsFilteredIndex setting:
Change it to false.
Another thing that differs from SqlServer is that the Top keyword, as in “select top 15 * from stuff”, is written as “select * from stuff limit 15” in MySQL.
This is fixed by changing these properties of the persistenceMapperMySQL.SqlDatabaseConfig:
SqlTopKeyword – set this to an empty string
SqlTopQuerySuffix – set this to limit {0}
Like this:
From today onward, these settings are automatically applied when you press the MySql 5.0 Setup option found here:
