Creating Tables - SQL

Creating Tables - SQL - Tutorial 6

Рет қаралды 116,116

Giraffe Academy

Күн бұрын

🦒❤️ www.giraffeacademy.com/databa...

Пікірлер: 75

@olgaolga4843 4 жыл бұрын

Thanks a lot for this playlist Mike! Excellent job! Very clear and useful! Greetings from Russia :-)

@pavitreelongtong1511 6 жыл бұрын

I am start lerning the SQL by myself and I found your channel. Thank you very much. (subscribe already).

@dombivlikarashwin2939 3 жыл бұрын

I think after 2 yrs u have mastered.....Isn't it ??????

@ymous7051 5 жыл бұрын

Sir! your teaching is really beneficial! Thanks a lot for this course here! Lots of love and gratitude!

@alexandraschurmann8108 10 ай бұрын

Loving this video! Thanks so much for the playlist.

@federicopalacio5349 3 жыл бұрын

bro this tutorials are sooo easy to catch, good job.

@VidzSong 5 жыл бұрын

such a well thoughout video! thanks for sharing

@mohdahmed1510 3 жыл бұрын

Outstanding 😍 .. happy to be a member in your channel 🙏

@bunmi4164 2 жыл бұрын

So far, no comment. I enjoyed the lecture! Thank you so much guy!

@rohitsijoria7211 3 жыл бұрын

Great content man and very well explained

@wlliamyoung518 4 жыл бұрын

thank you Mike. Keep creating videos:)

@alonaparker3246 Жыл бұрын

Thank you very much. Your video helped me to finish my homework. Very helpful.

@miyemba_14 4 жыл бұрын

you the best. I feel like a programmer now

@ashleymunsamy4003 3 жыл бұрын

awesome video bud. Thank you

@jordanwrong2042 5 жыл бұрын

love this playlist dude. So indepth, really helping me out

@nunyadambidnis2274 5 жыл бұрын

How do I get the MySql workbench?

@AbJadzera 3 жыл бұрын

GREAT VIDEO!! THANK YOU!

@hildakamiza3947 5 жыл бұрын

your videos are helpful

@Siddharth-uo6zw 3 жыл бұрын

Thank u so much! can you make more advanced paid courses in SQL, Back end Developer with economical for students. you teach so well.

@lenkanavratilova6863 4 жыл бұрын

Perfect video

@sonamuhialdeen7866 3 жыл бұрын

So good tutorial

@karismaskloset2236 2 жыл бұрын

Definitely helped me with breakdown of codes, meanings etc! thank you!!

@fattygsalon252 3 жыл бұрын

So amazing,i feel like a programmer now than before

@hoanguyenle7354 2 жыл бұрын

Thanks a lot 😍😍

@reyd2845 5 жыл бұрын

Hi Mike, How can I change the default date format?

@frankiepinat1644 5 ай бұрын

hi can i ask if its necessary to install popsql to get along with this tutorial or I can use the built in mySql workbench as the text editor?

@prakharagrawal2689 10 күн бұрын

00:01 Creating tables and understanding data types in SQL 02:01 Data Types in SQL 04:01 Creating Tables in SQL 06:03 Creating a database table in SQL 08:01 Creating a table with primary key, name, and major attributes. 09:54 Creating Tables in SQL 11:49 You can describe, delete, modify and recreate tables in SQL. 13:36 You can create, alter, and drop tables in SQL 15:34 Investing in our future Crafted by Merlin AI.

@Ben-xo8xy 4 жыл бұрын

Gonna rewatch this video tmr. hm

@MoonkeeYT 3 жыл бұрын

Hi welcome to SQL. Did you happen to bring your right parenthesis?

@mohannadqa5101 5 ай бұрын

✅

@RaabStephan 6 жыл бұрын

sqlfiddle.com is useful way to try out sql if you don't want to download a program

@shaneyhormi9819 5 жыл бұрын

hey mike, I installed popsql but am finding it hard connecting back to my database after I shutoff my machine.....any hints

@oussamayousre7845 5 жыл бұрын

same problem bro , please what was the solution ?

@JayScar92 4 жыл бұрын

I had the same issue. The solution is this, open “Windows services” or “Services” app > find the service name “MySQL80” (name maybe different) > right click and select ‘Start’. Open MySQL Command Line App and enter your password, Now try and reconnect on PopSQL

@justinochieng2517 10 ай бұрын

Am getting error bad URI, where could I be getting it wrong? please assist.

