Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Jun 26th, 2012  |  syntax: None  |  size: 1.21 KB  |  hits: 11  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. dev@kent:~/src/sqlite$ mysql delpht -u dev
  2. Reading table information for completion of table and column names
  3. You can turn off this feature to get a quicker startup with -A
  4.  
  5. Welcome to the MySQL monitor.  Commands end with ; or \g.
  6. Your MySQL connection id is 43
  7. Server version: 5.1.49-1ubuntu8.1 (Ubuntu)
  8.  
  9. Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
  10. This software comes with ABSOLUTELY NO WARRANTY. This is free software,
  11. and you are welcome to modify and redistribute it under the GPL v2 license
  12.  
  13. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  14.  
  15. mysql> show tables;
  16. +------------------+
  17. | Tables_in_delpht |
  18. +------------------+
  19. | type3data1       |
  20. +------------------+
  21. 1 row in set (0.00 sec)
  22.  
  23. mysql> select * from type3data1;
  24. +--------+------+------+-------+----------+-----------+---------+------------+
  25. | typenr | mode | time | speed | capacity | freespeed | satflow | speedatcap |
  26. +--------+------+------+-------+----------+-----------+---------+------------+
  27. |      1 |   10 |   10 |    15 |     9999 |        30 |    1500 |         20 |
  28. +--------+------+------+-------+----------+-----------+---------+------------+
  29. 1 row in set (0.00 sec)