As I already wrote here, a week later after reporting this bug
(because I change the datadir property on the config file my.ini)
I didn’t have a solution for error 1067 Can’t Start service on
MySQL 5.6.10. Now, you can read how I solve it!! How the error
1067 araise If you would like to raise the error, jsut install a
MySQL 5.6.10 server, and modify the path where data is saved on
the config file. Easy!! Trying in a new machine A pesar del
error, uno siempre piensa que...read more

Let’s keep on learning more and more about common-schema, and I
execute a query about redundant keys: SELECT * FROM
common_schema.redundant_keys; The result to this query informs me
that these keys are, literally, redundant, and the optimal
solution si to remove them. Also, the query has more interesting
information! After this, you think: “Well, if …

A few days ago, I needed to ask to all tables of a database about
what is the name of the primary key of each table. The solution
is easy, just using the data from the database
information_schema, and by retrieving the data for the selected
schema, this way: SELECT TABLE_NAME as table, COLUMN_NAME FROM …

Let’s keep on learning more about common_schema. In today’s
entrance, let’s introduce two more functionalities, very cool for
developers, because they are related with funcions and stored
procedures. Let’s begin with stored procedures (SP). If you need
a list of all stored procedures of our server, just type this SQL
sentence: SHOW PROCEDURE STATUS; However, …

I still have to spend some time investigating about what is
QueryScript, included on the Common_schema framework (I already
wrote about it). But today, let’s dive into two interesting
utilities. The utilities are two views. The first one is
table_charset. It’s a view in which you can identify the
characterset used in all text tables …

Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.