@justthatpm 6 жыл бұрын

Hi, I didn't find a video on setting up PopSQL. I'm trying to enter the username/password but it's not going thru for me. Is there any way you can help?

@samuelcaine9843 5 жыл бұрын

kzfaq.info/get/bejne/n7aXfKWDu6yrYWg.html watch this tutorial, he has explained it in detail.

@shahriarnamvar9245 Жыл бұрын

Are you guys having some issues with new popsql version? I can't connect it to mysql and open the database...

@sabyasachidas4572 Жыл бұрын

SAME

@TubeVeva 4 жыл бұрын

I see you as my God.

@tauheedakbar3524 4 жыл бұрын

geez bruh chill out

@saidneder41 4 жыл бұрын

thats right, that how i see him too haha, thanks to him i learned python and Sql

@sammyay-man2754 7 ай бұрын

Mike, I did exactly what you wrote but all I got was an error 1046. Please help me

@luigir2459 4 жыл бұрын

I have resolved the issue for future boys and girls (Windows Only) on your search bar type MySQL installer- community. then find the server and click configurate. then click the steps and enter your password. next open up the MySQL client and enter password. then go back to PopSQL and on the top left click the red wiggly cables and connect to the server you had created.

@muhammadabuelenin7233 3 жыл бұрын

"windows" >> code is not running, getting a “permission denied for schema public” error message however I wrote >>> CREATE TABLE student ( student_id INT PRIMARY KEY, name VARCHAR(20), major VARCHAR(20) ); Please Support

@gaganbajoria7515 3 жыл бұрын

Same problem :(

@gaganbajoria7515 3 жыл бұрын

Hey i found out my mistake. You filled the wrong details while linking the database in PopSQL app. Check the name of the database once

@muhammadabuelenin7233 3 жыл бұрын

@@gaganbajoria7515 im working now with MS SQL clean, better and without errors so I advise you about it and if you are going to continue in data analysis field text me by your mail and we can study together , I'm searching for someone to study together!!

@nadiaabdalwhab875 Жыл бұрын

not working for me, help

@alenjose3903 4 жыл бұрын

Uh oh :( Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

@scottisitt 4 жыл бұрын

Are you trying to use PopSQL? I had a hard time with that so I used MySQL Workbench. Slightly different interface, but much less headache connecting to the local MySQL server.

@alenjose3903 4 жыл бұрын

Scott Isitt ya I switched to workbench, its so much better. Initial setup is long but worth it

@scottisitt 4 жыл бұрын

@@alenjose3903 Right on. 👍

@dipanshupaul1819 4 жыл бұрын

ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5

@HarshKumar-tw3st 4 жыл бұрын

CREATE TABLE student ( student_id INT NOT NULL, name VARCHAR(20), major VARCHAR(20), PRIMARY KEY (student_id) ); RUN THIS CODE for MySQL 8.0

@saidneder41 4 жыл бұрын

@@HarshKumar-tw3st Thanks bro!!!

@venus5990 2 жыл бұрын

MY POPSQL KEEPS QUERYING

@klomasteroutlaw 3 жыл бұрын

Need help

@duofring 5 жыл бұрын

Hi Mike, I've already installed MySQL & POPSQL like the way you teached for windows ver. However, the botton "Run" in PopSql doesn't highlight and work. I can't execute my texts. Please help me to solve that above problem! Thank you so much!

@dudujnkzhykykmz3063 5 жыл бұрын

Make sure your mysql server is running. Im not sure how to do this in windows, in Mac it appears on the front page of settings

@aartijaju5383 5 жыл бұрын

I am facing the same issue, Did you resolve it?

@saidneder41 4 жыл бұрын

Hey bro, i know its late but in windows, enter to popsql and on top of the text in would say Mysql with some cables there, click it and it becomes green, thats how you connect to the database :)

@luigir2459 4 жыл бұрын

@victorumolaedimeh7774 8 ай бұрын

Normal people don't have a name with a thousand characters 😂😂😂😂😂😂😂

@oussamayousre7845 5 жыл бұрын

hey , i can"t connect my popsql to mysql server it gives me this message (Uh oh :( ER_ACCESS_DENIED_ERROR: Access denied for user 'root '@'localhost' (using password: YES)) pleaaase , any help

@Dunya56 4 жыл бұрын

hello bro ... r u solve ur issue .?????

@Dunya56 4 жыл бұрын

i have the same problem bro .. pls help me man....