Skip to content

Instantly share code, notes, and snippets.

View Ajith-develpoer's full-sized avatar

Ajith-develpoer

View GitHub Profile
@Ajith-develpoer
Ajith-develpoer / complexity.csv
Created October 21, 2020 02:59
tables in medium
Operation Averge Case Worst Case
Copy O(n) O(n)
Append[1] O(1) O(1)
Insert O(n) O(n)
Get item O(1) O(1)
Set item O(1) O(1)
Delete item O(n) O(n)
Iteration O(n) O(n)
Get slice O(k) O(k)
Del slice O(n) O(n)
@Ajith-develpoer
Ajith-develpoer / delete.csv
Created October 17, 2020 08:44
table in medium
student_id student_name student_dept
1 Sam IT
2 Mark CSE
3 Tom ECE
4 Jerry CIVIL
6 Rahul EEE
7 Pandya MECH
@Ajith-develpoer
Ajith-develpoer / update.csv
Created October 17, 2020 08:39
Table in medium
student_id student_name student_dept
1 Sam IT
2 Mark CSE
3 Tom ECE
4 Jerry CIVIL
5 Wood NULL
6 Rahul EEE
7 Pandya MECH
@Ajith-develpoer
Ajith-develpoer / NOT.csv
Created October 17, 2020 08:31
table in medium
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
student_dept
CSE
ECE
EEE
MECH
@Ajith-develpoer
Ajith-develpoer / OR.csv
Created October 17, 2020 08:21
Table in medium
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
student_dept
MECH
@Ajith-develpoer
Ajith-develpoer / and.csv
Created October 17, 2020 08:15
tables in medium
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
student_name
Rahul
@Ajith-develpoer
Ajith-develpoer / where.csv
Created October 17, 2020 08:07
table in medium
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
student_dept
ECE
@Ajith-develpoer
Ajith-develpoer / modify.csv
Created October 17, 2020 07:51
Tables in medium
field type
student_id int
student_name varchar(20)
student_dept char(10)
@Ajith-develpoer
Ajith-develpoer / drop.csv
Created October 17, 2020 07:46
TABLE IN MEDIUM
student_id student_name student_dept
1 Sam IT
2 Mark CSE
3 Tom ECE
4 Jerry NULL
5 Wood NULL
6 Rahul EEE
7 Pandya MECH
@Ajith-develpoer
Ajith-develpoer / Add.csv
Created October 17, 2020 07:41
tables in medium
student_id student_name student_dept student_grade
1 Sam IT NULL
2 Mark CSE NULL
3 Tom ECE NULL
4 Jerry NULL NULL
5 Wood NULL NULL
6 Rahul EEE NULL
7 Pandya MECH NULL