richard512/mysql_id_column.sql

Last active May 27, 2018 02:25

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/richard512/13da5d86940b204b4f39ea0d1a6372d5.js"></script>
Save richard512/13da5d86940b204b4f39ea0d1a6372d5 to your computer and use it in GitHub Desktop.

Download ZIP

MySQL Add Auto-Increment Primary Key Column (Unsigned BIGINT) to existing MySQL Table -- Useful when you want a unique identifier for each column

Raw

mysql_id_column.sql

ALTER TABLE `tablename` ADD COLUMN id BIGINT UNSIGNED AUTO_INCREMENT, ADD PRIMARY KEY `id` (`id`)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment