Page 3 of 7
Re: MySql revisited
Posted: Mon Jul 24, 2017 10:34 am
by dragancesu
Lesson two: first connect to MySQL database
Re: MySql revisited
Posted: Mon Jul 24, 2017 10:53 am
by dragancesu
If you want to use MySQL then you need to know the SQL language (without it you will not be able to)
http://www.sqlcourse.com/intro.html
This course is in English, if someone knows such a website in the Spanish, let him publish it
Re: MySql revisited
Posted: Mon Jul 24, 2017 3:08 pm
by lgcandia
In the following link you can find a very complete MySQL course, in particular, but it covers other areas of relational database modeling, common to all sql (ER) engines,
http://mysql.conclase.net
(Español)
En el siguiente link pueden encontrar un curso muy completo de MySQL, en particular, pero que cubre otros ámbitos del modelamiento de bases de datos relacionales, comunes a todos los motores sql (ER)
http://mysql.conclase.net
Re: MySql revisited
Posted: Tue Jul 25, 2017 10:40 am
by dragancesu
Thank you lgcandia
Lesson three: create user and database
Re: MySql revisited
Posted: Wed Jul 26, 2017 6:58 am
by dragancesu
Lesson four: create database and user from console
only for programers who like work in console
Note: You can access the MySQL database in multiple ways, there are consoles, many GUI tools and the program you write
Now it's time to look at MySQL reference manual and get familiar with SQL commands, the following lessons will be written by SQL commands
Re: MySql revisited
Posted: Thu Jul 27, 2017 2:46 pm
by Steed
Thanls a lot
Re: MySql revisited
Posted: Thu Jul 27, 2017 5:05 pm
by danielmaximiliano
Gracias Dragan
Re: MySql revisited
Posted: Sat Jul 29, 2017 2:28 pm
by bels79
I am very grateful, for his help.
Re: MySql revisited
Posted: Mon Aug 07, 2017 7:49 am
by dragancesu
Create MySQL table
Re: MySql revisited
Posted: Tue Aug 08, 2017 11:25 am
by dragancesu
I know that many would like to create and see how a program uses a MySQL database
If you are looking at it then look at \hmg.3.4.4\samples\hfcl\sql\mysql and you will see 3 folders and in each program demo.prg, mysql_1 is in Spanish, mysql_2,3 is in English
Note: first run the database, than copy the libmysql.dll file where program is, and make a program compilation
You will need a new connection to HeidiSQL because the programs create new databases: cadastros-spanish, namebook-english
p.s. If you use UniServerZ then you will find it on \core\mysql\bin