I think you've got some of the best videos on programming in existence. A major bonus with your channel is that you have so many programming languages. Right now I'm learning Python and SQL. When it's time for some other language I know which channel to check out :)
Hi Mike, I have a question in the section you defined the primary key for "works_with" table. As I understand we can define the primary key on a column in which the values are unique, but in branch_supplier table we have duplicated rows which could not set them to primary key ``` mysql> alter table branch_supplier add primary key(branch_id); ERROR 1062 (23000): Duplicate entry '2' for key 'PRIMARY ```
You are awesome man .how did u go unnoticed. People with shit contents getting more publicity than u. You deserve more.
I think you've got some of the best videos on programming in existence. A major bonus with your channel is that you have so many programming languages. Right now I'm learning Python and SQL. When it's time for some other language I know which channel to check out :)
Hey Mike! you are such an outstanding :)
Hi Mike,
Thanks for the awesome course, it's really useful. I have a question please. How can I import csv file to a database on popsql?
Great!
Hi Mike,
I have a question in the section you defined the primary key for "works_with" table. As I understand we can define the primary key on a column in which the values are unique, but in branch_supplier table we have duplicated rows which could not set them to primary key
```
mysql> alter table branch_supplier add primary key(branch_id);
ERROR 1062 (23000): Duplicate entry '2' for key 'PRIMARY
```
For works_with table, primary key is actually a composite key with emp_id and client_id. You can define it as PRIMARY KEY (emp_id, client_id)
The best tutorial of SQL I’ve found and watched so far! Please record more videos on SubQueries (nested functions), they are still very blurry to me 😄
How do you transfer file excel table into this popsql database?
Is the job still demand for SQL database?
Hey Mike if you see this comment please make a tutorial on tableau
Thank u so much!
can you make more advanced paid courses in SQL, Back end Developer with economical for students.
you teach so well.
"This time we gonna do... sex"
couldn't keep a giggle...
Same here😂
I need a video on CTE
Amazing