Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Confluence prism macro commandLineSql
servermysql
dialogTitleSQL command line
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)

...