Although we have spoken several times of this framework MariaDB MySQL-today a new feature, I bring very useful when you need to perform repetitive tasks based on consultations. It is… Read More »Common_schema: repetitive tasks with foreach
This entrance is dedicated to a new website for learning #BigData in spanish: SoyData.net. What is SoyData.net It is a collaborative online training platform on all matters relating to data… Read More »Learning #MySQL at SoyData.Net
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… Read More »Solution to Error 1067 Can’t start the server on MySQL
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… Read More »Common-schema: redundant keys on MySQL-MariaDB
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,… Read More »Listing primary keys of a database in MySQL-MariaDB
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… Read More »common schema. Listing Functions and stored procedures with its dependencies
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.… Read More »More Common_Schema utilities
the more I program for MySQL – MariaDB, the more I need templates. That’s my truth, because I am learning tips and tricks I want to add to my code.… Read More »Stored Procedure Templates for MySQL-MariaDB
One feature I really like about Common_schema is writtin messages that describe what is happening on a procedure during execution, and once finished, show the message created splitting in several… Read More »Prettify Messages on MySQL-MariaDB with Common_schema
In this post I’ll show you two interesting utilities from common_schema framework: calculete the size by engine (MyIsam, InnoDB, Memory, …), and the size of each schema. Just type this:… Read More »Common_schema: Data size by engine and by schema
