MySql revisited
Moderator: Rathinagiri
- dragancesu
- Posts: 921
- Joined: Mon Jun 24, 2013 11:53 am
- DBs Used: DBF, MySQL, Oracle
- Location: Subotica, Serbia
Re: MySql revisited
Lesson two: first connect to MySQL database
- Attachments
-
- mysql part 2.zip
- (1.48 MiB) Downloaded 361 times
- dragancesu
- Posts: 921
- Joined: Mon Jun 24, 2013 11:53 am
- DBs Used: DBF, MySQL, Oracle
- Location: Subotica, Serbia
Re: MySql revisited
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
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
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
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
- dragancesu
- Posts: 921
- Joined: Mon Jun 24, 2013 11:53 am
- DBs Used: DBF, MySQL, Oracle
- Location: Subotica, Serbia
Re: MySql revisited
Thank you lgcandia
Lesson three: create user and database
Lesson three: create user and database
- Attachments
-
- mysql part 3.zip
- (1 MiB) Downloaded 323 times
- dragancesu
- Posts: 921
- Joined: Mon Jun 24, 2013 11:53 am
- DBs Used: DBF, MySQL, Oracle
- Location: Subotica, Serbia
Re: MySql revisited
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
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 331 times
- danielmaximiliano
- Posts: 2612
- Joined: Fri Apr 09, 2010 4:53 pm
- Location: Argentina
- Contact:
Re: MySql revisited
Gracias Dragan
*´¨)
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`. Harbour/HMG : It's magic !
(¸.·``··*
Saludos / Regards
DaNiElMaXiMiLiAnO
Whatsapp. := +54901169026142
Telegram Name := DaNiElMaXiMiLiAnO
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`. Harbour/HMG : It's magic !
(¸.·``··*
Saludos / Regards
DaNiElMaXiMiLiAnO
Whatsapp. := +54901169026142
Telegram Name := DaNiElMaXiMiLiAnO
Re: MySql revisited
I am very grateful, for his help.
- dragancesu
- Posts: 921
- Joined: Mon Jun 24, 2013 11:53 am
- DBs Used: DBF, MySQL, Oracle
- Location: Subotica, Serbia
- dragancesu
- Posts: 921
- Joined: Mon Jun 24, 2013 11:53 am
- DBs Used: DBF, MySQL, Oracle
- Location: Subotica, Serbia
Re: MySql revisited
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
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