INSERT DATA INTO MYSQL

Insert data into MySQL

How to insert data into MySQL :

After installation of WampServer a short cut will appear on the desktop.

Click on the short cut and you will be asked whether the programme to be allowed to open, then click yes.

Then "w" icon will be displayed on the shortcut bar on the bottom which will first appear as red then orange and then green.

Right click on the icon and select PHPMYADMIN for inserting data into MySQL.

You will be directed to login page login after giving the required credentials.

You will be directed to the phpmyadmin page then select new on the left panel to create a new data base viz. "empdetails".

Then save and go

Then you will be asked to create table give name of the table as "empadress".

Create four coloumns as displayed :

id

empname

qtrno

persno

int for id

Varchar for empname
Int for qtrno
Into for persno

Click on A/I box and activate. A/I is for auto increment of ID i.e. in your case Sr.No. or any auto numbering for your database.

Click on "Go"

Then Save and the table will be created.

Browse the table and insert the data one by one.

The latest version of MySQL is 8.0.20 released couple of weeks ago. MySQL is a database where you can meet all your challenges to database maintenance with an everlasting support.

Till date this database management system has been serving the people with the right approach and generosity and free of cost. Commercial usage may be chargeable. We do not need to check out about the commercial usage. We are using this for our private purpose and learning something about how to insert database and maintain this for short term usage and there we depend upon the Wampserver for all including package comes with all packages like PHP, MariaDB, MySQL, PHPMYADMIN and Apache.

Comments

How to Use Mail Merge in Microsoft Word

How to Use Mail Merge in Microsoft Word Use mail merge to create and print too many letters and other documents to different persons. Mail merge is used to create a set of documents, such as a form letter(interview call/offer letters) that is sent to many candidates. Each letter has unique information. For example, in letters to candidates, each letter can be personalized to address each candidate by name. The mail merge process requires the following steps: Set up the main document. The main document contains contents which will be used in each document. Connect the document to a data source. A data source is a file that contains the information to be merged into a document. Normally we can use excel file contains the names and addresses of the recipients of a letter. Microsoft Office Word generates a copy of the main document for each item, or record, in your data file. If your data file is a mailing list, these item...

HR MANAGEMENT CATEGORIES OF EMPLOYEES

CATEGORIES OF EMPLOYEES : An Organization always select employees for various Departments. All these Departments have an Head of Department to look after the activities of a particular Department. The Departmental Head is the prime motivator of its employees. He will decide where employees are needed. Therefore, the Departmental Head of a particular Department is the prime authority in deciding the manpower position and fulfilling the Departmental requirements. For eg. Commercial Department includes Purchase and Materials Stores Sections where employees needs perfection and negotiating power to convince the vendors and contractors. The person appointed will handle purchase of items from the market so the desired person to be recruited should have some prior experience in the field of Procuring items required for the Organization. Also he needs to know the purchasing terms and should ensure good quality of raw materials to be procured...

MAKE MONEY ONLINE

HOW TO MAKE MONEY ONLINE IN YOUR FREE TIME Making money is not so easy, for that you have to search so many ways and there should be some source to make money, else you should know something about making money. You need good tactics to make people come in your way but I think all these are ways gone and is not applicable in today's world. Today people are making money online and offline and there are too many sources to give you a considerable amount every month without going in front of any body and also particularly if you possess some specific skills. In todays' world a person with one PC or One Smart Phone can create wonders and he can work day and night to complete the task, because simply registering on a platform and sitting idle will not make you eligible to get money freely, such platforms are also available but I strongly recommend that you should put your hard efforts to make an entry into this career so that you will be able to realize what are the difficulties i...

learner2know

Search This Blog