Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
lab4 [2018-11-23 13:46] Joakim Forsgren |
lab4 [2018-11-23 14:18] Joakim Forsgren |
||
|---|---|---|---|
| Line 10: | Line 10: | ||
| Från {{ :login.zip |lektion}} | Från {{ :login.zip |lektion}} | ||
| + | <code mysql> | ||
| + | # Detta kom inte med... | ||
| + | ALTER TABLE `Users` | ||
| + | ADD PRIMARY KEY (`UserID`), | ||
| + | ADD UNIQUE KEY `EMail` (`EMail`); | ||
| + | | ||
| + | ALTER TABLE `Users` | ||
| + | MODIFY `UserID` int(11) NOT NULL AUTO_INCREMENT; | ||
| + | COMMIT; | ||
| + | </ | ||
| == Nytt!== | == Nytt!== | ||