Type this code for creating database in MySql
create database adeel;
Type this code for using by default database.
use adeel;
create table TestAdeel (
id int,
FirstName varchar(255),
LastName varchar(255),
FatherName varchar(255),
Address varchar(255)
);
insert into testadeel (id, FirstName, LastName, FatherName, Address)
values
(1, ‘Adeel’, ‘Ahmad’, ‘Khalil’, ‘Lahore’);
If you want to put data in all columns then no need to mention all columns name. As you can see below.
insert into testadeel
values
(2, ‘Ade’, ‘Ahad’, ‘Khala’, ‘Lahore’),
(3, ‘Adee’, ‘Ahad’, ‘Khala’, ‘Lahore’);
insert into testadeel (FirstName)
values
(‘Ade’),
(‘Lahore’);
Select command is used to select and show the table data.
Select all:
SELECT * FROM tableName;
column is selected which you want to see and can call from specific column.
select FName from class where id=’2′;
For Table
DROP table tableName;
for database
DROP database databaseName;
Excessive consumption of added sugars can be detrimental to the health of individuals of all ages, including young children. The American Heart Association recommends that children aged 2 to 18 should consume only 25 grams (almost 6 teaspoons) sugars per day. Excessive sugar intake in children has been linked to various health issues, including tooth…
السر کیا ہوتا ہے ؟السر کی علامات اور اس کا علاج السر کیا چیز ہے یہ کیسے پیدا ہوتا ہے؟ السر معدے کی نالی میں انتوں میں اور معدے میں زخم ہو جائیں تو اس کو ہر کوئی اپنی زبان میں السر بولتا ہے۔زخم ہونا کوئی بڑی بات نہیں ہوتی لیکن اگراس کا علاج نہ…
Introduction In the world of grooming, the right shaving machine can make all the difference. Whether you’re after a close shave or a convenient grooming experience, choosing the best shaver is crucial. In this article, we’ll explore the top 10 shaving machines on the market, considering their features, pros, and cons to help you make…
Homeopathy is a system of alternative medicine that was developed in the late 18th century by Samuel Hahnemann, a German physician. It is based on the principle of “like cures like” and the concept of potentization. Here are the key principles and concepts underlying homeopathy: Similia Similibus Curentur (Like Cures Like): The fundamental principle of…
Are You Planning to Visit Pakistan? If you are planning to visit Beatiful Pakistan and want to plan which places you should visit and when you should visit then you are at the right place I will guide you regarding hiking traveling and famous tourist spot of Pakistan, the paradise on earth. My Frist Track…
Zong in Pakistan WorldCup 2023 for Free Tou can watch live world cup 2023 online free streaming, It is so amazing the zong is providing this service free. In previous years daraz app started this feature and this time amazing free online watching of world cup all matches using there zong app. But wait As…