2.2.2. Commands on multiple lines

Printer-friendly version

The commands can be expanded into several lines for convenience, especially when writing long SQL statements. The client does not send the SQL to the server until you find the semicolon, thus, the above command can be written as


Note the indicator that becomes mysql -> sign means that the command is not yet complete. They can also write multiple commands on one line, each must bear its respective semi-colon:


Are executed in the order they are written.Commands can be canceled with the combination \ c, so that the client will show the display to write the sentence again.

Mysql Indicators

Indicator
Meaning

mysql>
Awaiting a new sentence

->
The sentenceven not been completed;

">
A double-quoted string is not closed

'>
A string in single quotes are not closed

Good, I present below the tutorial by Matias Sebastian Alvarez , who also participates in the RedOpenBI ( profile here ). This tutorial has GNU FDL license allows free...
On 14 October the Congress held in Madrid, IBM Software 2010. An event that will help us identify solutions that can lead to innovation and to build a smarter world. Let us...
Before proceeding with the construction of the ETL processes for the rest of the dimensions of the project, we pause to explain the reason for choosing MySQL as a database...
If we did a survey among developers and users of the WWW, much better respond to the database for building web sites and applications is MySQL. Among the key issues are put...
As expected, the first BI tools adapted to the new iPad of Apple are appearing. Nothing like a dashboard application to exploit the Multitouch screen possibilities of this...
This is the presentation used Pere Rovira and Daniel Rodriguez in the Conversion Thursday last Thursday, which was on creating effective Dashboards. Simple, direct and...