Yo man 👋 I have a question about your SQL lessons: will there be a complete tutorial for beginners for it like for the other languages? Thanks again for all of your work
I completely forgot how to do MySQL, after a year of not taking a subject that utilizes it. Now I suddenly have an assignment due by midnight. So I just quickly needed a refresher. Thank you for providing a short and to-the-point tutorial.
I'm gonna recommend this to everyone, your methods are just brilliant it goes to the point and just amazing thanks bro. (sorry for bad English still learning)
I’m self teaching. So I am a beginner and unfamiliar so please be patient with me. When do you use semi colons, asterisk and parenthesis? I know underscore is used for two words. Can you use sql for any software or is sql for a specific program ? What careers use sql? I see this skill listed under duties for data analyst . Thanks for this video very informative
Please help me with this problem: I type the same thing as BroCode did However, the issue is Error while executing SQL query on database 'sample': near "RENAME": syntax error.
@@VesaShehu-bj8js it actually depends on which SQL application u are using. I'm using SQLite so this query will work for me: ALTER TABLE table_name RENAME TO new_table_name;
can anyone help, it says this error "Error Code: 1046. No database selected Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar."
For: ALTER TABLE employees MODIFY COLUMN email VARCHAR(50) my ALTER is error-highlighted with the statement ' "ALTER" is not valid at this point, expecting EOF, ';' ' I've refreshed, checked my version (8.0.36), and generally looked it over, but no luck.
iget this error Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'COLUMN phone_number to email' at line 2
Hello sir, I'm glad that i found your channel to learn SQL. I'm completely new to this subject. i came across an error while creating a table column (" hourly pay decimal(5,1)"). could you please clarify?
hey bro code i'm trying to tape the same scrito but i get this error: ''Error Code: 1046. No database selected Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar.'' how to solve it please
The Modify clause isnt working. It does'nt highlight or anthing like ALTER or SELECT, almost as if mysql is reading it as normal txt. Anyone else has this problem?
Hi - I am getting this error in sql workbench app "CREATE TABLE employees ( employee_id INT, first_name VARCHAR(50), last_name VARCHAR(50), hourly_pay DECIMAL(5, 2), hire_date DATE ) Error Code: 3185. Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.".... Someone pelase help!
For numbers suppose if this is a real life job scenario, do we still use VARCHAR as a data type or is there any alternative to add larger numbers in a database? Like in Java you can use double or even long so is there something similar?
(Creating a table using SQL) (7marks) a. Create a table Customer with four columns as shown below, using SQL statement: CUSTOMERS (Id, Name, Age, Adress, Salary) b. Add the ProId column as a foreign key to the table Customer help me
CREATE TABLE employees (
employee_id int,
first_name VARCHAR(50),
last_name VARCHAR(50),
hourly_pay DECIMAL(5, 2),
hire_date DATE
);
SELECT * FROM employees;
RENAME TABLE employees TO workers;
DROP TABLE employees;
ALTER TABLE employees
ADD phone_number VARCHAR(15);
ALTER TABLE employees
RENAME COLUMN phone_number TO email;
ALTER TABLE employees
MODIFY COLUMN email VARCHAR(100);
ALTER TABLE employees
MODIFY email VARCHAR(100)
AFTER last_name;
ALTER TABLE employees
MODIFY email VARCHAR(100)
FIRST;
ALTER TABLE employees
DROP COLUMN email;
Twelfth comment I was the tenth
Yo man 👋 I have a question about your SQL lessons: will there be a complete tutorial for beginners for it like for the other languages?
Thanks again for all of your work
@@matthewmurdock7329 it depends if people continue watching.
@@YeahEsCerealin 😅hindi 2:26 😅😅😮😅😅😅
@@matthewmurdock7329in 😅😅
Your teaching methods are to the point, full of information, but can be easily and clearly understood. Thank you so much!
Assalam o alaikum .
Kindly guide kryen .
Ye kis app per bnai ha .
Mean Kia install Kia then is per work Kia ha.
@@a_asad4646 sql app
Crazy how you post this the same week as I start with SQL. Thanks a lot.
Thank You so much for telling MySQL so easily. I got full marks in practials.
I completely forgot how to do MySQL, after a year of not taking a subject that utilizes it.
Now I suddenly have an assignment due by midnight. So I just quickly needed a refresher.
Thank you for providing a short and to-the-point tutorial.
hey bro, its so nice seeing you cover sql, an incredibly important language. thanks alot and keep the vids coming!!
I'm gonna recommend this to everyone, your methods are just brilliant it goes to the point and just amazing thanks bro.
(sorry for bad English still learning)
Bro that's perfect, Never apologise for trying to learn a new language, Your doing good buddy
you are out here doing the LORD'S WORK THANK YOU!!!!!!!!
I’m self teaching. So I am a beginner and unfamiliar so please be patient with me. When do you use semi colons, asterisk and parenthesis? I know underscore is used for two words. Can you use sql for any software or is sql for a specific program ? What careers use sql? I see this skill listed under duties for data analyst . Thanks for this video very informative
stop giving me exactly what I need for tomorrow every time its getting creepy .
Liiiikkeeeee!😂
😂😂
Relateeeee
Thank you very much for a very useful hand-on training!
FINALLYYYYY, here's a series for SQL. Thanks a lot Bro!
Please help me with this problem: I type the same thing as BroCode did However, the issue is Error while executing SQL query on database 'sample': near "RENAME": syntax error.
Same as me.Did you find a solution til now?
@@VesaShehu-bj8js it actually depends on which SQL application u are using. I'm using SQLite so this query will work for me:
ALTER TABLE table_name RENAME TO new_table_name;
can anyone help, it says this error "Error Code: 1046. No database selected Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar."
bro ur beast in teaching
I did not know that Mr Krabs had a first name.
Same
Yeah
For:
ALTER TABLE employees
MODIFY COLUMN email VARCHAR(50)
my ALTER is error-highlighted with the statement ' "ALTER" is not valid at this point, expecting EOF, ';' '
I've refreshed, checked my version (8.0.36), and generally looked it over, but no luck.
bro short and clear to understand tanks a lot
Hi,
I am getting an error when trying to create a table.
'Can't find master key from keyring'.
iget this error
Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'COLUMN phone_number to email' at line 2
reallyyyy happy to see you back again🥺🥺
Why is my interface different than yours? 😢
Where did the dark thingy thing comes from
What software did you use in getting this done ols
Hello sir,
I'm glad that i found your channel to learn SQL. I'm completely new to this subject.
i came across an error while creating a table column (" hourly pay decimal(5,1)"). could you please clarify?
You need to have an underscore in between when it has two words. So it should be
"hourly__pay DECIMAL(5,1)"
float can also be used@@syedathif3357
hey bro code
i'm trying to tape the same scrito but i get this error:
''Error Code: 1046. No database selected Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar.''
how to solve it please
Double-click on the database to be used on the schemas, for example, he is using mydb, it'd be in bold
thanks alot🙏
The Modify clause isnt working. It does'nt highlight or anthing like ALTER or SELECT, almost as if mysql is reading it as normal txt. Anyone else has this problem?
thank you so much bro code I'm your handicap student
THANKS A LOT KING
simple and clear, thanks.
Bro, you are awesome, bro!
Thankyou sensei ❤
Hi - I am getting this error in sql workbench app "CREATE TABLE employees (
employee_id INT,
first_name VARCHAR(50),
last_name VARCHAR(50),
hourly_pay DECIMAL(5, 2),
hire_date DATE
) Error Code: 3185. Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.".... Someone pelase help!
Hey bro, love your videos!!
Would you consider making NoSQL,GIT/GITHUB,Linux terminal videos in the near future?
Watching this before the exam😂
For numbers suppose if this is a real life job scenario, do we still use VARCHAR as a data type or is there any alternative to add larger numbers in a database? Like in Java you can use double or even long so is there something similar?
you are fantastic.
I not have laptop but still mastered SQL and python with bro
good to see u again
great work dear
Please create a full tutorial on rust
I’m a regular visitor on this channel hahaha
Bro you are wonderful 👍
Thank you!!
bro u are just awesome
bro i love u ur amazing
Just wow❤
Love you bro❤️❤️
Sixth
Ty bro
Legendary !
sir thr was error in install the key ring pugin plss hlp
yes pleaaaase full SQL tutorial
good
HOW to get rid if error Table already exists
Drop table
(Creating a table using SQL) (7marks)
a. Create a table Customer with four columns as shown below, using SQL statement:
CUSTOMERS (Id, Name, Age, Adress, Salary)
b. Add the ProId column as a foreign key to the table Customer
help me
thank you bro
SQL, sweet. Maybe react or firebase tutorials in the future.
thenks bro 🤔
Why make things complicated using this SQL when companies can use excel and Microsoft access?
thanks bro
Top top top
Bro or Sir please upload REACTJS full course
yo bro can u teach us php because im strugling with it ❤
I got an error 1064. please help me
Same. Did u figure it out? It keeps happening with decimals😫
Astrix is also known as star.
Code king 👑 bro code
More SQL please sir
We want courses in cyber security and ethical hacking
Broilliant vid as usual.
Clear and and easy to follow.
Thanks Bro
👍👍
Bro code!
First bro!
Fifth
HELLLOOOOOOOIOO
First
React Js please!
✅ 8th October - 2024
BRO IS BRO
i wish i could shake hands with you
Second
Eighth
SQL
Tenth
BroDeed
#heidisqlgang
First haha
Second
#bringbackjavatut lol!
Thanks
I not have laptop but still mastered SQL and python with bro
React Js please!