Last active
May 10, 2018 12:59
-
-
Save lvturner/a9c09130a46b24039bbe6b66fe9691da to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ➜ ~ mysql -uroot-p | |
| Enter password: | |
| Welcome to the MySQL monitor. Commands end with ; or \g. | |
| Your MySQL connection id is 208 | |
| Server version: 5.7.22 Homebrew | |
| Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. | |
| Oracle is a registered trademark of Oracle Corporation and/or its | |
| affiliates. Other names may be trademarks of their respective | |
| owners. | |
| Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. | |
| mysql> create database excel_demo; | |
| Query OK, 1 row affected (0.00 sec) | |
| mysql> use excel_demo; | |
| Database changed | |
| mysql> create table prices(close float); | |
| Query OK, 0 rows affected (0.02 sec) | |
| mysql> insert into prices values(299.99); | |
| Query OK, 1 row affected (0.01 sec) | |
| mysql> insert into prices values(300.11); | |
| Query OK, 1 row affected (0.01 sec) | |
| mysql> insert into prices values(239.112); | |
| Query OK, 1 row affected (0.01 sec) | |
| mysql> insert into prices values(324.32); | |
| Query OK, 1 row affected (0.01 sec) | |
| mysql> insert into prices values(422.42); | |
| Query OK, 1 row affected (0.00 sec) | |
| mysql> select * from prices; | |
| +---------+ | |
| | close | | |
| +---------+ | |
| | 299.99 | | |
| | 300.11 | | |
| | 239.112 | | |
| | 324.32 | | |
| | 422.42 | | |
| +---------+ | |
| 5 rows in set (0.00 sec) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment