View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001641 | Database Workbench v6 | General | public | 2018-09-17 11:16 | 2021-12-03 12:27 |
Reporter | Svein Erling Tysvær | Assigned To | |||
Priority | normal | Severity | feature | Reproducibility | N/A |
Status | closed | Resolution | open | ||
Product Version | 5.4.4 | ||||
Fixed in Version | 6.0 | ||||
Summary | 0001641: SELECTs will output to 'server output' window when executing script in Script Editor | ||||
Description | MySQL supports variables, and DBW supports it in the query editor. E.g. I can run SELECT @MyVar := MyField FROM MyTable WHERE ...; and after that issue SELECT @MyVar to see the value of the last record returned in the first query if using SQL Editor, Single SQL. It is also possible to run both commands after eachother using the SQL Editor, SQL Script, but this flap doesn't contain an output window like the SQL Editor, Single SQL, so the last value of @MyVar isn't shown. Being able to run SQL Editor, SQL Script with an output window like SQL Editor, Single SQL could be a tiny improvement to DBW. | ||||
Tags | No tags attached. | ||||
has duplicate | 0000247 | closed | Martijn Tonies | show SELECT results in script output |
|
The output is not a grid, it outputs 1 column per line, for all columns. Don't use this as a method of output hundreds of rows. ;) |
Date Modified | Username | Field | Change |
---|---|---|---|
2018-09-17 11:16 | Svein Erling Tysvær | New Issue | |
2018-09-17 17:09 | Martijn Tonies | Status | new => acknowledged |
2021-08-16 09:28 | Martijn Tonies | Project | Database Workbench v5 => Database Workbench v6 |
2021-08-16 09:30 | Martijn Tonies | Status | acknowledged => resolved |
2021-08-16 09:30 | Martijn Tonies | Category | MySQL Module => General |
2021-08-16 09:30 | Martijn Tonies | Summary | Output window also in the script editor not only for single SQLs? => SELECTs will output to 'server output' window when executing script in Script Editor |
2021-08-16 09:30 | Martijn Tonies | Note Added: 0000556 | |
2021-08-16 09:30 | Martijn Tonies | Fixed in Version | => 6.0 |
2021-09-20 13:38 | Martijn Tonies | Relationship added | has duplicate 0000247 |
2021-12-03 12:27 | Martijn Tonies | Status | resolved => closed |