Guest User

banco de dados pcvolumeGTAfinal_estavel

a guest
Dec 4th, 2019
446
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.92 KB | None | 0 0
  1. bem10jfx.blogspot.com
  2. Enter password: ********
  3. Welcome to the MySQL monitor.  Commands end with ; or \g.
  4. Your MySQL connection id is 2
  5. Server version: 5.0.91-community MySQL Community Edition (GPL)
  6. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  7.  
  8. mysql> show databases;
  9. +--------------------+
  10. | Database           |
  11. +--------------------+
  12. | information_schema |
  13. | codigosir          |
  14. | mysql              |
  15. | phpmyadmin         |
  16. | test               |
  17. +--------------------+
  18. 5 rows in set (0.17 sec)
  19.  
  20. mysql> use codigosir;
  21. Database changed
  22. mysql> show tables;
  23. +---------------------+
  24. | Tables_in_codigosir |
  25. +---------------------+
  26. | comandoir           |
  27. +---------------------+
  28. 1 row in set (0.02 sec)
  29.  
  30. mysql> drop database codigosir;
  31. Query OK, 1 row affected (0.35 sec)
  32.  
  33. mysql> create database codigosir;
  34. Query OK, 1 row affected (0.06 sec)
  35.  
  36. mysql> use codigosir;
  37. Database changed
  38. mysql> create table comandoir( controle varchar(20), start varchar(12), cima var
  39. char(12), direita varchar(12), baixo varchar(12), esquerda varchar(12), azul var
  40. char(12), gren varchar(12), yellow varchar(12), red varchar(12), power varchar(1
  41. 2), selects varchar(12), menu varchar(12), ok  varchar(12), volumemais varchar(1
  42. 2), volumemenos varchar(12), tec1 varchar(12), tec2 varchar(12), tec3 varchar(12
  43. ), tec4 varchar(12), tec5 varchar(12), tec6 varchar(12), tec7 varchar(12), tec8
  44. varchar(12), tec9 varchar(12), tec0 varchar(12), mousecima varchar(12), mousebai
  45. xo varchar(12), mousedireita varchar(12) , mouseesquerda varchar(12), mouseclick
  46. direita varchar(12), mouseclickesquerda varchar(12), mousepress varchar(12), vlR
  47. esultado varchar(12));
  48. Query OK, 0 rows affected (0.08 sec)
  49.  
  50. mysql> show tables;
  51. +---------------------+
  52. | Tables_in_codigosir |
  53. +---------------------+
  54. | comandoir           |
  55. +---------------------+
  56. 1 row in set (0.00 sec)
  57.  
  58. mysql> ..
  59.     -> ..
  60.     -> this
Add Comment
Please, Sign In to add comment