MySql revisited

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

User avatar
dragancesu
Posts: 438
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 3 times
Been thanked: 58 times

Re: MySql revisited

Post by dragancesu » Mon Jul 24, 2017 10:34 am

Lesson two: first connect to MySQL database
Attachments
mysql part 2.zip
(1.48 MiB) Downloaded 53 times

User avatar
dragancesu
Posts: 438
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 3 times
Been thanked: 58 times

Post by dragancesu » Mon Jul 24, 2017 10:53 am

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

lgcandia
Posts: 1
Joined: Sun Jun 01, 2014 9:01 pm
Been thanked: 1 time

Post by lgcandia » Mon Jul 24, 2017 3:08 pm

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

User avatar
dragancesu
Posts: 438
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 3 times
Been thanked: 58 times

Post by dragancesu » Tue Jul 25, 2017 10:40 am

Thank you lgcandia

Lesson three: create user and database
Attachments
mysql part 3.zip
(1 MiB) Downloaded 51 times

User avatar
dragancesu
Posts: 438
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 3 times
Been thanked: 58 times

Post by dragancesu » Wed Jul 26, 2017 6:58 am

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
Attachments
mysql part 4.zip
(200.57 KiB) Downloaded 46 times

User avatar
Steed
Posts: 290
Joined: Sat Dec 12, 2009 3:40 pm
Been thanked: 2 times

Post by Steed » Thu Jul 27, 2017 2:46 pm

Thanls a lot

User avatar
danielmaximiliano
Posts: 2030
Joined: Fri Apr 09, 2010 4:53 pm
Location: Argentina
Has thanked: 77 times
Been thanked: 11 times
Contact:

Post by danielmaximiliano » Thu Jul 27, 2017 5:05 pm

Gracias Dragan 👌
*´¨)
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`.HMG : It's magic !
(¸.·``··*

Saludos / Regards
DaNiElMaXiMiLiAnO

Whatsapp. : +54901169026142
Telegram Name : DaNiElMaXiMiLiAnO

bels79
Posts: 36
Joined: Fri Sep 09, 2011 8:01 am
Has thanked: 1 time
Been thanked: 1 time

Post by bels79 » Sat Jul 29, 2017 2:28 pm

I am very grateful, for his help.

User avatar
dragancesu
Posts: 438
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 3 times
Been thanked: 58 times

Post by dragancesu » Mon Aug 07, 2017 7:49 am

Create MySQL table
Attachments
mysql5en.zip
(594.49 KiB) Downloaded 36 times

User avatar
dragancesu
Posts: 438
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 3 times
Been thanked: 58 times

Post by dragancesu » Tue Aug 08, 2017 11:25 am

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

Post Reply