SQL-Browser

[Tools]  Database: `information_schema`  Table: `COLUMNS`

   show less  show more             Upload SQL file   Search   MySQl Documentation
The execution of SQL Statements can manipulate data. TAKE CARE! The Authors don't accept any liability for damaged or lost data.

MySQL-ERROR
MySQL says:
Access denied for user 'worldofmovies'@'192.168.10.4' to database 'information_schema'

Error in Query:
TRUNCATE `COLUMNS`

Table `COLUMNS` was deleted.

Table View

Edit Tables

40 Tables

View: compact   The Query contains 18 Columns
 # Name Rows Data_length Auto_increment Avg_row_length Max_data_length Comment Row_format Index_length Data_free Collation Create_time Update_time Check_time Create_options Version Engine Checksum
  edit  empty  empty and reset indexes  delete  1. 
0.00 B
384.00 B
62.69 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=174762
10
MEMORY
  edit  empty  empty and reset indexes  delete  2. 
0.00 B
231.00 B
63.72 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=290514
10
MEMORY
  edit  empty  empty and reset indexes  delete  3. 
0.00 B
195.00 B
62.40 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=344148
10
MEMORY
  edit  empty  empty and reset indexes  delete  4. 
0.00 B
0.00 B
256.00 TB
Dynamic
1.00 KB
0.00 B
utf8_general_ci
2018-07-19 07:51:50
2018-07-19 07:51:50
max_rows=11210
10
MyISAM
  edit  empty  empty and reset indexes  delete  5. 
0.00 B
2.50 KB
63.92 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=26163
10
MEMORY
  edit  empty  empty and reset indexes  delete  6. 
0.00 B
490.00 B
63.23 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=136956
10
MEMORY
  edit  empty  empty and reset indexes  delete  7. 
0.00 B
0.00 B
256.00 TB
Dynamic
1.00 KB
0.00 B
utf8_general_ci
2018-07-19 07:51:50
2018-07-19 07:51:50
max_rows=2475
10
MyISAM
  edit  empty  empty and reset indexes  delete  8. 
0.00 B
2.61 KB
63.93 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=25068
10
MEMORY
  edit  empty  empty and reset indexes  delete  9. 
0.00 B
3.19 KB
63.92 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=20535
10
MEMORY
  edit  empty  empty and reset indexes  delete  10. 
0.00 B
3.19 KB
63.92 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=20535
10
MEMORY
  edit  empty  empty and reset indexes  delete  11. 
0.00 B
4.53 KB
63.96 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=14472
10
MEMORY
  edit  empty  empty and reset indexes  delete  12. 
0.00 B
0.00 B
256.00 TB
Dynamic
1.00 KB
0.00 B
utf8_general_ci
2018-07-19 07:51:50
2018-07-19 07:51:50
max_rows=24200
10
MyISAM
  edit  empty  empty and reset indexes  delete  13. 
0.00 B
0.00 B
256.00 TB
Dynamic
1.00 KB
0.00 B
utf8_general_ci
2018-07-19 07:51:50
2018-07-19 07:51:50
max_rows=22317
10
MyISAM
  edit  empty  empty and reset indexes  delete  14. 
0.00 B
0.00 B
256.00 TB
Dynamic
1.00 KB
0.00 B
utf8_general_ci
2018-07-19 07:51:50
2018-07-19 07:51:50
max_rows=45313
10
MyISAM
  edit  empty  empty and reset indexes  delete  15. 
0.00 B
0.00 B
256.00 TB
Dynamic
1.00 KB
0.00 B
utf8_general_ci
2018-07-19 07:51:50
2018-07-19 07:51:50
max_rows=95596
10
MyISAM
  edit  empty  empty and reset indexes  delete  16. 
0.00 B
308.00 B
63.18 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=217885
10
MEMORY
  edit  empty  empty and reset indexes  delete  17. 
0.00 B
4.70 KB
63.97 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=13940
10
MEMORY
  edit  empty  empty and reset indexes  delete  18. 
0.00 B
0.00 B
256.00 TB
Dynamic
1.00 KB
0.00 B
utf8_general_ci
2018-07-19 07:51:50
2018-07-19 07:51:50
max_rows=2334
10
MyISAM
  edit  empty  empty and reset indexes  delete  19. 
0.00 B
3.38 KB
63.85 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=19373
10
MEMORY
  edit  empty  empty and reset indexes  delete  20. 
0.00 B
2.13 KB
63.85 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=30798
10
MEMORY
  edit  empty  empty and reset indexes  delete  21. 
0.00 B
3.19 KB
63.92 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=20535
10
MEMORY
  edit  empty  empty and reset indexes  delete  22. 
0.00 B
3.19 KB
63.92 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=20535
10
MEMORY
  edit  empty  empty and reset indexes  delete  23. 
0.00 B
5.62 KB
63.92 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=11665
10
MEMORY
  edit  empty  empty and reset indexes  delete  24. 
0.00 B
9.23 KB
63.95 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=7101
10
MEMORY
  edit  empty  empty and reset indexes  delete  25. 
0.00 B
6.79 KB
63.99 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=9654
10
MEMORY
  edit  empty  empty and reset indexes  delete  26. 
0.00 B
2.45 KB
63.80 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=26800
10
MEMORY
  edit  empty  empty and reset indexes  delete  27. 
0.00 B
2.32 KB
63.89 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=28292
10
MEMORY
  edit  empty  empty and reset indexes  delete  28. 
0.00 B
0.00 B
256.00 TB
Dynamic
1.00 KB
0.00 B
utf8_general_ci
2018-07-19 07:51:50
2018-07-19 07:51:50
max_rows=2277
10
MyISAM
  edit  empty  empty and reset indexes  delete  29. 
0.00 B
1.94 KB
63.81 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=33790
10
MEMORY
  edit  empty  empty and reset indexes  delete  30. 
0.00 B
0.00 B
256.00 TB
Dynamic
1.00 KB
0.00 B
utf8_general_ci
2018-07-19 07:51:50
2018-07-19 07:51:50
max_rows=27742
10
MyISAM
  edit  empty  empty and reset indexes  delete  31. 
0.00 B
6.69 KB
63.96 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=9794
10
MEMORY
  edit  empty  empty and reset indexes  delete  32. 
0.00 B
4.43 KB
63.97 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=14801
10
MEMORY
  edit  empty  empty and reset indexes  delete  33. 
0.00 B
257.00 B
62.30 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=261123
10
MEMORY
  edit  empty  empty and reset indexes  delete  34. 
0.00 B
599.00 B
63.89 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=112034
10
MEMORY
  edit  empty  empty and reset indexes  delete  35. 
0.00 B
29.00 B
58.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=2314098
10
MEMORY
  edit  empty  empty and reset indexes  delete  36. 
0.00 B
25.00 B
50.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=2684354
10
MEMORY
  edit  empty  empty and reset indexes  delete  37. 
0.00 B
30.51 KB
63.97 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=2147
10
MEMORY
  edit  empty  empty and reset indexes  delete  38. 
0.00 B
29.00 B
58.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=2314098
10
MEMORY
  edit  empty  empty and reset indexes  delete  39. 
0.00 B
25.00 B
50.00 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=2684354
10
MEMORY
  edit  empty  empty and reset indexes  delete  40. 
0.00 B
6.51 KB
63.97 MB
Fixed
0.00 B
0.00 B
utf8_general_ci
2018-07-19 07:51:50
max_rows=10062
10
MEMORY