Advertisement
Guest User

Untitled

a guest
Aug 17th, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. ```sql
  2. ALTER TABLE `analytics` ADD `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY
  3.  
  4. SELECT count(distinct encounter_id) FROM `analytics`
  5.  
  6. CREATE INDEX registration_no ON analytics(registration_no(30));
  7.  
  8. CREATE INDEX subsection ON analytics(subsection(50));
  9.  
  10. CREATE INDEX fully_specified_name ON analytics(fully_specified_name(100));
  11. ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement