In zrdata add a name to my table, and record in the diagram below to add a few, please give directions

CodePudding user response:

First you have to install MySQL for ODBC driver
The second you have to learn to structured query language (SQL), that is, SQL, at least will Create Table syntax
You have to learn to VB programming
3You have to learn to use ADO database operation, 4 at least ADODC control to use

CodePudding user response:

The

reference, on the third floor of the 1st floor response:

first you have to install MySQL for ODBC driver
The second you have to learn to structured query language (SQL), that is, SQL, at least will Create Table syntax
You have to learn to VB programming
34 you have to learn to use ADO database operation, at least will ADODC controls the use of

These functions are realized, VB are normally connect to the database, just don't know how to set up MySQL tables in VB, and insert a few records, for example

CodePudding user response:

Use the CREATE DATABASE, see https://dev.mysql.com/doc/refman/8.0/en/create-database.html

But because after creating the DB, and specify the user permission to work, I still use HeidiSQL or MySQL workbench to do