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;
New-ADUser: Parameters Windows Server In windows server, there are more than 60 parameters, but you don’t need to know them right now. Here are the ones most commonly used to create Active directory user accounts: Helpfull link. Parameter Used to AccountExpirationDate Specify the account’s expiration date AccountPassword Specify the account’s password AuthType Select the authentication…
This question can be asked in multiple ways! First question is the main point which will be expalined and all questions will be answered by answering the first question. Let me first raise all questions related to this task. how to connect ptcl modem to ptcl modem how to connect ptcl modem to router how…
کمر درد کا علاج از ہومیو ڈاکٹر مبشر احمد شاد صاحب آپ نے دیکھا ہو گا کہ ہر تیسرا مریض کمر درد کا ہوتا ہے ,اگر آپ کو کمر درد ہے تو یقین کریں کہ آپ محسوس کریں گے کہ نہ آپ دائیں طرف لیٹ سکتے ہیں نہ آپ بائیں طرف لیٹ سکتے ہیں نہ…
روس سے آنے والا تیل پاکستان کے لئے کئی فوائد پیدا کر سکتا ہے۔ میں یہاں ان فوائد کو انجام دیتا ہوں: 1. تجارتی فوائد: روس سے تیل کی خریداری پاکستان کو تجارتی فائدے پہنچاتی ہے۔ اس سے ملک کے درمیان تجارتی رشتے مضبوط ہوتے ہیں اور دونوں ممالک کے درمیان تجارت بڑھتی ہے۔ 2. …
In the dynamic world of technology, the quest for an affordable yet powerful laptop remains a perpetual adventure. As we embrace the year 2024, the $500 budget range stands as a frontier where performance meets affordability. This comprehensive guide unveils the top 5 budget laptops available on Amazon, carefully considering essential factors like processors, RAM,…
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…