MYSQL COMMANDS (Part - 1) Create Database | Data Types | char v/s varchar | Create Table | CBSE 12
HTML-код
- Опубликовано: 1 ноя 2024
- In this video, you will understand the following commands with syntax:
Create Database
Use Database
Show Databases
Show Tables
Create Table
and difference between char() and varchar() , various data types in mysql
MYSQL
Database Concepts: Introduction to database concepts and its need. Relational data model: Concept of domain, relation, tuple, attribute, degree, cardinality, key, primary key, candidate key, alternate key and foreign key.
• Database | Relational ...
Introduction of MYSQL, Features, MYSQL v/s SQL, DDL and DML Commands
• MYSQL | Difference bet...
Download and Install MYSQL Server (Complete Step - by - Step Guide)
• How to Download MySQL ...
Playlist Links:
Python Revision Tour
• Python Revision Tour
Functions in Python
• Working with Functions...
random module
• random module
Mathematical and String Functions
• Playlist
Using Python Libraries:
• Using Python Libraries
Data Structures: Stack and Queue
• Data Structures : Line...
File Handling:
• File Handling
Recursion
• Recursion
Idea of Algorithmic Efficiency
www.youtube.co...
Interface Python with MYSQL:
• Interface Python with ...
MYSQL
• MYSQL
Programming Corner:
• Programming Corner
Thankyou ma'am..the only channel which helped me understand the concepts so well
Welcome...🙏🏻😊
Keep watching...👍🏻
I'm in my 2nd year of engineering and revising SQL from Mam's channel gives me motivation ❤️
Glad to hear this...
Thanku so much 🙂🙏🏻
God bless you
Which engineering?
Tomorrow is my Exam Of IT and I was finding a vdo explanation of MySQL commands......and this helped me a lot, Thank you soo much Mam
Welcome
Superb mam , MySQL ' s command aab jakar shmaj aayi 👍
That's Great...
Thanks..
Keep Watching
Ma'am im 2023-2024 batch students im following ur videos and questions from sumita arora is this enough for boards
and thank u ma'am u explain better than my school teacher
Yes... Thanks...
Please check out this
ruclips.net/video/OvOIVTOZ36s/видео.html
Thankyou ma'am your videos helped me a lot to understand concepts🥰
Most welcome 😊
thanks mam very good explanation you are my favorite teacher
Glad to hear that... Thank You so much..
God bless you beta..
Your voice mam😩😩
After see this vedio my concept is well cleared....thanku mam...
Welcome
aapki trh or sare teachers kyuo nhi h ??? u r a gem among cs teachers on yt.
Thanku so much... 🙏🏻
Way of teaching is awesome, speechless
Thanku so much
Thank you mam ..the vedio was really amazing!
Glad to like it..😊
Keep watching 👍🏻
Thankyou mam
You are awesome
Am getting concepts very well and loving CS
🙏🙏
That's Great 😊👍
Happy to help...
Keep Watching
Wonderful teacher! I'm Just obsessed with your lectures ma'am. They are so easy to understand!
Glad you like them!
Thanku...
@@SwatiChawlaofficial I'm glad Ma'am, That I found your channel!
@@bantosingh7088 thanks..
Plz share with others too
your teachng is so awesome sister thanks for understanding dear,god bless u,keep it up
Thanks a lot
Thank you. Very much appreciated.
Thanks and Welcome
Mam you are awesome😀👌👍🏻👍🏻👍🏻
Thanks
Wlcm
thank you mam because of you i got 32/35 in term 1 boards
Congratulations
Say less
Really helpful🥰....
Thanku.... 🙏🏻😊
Very useful video for beginners.....
Thanks a lot
Great video ma'am help me a lot!
Thank you!
Thanks and Welcome..
No doubts 🤓 thank you ma'am ❤️
Welcome..
Wish i could have find this amazing channel in term 1.
Thanku...
Even now also... it's not too late..
@@SwatiChawlaofficial I scored 32/35 in term 1
Now thanks to you i can get 35/35 in term 2
Thanks Maam
thankyou ma'am
Welcome
Sometimes i feel like maam you are angel to me for Computer Science 🙂
Thanku so much... 🙏🏻😊
Ma'am thank you very much .
Welcome..
maam why you are doing this ?
such a beautiful and conceptual content free of cost for all of us
thank you so much maam
Thanks and Welcome...
Keep Watching
Mam awesome i will recommend my frndns
Thanks a lot
Thanku sssooo much
Welcome
Thanks for such a wonderful explanation ❤️
Welcome...
Very informative ❤️❤️
Thanku
Thank you so much mama
Welcome
Mam can you please provide these sides for revision 🙏🏻
Sure... You can enjoy special perks by joining the membership.
Have a look at this.
ruclips.net/channel/UC2vH9rqGh-fJELF8acGfBdwjoin
mam thanks i watched complete playlist of mysql and finding cs quite easy because of you. very very thanks mam......
Glad to hear that
Thank you ma'am
Welcome
mam there is a problem it is showing error 1064 can you plz tell how to solve that
mam urs sql playlist includes 11th ( database concepts + sql) will it sufficient for me as i'm in 11th to complete both the chapters?
Yes...
Wow great mam 😊
Thanks
Thanku mam🙂
Welcome
Good content 👌
Thanku
Very nice 😊😊😊😊😊😊
Thanku..🙏🏻😊
Is int(m) self allocate itself ? If i give int(4) but in value if i give 2 dig no, then what happens
Please share your PPT it's very use full . please please
*Hey, now you can avail all these notes at the discounted rate….*
*Class - X Information Technology*
* Employability Skills (Notes) - X rzp.io/l/1mcA8UL
* Employability Skills (Ques Ans) - X rzp.io/l/2hxw8tY6N
* NCERT Solutions of CBSE Class 10 IT 402 rzp.io/l/fKUADxvbv
* Unit - 1 Digital Documentation Advanced using LibreOffice rzp.io/l/GUhTNcTpH
* Unit - 2 Electronic Spreadsheet Advanced (using LibreOffice) rzp.io/l/PpBEONKRN
* Unit - 3 DBMS (based on LibreOffice Base) rzp.io/l/XJrYs2P
* Unit - 4 Managing Health and Safety rzp.io/l/TQWvwOa
*Class 11 Computer Science (083)*
* Python rzp.io/l/cKflR95C
*Class 12 Computer Science (083)*
* Computational Thinking & Programming - 2 rzp.io/l/wihJhPBO
* Computer Networks rzp.io/l/OKWrgua
* Database Management rzp.io/l/z0mu2uBVu
* Assertion and Reasoning rzp.io/l/TgngGDjb
*IMPORTANT : After successful payment, don't refresh or go back (Redirecting...... will be shown on screen) , just wait for a while, and then Click on Request Access button, then you will get access to notes on your G-Mail ID within 24 hours.*
Tks mam
Welcome
at 3:00 what does that (0.11 sec) mean?
Thank you mam
Welcome
THANK YOU SO MUCH MA'AM IT HELPED ME A LOT.
MA'MA APKA WHATSUP GROUP BHI HEIN KYA, HOGA TOH MUJHE BHI JOIN KARNA HEIN.
Most welcome..
No whatsapp group is there
Oh but before it was there know?
Mam in the syntax of create table the place (rno int,name varchar (10) dob date , marks float (5,2),stream varchar (11)); how it comes?
Maam , I have a doubt :- Is it possible to create a database inside another database .
mam i have a doubt, why does my mysql command line client keep opening in windows terminal, because of that i cannot access the properties and other features, any solution?
Thankyou mam ❤😇
Welcome
@@SwatiChawlaofficial mam jo apne pdf post kiya tha na telegram me which had vid links usme galat link hai create databse showdatabse tht link is wrong
assume swathi chawla. thank you very much.
Apka bhai hai wo orange tshirt main?? Maam pls answer .(photos main )
for double(m,d) default value is (16,4) for decimal(m,d) what is the default value?
thanku
Welcome
Tysm mam ❣
Welcome
Ma'am is there any difference between INT and INTEGER. Because in my programs I usually use INTEGER without any argument...
Integer Types
TINYINT - It Can Hold values from -128 to 127. Or 0 to 255 for Unsigned.
SMALLINT -It can Hold values -32768 to 32767 or 0 to 65535 UNSIGNED. This is most commonly used field for most websites.
MEDIUMINT - It can Hold values from -8388608 to 8388607 or 0 to 16777215 UNSIGNED.
INT - It can hold Values from -2147483648 to 2147483647 or 0 to 4294967295 UNSIGNED.
BIGINT - -9223372036854775808 to 9223372036854775807 normal. 0 to 18446744073709551615.
14:10 FLOAT(5,3) or number 12.2 type kiya to error aaiga kya ?
Ma'am, is "views in database" there in term 2 syllabus? If yes, then pls make a video on this topic also🙏..
Edit :Ma'am pls make a video on referential integrity also if it is there in the syllabus.. My school teacher is teaching these topics so I am having confusion whether they are there or not..
plz refer the video of keys and constraints
@@SwatiChawlaofficial Ok ma'am but are the topics mentioned in my comment there in the syllabus? I have already studied from the whole Playlist of DBMS but didn't find those topics.. Kindly clarify ma'am so that I can study according to the syllabus..
Sorry for disturbing you repeatedly 🙏
According to me and even your teacher as well, these topics are important...
Don't restrict yourself to syllabus only...
I suggest you to cover these topics...
@@SwatiChawlaofficial Ok ma'am thanks a lot.. Can you pls provide me a link to the video(s) where these topics have been covered by you?
Sorry for inconvenience..
Mam have you made video on datatype.char varchar
ruclips.net/video/orGavb9E9uw/видео.html
mam can you please say which are the most imp datatypes only
char, varchar,int,date
Mam commamdprompt're screen shot kaise lete hai mysql ka
Either use Prtscr (Print Screen key)
Or use Windows key + Shift + S
Maam ye apne classxii ki table kis pe bnai h??
Mam when a domain is atomic... Please reply
Atomic means data which cannot be divided further.
Rules of atomicity:
rule 1: a column with atomic data can't have several values of the same type of data in the same column.
rule2: a table with atomic data can't have several columns with the same datatype.
Like fullname column can't say that it could be atomic because it can be further divded into lastname, firstname. A column with interest could also be divided further, so a column which can't be divided is known as atomic.
@@SwatiChawlaofficial ok mam
Mam ❤️
🙏🏻
Ma'am at 16:42 when u r explaining abt varchar u have entered varchar(7)and for allocation of bytes 5 bytes to Swati and 4 bytes to ria so total 9 used for allocation so why not varchar (9)???
Size in varchar specifies the maximum size of the particular column....
@@SwatiChawlaofficial ok thanku ma'am
Difference between decimal and float datatype?
DECIMAL and FLOAT both are used to store numerical values.
Float is Approximate-number data type, which means that not all values in the data type range can be represented exactly , it round up the values.
where as Decimal is Fixed-Precision data type, which means that all the values in the data type range can be represented exactly with precision and scale, it doesn’t round up the values.
Also mam will there will be error if we write commands in small letters??
No error...
SQL is case insensitive language
No error...
SQL is case insensitive language
Ma'am everytime I am trying to create a database,it shows unexpected identifier....please Ma'am help!!!!
ma'am in create table command each time we press enter we get to a new line ........so in written exams we need to write them in different lines or we can continue on same line.
Your choice ..
Even practically also... U can write in a single line as well
@@SwatiChawlaofficial ok mam......thank u so much for such wonderul sessions.
🎭 AMAZING SESSION MAM ✌️
Ma'am can you please tell me any android app for accessing MySQL
play.google.com/store/apps/details?id=app.compiler
Ma'am I have a query between char and varchar
If we more than 7 what will happen in char and varchar
As you write swati but if I write swati chawla ma'am please help me
Plz Check out this
ruclips.net/video/BKiw5pIXEO4/видео.html
@@SwatiChawlaofficial thankyou so much ma'am
Mam why to put semicolon after every command?
Semicolon represents the end of the statement..
thank you mam
Mam how to enter value in database in my sql
MYSQL: ruclips.net/p/PL5Raijva2y4S2sDeMIMu1kAVjwjgWyvyK
Mam window 7 m kese kre mql download pls mam reply
ruclips.net/video/XJNLw3W7xew/видео.html
follow same procedure..
If the datatype is float(4,2) .. then is 234.4 a valid input?
This will be invalid input as float(4,2) means..u r fixing that after decimal..it will take 2 digits.. before decimal,it will accept either 1 or 2 digits..not more than that..
Hope it's clear now..😊
@@SwatiChawlaofficial yes ma'am.. crystal clear...😊
Ma'am ye (0.10 sec) or (0.11 sec) or (0.00 sec) ye sbb kya or kyun likha aata h MySQL k code me??
it is the time the program has taken to execute your command bro
Mam phn m sqlite Kse krna h
Check Termux or Compiler app from Playstore..
@@SwatiChawlaofficial mam tcl commands important h kya
Usme commit smjh n a rha h
@@SwatiChawlaofficial thank you so much mam
2022 batch
mam mujhe my sql 8.0 command line lient open krne mei problem aa rhi ae
ruclips.net/video/XJNLw3W7xew/видео.html
Also check out the description of this video
Mam can the database & have table inside it same name ?? Please mam
yes
Ma'am can the database and table inside it have same name?
Very Good Question..
Yes... the name of the database and table can be same..
But inside the databse, two tables can not have the same name..
@@SwatiChawlaofficial Thank you so much ma'am... you are awesome...😊😀
Mam if I didn't have a pc then I can't learn??
U can use online compilers or Apps in Android.. like Pydroid3 , Compiler..
Plzz ensure that we can change the speed of the video
U can change it in RUclips.
Just click on the three dots->playback speed and adjust to your comfort.
@@Sanju-mo6in 11 month pehla nhii show karta ha playback speed samgha babu
Mam aap 0.5 slow ho
Thank you mam you teach very well ❤️🩹
mam where are you from
Can u send this ppt
*Hey, now you can avail all these notes at the discounted rate….*
*Class - X Information Technology*
* Employability Skills (Notes) - X rzp.io/l/1mcA8UL
* Employability Skills (Ques Ans) - X rzp.io/l/2hxw8tY6N
* NCERT Solutions of CBSE Class 10 IT 402 rzp.io/l/fKUADxvbv
* Unit - 1 Digital Documentation Advanced using LibreOffice rzp.io/l/GUhTNcTpH
* Unit - 2 Electronic Spreadsheet Advanced (using LibreOffice) rzp.io/l/PpBEONKRN
* Unit - 3 DBMS (based on LibreOffice Base) rzp.io/l/XJrYs2P
* Unit - 4 Managing Health and Safety rzp.io/l/TQWvwOa
*Class 11 Computer Science (083)*
* Python rzp.io/l/cKflR95C
*Class 12 Computer Science (083)*
* Computational Thinking & Programming - 2 rzp.io/l/wihJhPBO
* Computer Networks rzp.io/l/OKWrgua
* Database Management rzp.io/l/z0mu2uBVu
* Assertion and Reasoning rzp.io/l/TgngGDjb
*IMPORTANT : After successful payment, don't refresh or go back (Redirecting...... will be shown on screen) , just wait for a while, and then Click on Request Access button, then you will get access to notes on your G-Mail ID within 24 hours.*
Ma'am ek baat bolu galti karte huye mai use erase nhi kar pa rhi
Usse arrow keys
@@SwatiChawlaofficial ok ma'am
Notes ?
Sure..You can enjoy special perks by joining the membership.
Have a look at this.
ruclips.net/channel/UC2vH9rqGh-fJELF8acGfBdwjoin
Please ma'am upload pdf notes provide
Sure... You can enjoy special perks by joining the membership.
Have a look at this.
ruclips.net/channel/UC2vH9rqGh-fJELF8acGfBdwjoin
Kalpana chawala is your mouse or what😂
Showing no data base
First create database, then use database
Thnx ma'am
Welcome
thank you mam
Most welcome 😊
Thanks mam 🙏
Welcome..
Thanks mam
Welcome...