MySql revisited

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

User avatar
dragancesu
Posts: 920
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: MySql revisited

Post by dragancesu »

Lesson two: first connect to MySQL database
Attachments
mysql part 2.zip
(1.48 MiB) Downloaded 353 times
User avatar
dragancesu
Posts: 920
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: MySql revisited

Post 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
lgcandia
Posts: 1
Joined: Sun Jun 01, 2014 9:01 pm

Re: MySql revisited

Post 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
User avatar
dragancesu
Posts: 920
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: MySql revisited

Post by dragancesu »

Thank you lgcandia

Lesson three: create user and database
Attachments
mysql part 3.zip
(1 MiB) Downloaded 316 times
User avatar
dragancesu
Posts: 920
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: MySql revisited

Post 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
Attachments
mysql part 4.zip
(200.57 KiB) Downloaded 325 times
User avatar
Steed
Posts: 427
Joined: Sat Dec 12, 2009 3:40 pm

Re: MySql revisited

Post by Steed »

Thanls a lot
User avatar
danielmaximiliano
Posts: 2607
Joined: Fri Apr 09, 2010 4:53 pm
Location: Argentina
Contact:

Re: MySql revisited

Post by danielmaximiliano »

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

Saludos / Regards
DaNiElMaXiMiLiAnO

Whatsapp. := +54901169026142
Telegram Name := DaNiElMaXiMiLiAnO
bels79
Posts: 37
Joined: Fri Sep 09, 2011 8:01 am
DBs Used: DBF, MySQL

Re: MySql revisited

Post by bels79 »

I am very grateful, for his help.
User avatar
dragancesu
Posts: 920
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: MySql revisited

Post by dragancesu »

Create MySQL table
Attachments
mysql5en.zip
(594.49 KiB) Downloaded 318 times
User avatar
dragancesu
Posts: 920
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: MySql revisited

Post 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
Post Reply