Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ```sql
- ALTER TABLE `analytics` ADD `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY
- SELECT count(distinct encounter_id) FROM `analytics`
- CREATE INDEX registration_no ON analytics(registration_no(30));
- CREATE INDEX subsection ON analytics(subsection(50));
- CREATE INDEX fully_specified_name ON analytics(fully_specified_name(100));
- ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement