Search
 
SCRIPT & CODE EXAMPLE
 

SQL

primary key multiple

CREATE TABLE Persons (
    Rollno int NOT NULL,
    FirstName varchar(30),
    LastName varchar(30) NOT NULL,
    class varhcar(20),
    Age int,
    CONSTRAINT PK_Student PRIMARY KEY (Rollno,LastName)
);
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql update two tables at once 
Sql :: sqlite get last 
Sql :: creating postgresSQL database using the the shell 
Sql :: adding constraints to columns SQL 
Sql :: mysql get last inserted id 
Sql :: ERROR 1046 (3D000): No database selected 
Sql :: adding generated time in row mysql workbench 
Sql :: update with inner join sql server 
Sql :: sql if clause within where clause 
Sql :: sql create database 
Sql :: sqlite unique 
Sql :: change magento database url usimg musql 
Sql :: como saber si tengo mysql instalado 
Sql :: mysql login to a specific database terminal 
Sql :: mysql delete database 
Sql :: sql query to select even numbers 
Sql :: select distinct postgres 
Sql :: query by column for substring sql 
Sql :: mysql datetime with timezone offset 
Sql :: sqlite unique multiple columns 
Sql :: average salary in sql 
Sql :: pgsql is not permitted to log in 
Sql :: run sql script from command line 
Sql :: df to sql pandas sql achemy 
Sql :: how to count the number of rows in sql 
Sql :: laravel eloquent get generated sql 
Sql :: How to insert Arabic characters into SQL database 
Sql :: postgres data location 
Sql :: sql select inside select 
Sql :: sql server port 
ADD CONTENT
Topic
Content
Source link
Name
2+9 =