| Confluence prism macro commandLineSql | ||||
|---|---|---|---|---|
| ||||
CREATE TABLE user (
(con)username VARCHAR(30) NOT NULL,
(con)email VARCHAR(30) NOT NULL
(con));
(out)Query OK, 0 rows affected (0.06 sec)
(out)
insert into people
(con)values ('User 1', 'user@mail.com');
(out)Query OK, 1 row affected (0.03 sec)
(out)
select *
(con)from user
(con)order by username;
(out)+----------+---------------+
(out)| username | email |
(out)+----------+---------------+
(out)| User 1 | user@mail.com |
(out)+----------+---------------+
(out)1 row in set (0.00 sec) |
| Info |
|---|
The example above demonstrates how the macro "Prism command line highlighter ( |
...
SQL)" renders a |
...
SQL command line including the (input) command lines and the corresponding output. |
Macro content used to render the command line above:
...