Search
 
SCRIPT & CODE EXAMPLE
 

SQL

SQL Error When Inserting Duplicate Values

CREATE TABLE Colleges (
  college_id INT NOT NULL UNIQUE,
  college_code VARCHAR(20) UNIQUE,
  college_name VARCHAR(50)
);

-- Inserting values to the Colleges table
INSERT INTO Colleges(college_id, college_code, college_name)
VALUES (1, "ARD12", "Star Public School"), (2, "ARD12", "Galaxy School");
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql select all columns and specific fields as 
Sql :: mysql view command 
Sql :: Data type and their numeric form 
Sql :: docker mysql connection refused 
Sql :: bigquery function 
Sql :: create database in sql 
Sql :: add 10 to all numbers in a column sql 
Sql :: raiserror sql 
Sql :: insert into with 3 tables 
Sql :: add column in table in sql 
Sql :: mysql install windows 10 
Csharp :: c# mark as deprecated 
Csharp :: c# print hello world 
Csharp :: unity how to change rotation 
Csharp :: center an image horizontally and vertically 
Csharp :: Vector3.signedangle not showin singed angle in unity 
Csharp :: c# replace crlf 
Csharp :: unity ray from mouse position 
Csharp :: c# center text 
Csharp :: convert base64 string to string c# 
Csharp :: c# generate random date 
Csharp :: c# for loop backwards 
Csharp :: linq unique count property 
Csharp :: c# output double with precision 
Csharp :: unity c# get bool from another script 
Csharp :: openfiledialog c# 
Csharp :: get random file in directory c# 
Csharp :: unity string array 
Csharp :: string to date vb 
Csharp :: how to chnage the Scale propery of rect tranform unity 
ADD CONTENT
Topic
Content
Source link
Name
4+9 =