Posts by jtomaszon • 113 points
4 posts
-
0
votes1
answer45
viewsA: MYSQL 5.6 does not recognize the query as it should
I don’t think you need to put too much sub-query. You can use UNION and split your query in two so you don’t have to reinvent the wheel mysql> set @date = '2018-11-02'; Query OK, 0 rows affected…
-
0
votes2
answers95
viewsA: problems with graphical mode initialization
First, try to take out what you added (delete the line that defines the PATH variable in .bashrc) to recover your graphic mode. After that, editing the PATH variable has to be done the way @vrcca…
-
4
votes7
answers8794
viewsA: How to Convert Mysql Database?
I recommend another approach. After you take a full backup, you can collect the differences in binlogs The way to do incremental backups of your Mysql Server I recommend reading (in English)…
-
7
votes5
answers74978
viewsA: How to get the table name and attributes of a Mysql database?
The correct is to make a query in the INFORMATION_SCHEMA database. You will get data like table type, record size avg, names and Storage Engine. DESC INFORMATION_SCHEMA.TABLES; It will give you a…