This video present how to create a tbale in a give database. You find out how use MySQL Shell to connect to the database and create into it a table, how to list the tables in the database. Go to previous parts of this tutorial to learn how create database or connect to the server. The post MySQL Tutorial part 3 – How to create a table in a database in MySQL appeared first on Dora's programming blog ..read more

In MySQL Tutorial part 1 you knew how to use the tool MySQL Shell to connect to MySQL server. Now, in part 2 you will find out how to create a database. This video presents 4 ways to do it. Watch, comment and subscribe LikeData channel. The post MySQL Tutorial part 2 – 4 ways to create a database in MySQL 8 appeared first on Dora's programming blog ..read more

In MySQL Tutorial part 1 you will learn how to use the tool MySQL Shell to connect to MySQL server and execute SQL scripts from file. Watch, comment and subscribe LikeData channel. The post MySQL Tutorial – part 1 – MySQL Shell – How to connect to server and execute SQL commands from file? appeared first on Dora's programming blog ..read more

Watch and comment new video on YouTube channel LikeData “Tutorial Data Modeling in SQL Power Architect – part 3 – next steps in creating physical model”:   The post Tutorial Data Modeling in SQL Power Architect – part 3 – next steps in creating physical model appeared first on Dora's programming blog ..read more

New video on YouTube channel LikeData “Tutorial Data Modeling in SQL Power Architect – part 2 – Creating physical model”:   The post Tutorial Data Modeling in SQL Power Architect – part 2 – Creating physical model appeared first on Dora's programming blog ..read more

For creating logical or phisical data models is used special software. One is SQL Power Architect, delivered also as Community edition, free to use. It is very useful and easy to use the tool. It allows you design any database data model phisical or logical and convert it in SQL script or concrete database in any database system like Oracle, MySQL, PostgreSQL, SQL Server. This softwareallows also transform ready database to the logical or phisical model. You can also transform the database from one database engine to another. In this part we start with installation. First go to the website of ..read more

I invite on my YouTube channel LikeData . You find in this place videos about databases, softwares, programming, algorithms or graphics , one or more a week. Watch, subscribe and share the content with others. You can be feel free to comment. I hope you find something interesting. I can be happy if my channel help you. The post Invitation to YouTube channel LikeData ! appeared first on Dora's programming blog ..read more

If you write an application to read a file existing in the current project, you have to put file name. However it is not sufficient. First you have to get path to the file. How do it? We begin with create very simple project to read file. My project I named net.dora.test In this project in src folder I create text file, it is named test.txt. Look at them: And it is content this file: It is a message from my first text file. As you notice in this file is only one line. In the next step I create main class to read this file. And look at the code: package net.dora.test; import java.io ..read more

In this post I show how in very simple way create module application in Java 10 using Eclipse IDE(Oxygen 3a). Open IDE and select from main menu  File->New->Java Project. In the New Java Project window in Project Name field write name of the module. Convention of naming module is the same as package: domain plus other words. This module I named with  m1 at the end, Click the Finish button. In Package Explorer right click name your module(project name) and choose New->Class to create your first class in this project. In the New Java Class window in Package field write name of package ..read more

In the post I wrote how install WildFly , today I desribe how integrate it with Netbeans IDE. After download and unzipped WildFly server, I go to the console to add a user for it. As you notice, first you have to go to the bin folder of wildFly server. Write add-user.bat and choose a option,writning it. Accept it clicking Enter. Write username and password for your server. Remember about rules for a password. In the next steps choose yes and at the end click Enter. It is all. You have a new user. In the next step go to the Netbeans IDE. From Services w tab select Servers and click on this n ..read more