more quick actions
minimize quick actions
Topic starter
MySQL is the world's most popular open source database and became the property of Oracle in January 2010 when it was acquired from Sun Microsystems.
Oracle offers us an ADO.NET provider for the different versions of MySQL.
-- How to install MySQL ADO.NET Provider --
1. Create an account to download Windows (X86, 32-bit) MSI Installer or click "No thanks, just start my download" link.
mysql-connector-net-X.X.XX.msi => https://dev.mysql.com/downloads/connector/net/
2. Execute MSI Installer to do a "Typical" installation.
The installation is complete !!
The provider is now visible in PcVue SQL Connection (Data source : Other providers).
-- Connection string --
. Connection string without database:
server=127.0.0.1;user id=arde;password=MySecret
. Connection string with database:
server=127.0.0.1;user id=arde;password=MySecret;database=MyDatabase;
-- Sql queries --
. Create a Database
CREATE DATABASE `MyDatabase`
. Create a table
CREATE TABLE `MyTable` (col1 INT)
. Insert a value
INSERT INTO `MyTable` (col1) VALUES (1)
. Display table content
SELECT * FROM `MyTable`
Found more samples here
Posted : 08/12/2022 12:18 am