/SQL/Add primary key to existing table sql

Add primary key to existing table sql

alter table Persion add primary key (persionId,Pname,PMID)

Source: stackoverflow.com

Change primary key sql

ALTER TABLE <Table_Name>
DROP CONSTRAINT <constraint_name>

ALTER TABLE <Table_Name>
ADD CONSTRAINT <constraint_name> PRIMARY KEY (<Column1>,<Column2>)

Source: stackoverflow.com

Add primary key to existing table sql

ALTER TABLE `tblauto`
  ADD PRIMARY KEY (`id`);

--

Add primary key to database sql

CREATE TABLE Persons (
    ID int NOT NULL,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int,
    PRIMARY KEY (ID)
);

Similar codes

2 votes367 views1 answer
Python sql
SQL
2 votes317 views1 answer
Add 2 hours to current time in MySQL
SQL
0 vote341 views1 answer
Sql change primary key to composite key
SQL
1 vote325 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
2 votes389 views3 answers
Sql delete duplicate
SQL
0 vote347 views1 answer
Running mysql from bash sc
SQL
0 vote320 views1 answer
Tsql generate rows
SQL
0 vote339 views3 answers
Duplicate row mysql
SQL
0 vote319 views1 answer
Sql order by number not ordered
SQL
0 vote418 views1 answer
How to show current database in mysql
SQL