View source for Documentation:MySQL–notes to support the use of MySQL with MDriven

<message>Write the content here to display this box</message>
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 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
Ok – now, we have the database – switch back to MDriven:

We want to use the my1 db:

[[File:Mysql_-_1.png|frameless|411x411px]]

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 database.
If you get this error:

[[File:Mysql_-_2.png|frameless|312x312px]]

… it is due to the SupportsFilteredIndex setting :

[[File:Mysql_-_3.png|border|frameless|266x266px]]

Change it to false.

Another thing that differs from SqlServer is 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:<blockquote>SqlTopKeyword – set this to empty string</blockquote><blockquote>SqlTopQuerySuffix – set this to limit {0}</blockquote>like this:
[[File:Mysql - 4.png|none|frame|248x248px]]

From today onward, these settings are automatically applied when you press the MySql 5.0 Setup option found here:

[[File:Mysql_-_5.png|border|frameless|251x251px]]

{{Edited|July|12|2025}}


[[Category:Data and Persistence]]
[[Category:Default mappers and type mapping notes]]
[[Category:Intermediate-Friendly]]
[[Category:Priority 60]]