Daniël’s database blog

The mysql client is a tool which I use every day as a DBA. Data recovery windows 8 I think it’s a great tool. Data recovery devices When I used a client of several other SQL and NoSQL databases I was quickly reminded of all the features of the mysql client. Moto g data recovery software Note that psql (PostgreSQL client) is also very nice.

Some other interesting things about the mysql client: It is build from the same mysql-server repository as MySQL Server.

Data recovery windows 10 The source is in client/mysql.cc. Database youtube In addition to the server version it also reports 14.14 as its version. H2 database console The previous version (14.13) was around the time of MySQL 5.1, so this version is mostly meaningless.

The version of the client is not tightly coupled with the server, in most situations a 5.6 client works fine with a 5.7 server and vice versa. Database browser Note that there might be some minor annoyances if you use an older client with a newer server. Database help For example: the 5.6 client doesn’t know about the new hint syntax, and considers the hint to be just a comment. Database vendors And comments are stripped by default, which results in the situation that the hint is not sent to the server.

The first one is that the ‘pager’ option doesn’t work on Windows. Database key The pager command is very useful (e.g. Data recovery live cd less, grep, etc). Data recovery clean room And cmd.exe isn’t the best terminal emulator ever.. Database view using a third party terminal emulator or PowerShell fixes that somewhat. Data recovery fort lauderdale And with PowerShell there are some other issues you might run into: MySQL uses UTF-8, and PowerShell uses UTF-16. Data recovery equipment tools While both can do charset conversions, this often makes things more difficult (for example: Bug #74817).

And if you’re working with spatial data, images or stored procedures then the mysql client is often not very helpful. Data recovery lab The graphical client, MySQL Workbench, is often much better suited in these cases. Data recovery online It has syntax highlighting, a spatial viewer and an image viewer. Database union It allows you to edit a SQL script and then execute it and edit it again and run it again. Data recovery houston I you try to do this with the history of the mysql client then the formatting gets lost. 7m database soccer basketball For working with SQL procedures, triggers, events, etc the solution is to edit it with your favourite editor and then source it. Create database link But for images and spatial data you often really have to use Workbench or something like QGIS.

Besides the CLI vs GUI difference there are some more differences in how most people use both tools. Database form For Workbench it is installed on a the client workstation and then uses a remote connection to the server. Data recovery process Workbench supports both the native SSL/TLS protocol and can tunnel through SSH.

This also has implications on configuration: The mysql client only needs to know how to connect to the local server. Database training Workbench needs configuration for every server. Data recovery hardware This makes the mysql client more useful if you are managing a large set of machines.

One of the more annoying situations with the mysql client is that you quickly want to select a row from a table or run that select query which was reported as being slow. Best database software So you ssh to the server and run the query… Database gui and then you suddenly get a lot of ‘weird’ characters on you screen. Data recovery technician This happens if you have binary columns (BLOB, varbinary, geometry) to store IP addresses, locations, binary UUID’s, photos, etc.

I made a patch to fix that. Database engine tuning advisor With the patch binary data is printed with hex literals (e.g. Data recovery rates 0x08080404 for the binary version of Database developer salary So this doesn’t break your terminal anymore and also allows you to copy the value to the subsequent query.

This might raise the question: why not display them as an IP address instead? I did make a patch to do that. Database backup and recovery The patch triggers this display if the column is varbinary with a length which matches an IPv4 or IPv6 address. Yale b database But we might store IP addresses in columns with other names and we might store values which are not an IP, but have the same length. Sybase database This would require a lot of configuration and configuration options. Database design And this would need more work for geometry types, binary UUID’s etc. Database 3 normal forms So for now I decided not to take that route.

It would be nice if the server would allow you to define an ‘ip6’ datatype which is just an alias for varbinary(16), but would be sent to the client. Database for dummies This could also be done with something like “SELECT c1::ip6” in the query. A database is a collection of Or the server really has to define UUID, and IP types. Library database Or user defined types. Database node Or both.

Also somewhat belonging in this list: I made a patch in 2015 which replaces the drawing characters (+ for corners, – for horizontal lines, | for vertical lines) with unicode drawing characters.

And what about the future? I don’t know, the mysql client might be replaced with MySQL Shell (mysqlsh), but for that to happen mysqlsh needs many improvements. Data recovery after format MySQL Workbench could replace some of it if it gets the capability to easily connect to many similar servers without much configuration. Database 2015 But should it? iTerm2 (macOS) now allows you to display images in the terminal, so if more terminal emulators would get this feature then it might make sense to get a image and geometry viewer in the client..