Finally we have this wonderful tool for graphic design of our database.
Named one senses that this software is optimized for MySQL, but I think with the necessary modifications to use it for nothing prohibits other db servers all around the Net since the end export a sql to import in our SQL Server preferred.
The new release is the evolution of other software, "DB Designer," which since version 5 has just merged under mysql.
Unfortunately, when the compiled version is available only to those who use Ubuntu or other distributions of the family debian. For everyone else there is a link to download the source code recompile it:
Continue reading ...
Requirements: No requirements
I decided to write this tutorial, divided into several lessons, for the understanding of SQL, as by his instructions in a few steps we can execute commands that otherwise would need perhaps tens of lines of code, not counting the number of variables to use. In addition, the code we're going to write scripts that will be much more compact and readable by anyone. ... Continue reading
Requirements: no requirements
In this lesson we will present the SQL data types and provide a list of language keywords.
Data Types
There are three main types of data:
- Numbers;
- Characters;
- Time;
The first category as represented by integers or floating point.
In the second category we can enclose individual characters or strings.
In the latter case wrap the dates, times and intervals.
Continue reading ...
Recent Comments