Advanced Search

Split table MySQL

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. CREATE TABLE Bugs (
  2. bug_id SERIAL PRIMARY KEY,
  3. -- other columns
  4. date_reported DATE
  5. ) PARTITION BY HASH ( YEAR(date_reported) )
  6. PARTITIONS 4;

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.