IT TRICK and TIPS

Head Ads

Our Services

  • SEO on Page service
  • Keywords Planning
  • Off Page SEO Complete
  • YouTube SEO Services
  • Social Media Marketing
  • Learn IT Tricks and Tips
  • Learn Programming
  • Website Development
  • Quality Content Writing
  • Website Analysis
  • Website Speed Optimization

Ads2

Related Posts

Showing posts with label import sql to php mysql. Show all posts
Showing posts with label import sql to php mysql. Show all posts

Tuesday, June 11, 2019

How to create a database | MySQL create database

How to create a database | MySQL create the database

how to create a database
how to create a database

Follow instructions to create a database in MySQL on localhost.

  1. Make sure your XAMPP or WAMPP server setting is started.
  2. Open the browser and put localhost/phpmyadmin URL into it.
  3. Press enter key on your keyboard.
  4. A new window will appear.
  5. Click on new to create a new database.
  6. after click you will see a new option Create database here you will have to put database name and click on create button.
  7.  after the click, your database is created.
  8. Now you need to create a table for your database. 
  9. Give a name to the table and give the number of columns in your table. 
  10. Click on the Go button.
  11. Give a name to data and put the type of data you want to enter in the database.
  12. Decide the length of data you want length in your database 
  13. Click on the Save button to save your table information. 
  14. Your Database and table are created.

Check the video on how to create a database MySQL create database and table




if you have any further query I am here to solve your query ask me in the comment I will solve your problem.

Wednesday, May 29, 2019

Mysql import sql file | Mysql import database

Mysql import SQL file  | MySQL import database 

mysql import sql file | mysql import database
MySQL import SQL file | MySQL import database


Follow the steps to Mysql import SQL file 

  1. Start Xampp or wampp server 
  2. Open your browser and type in URL  localhost/phpmyadmin
  3. Hit enter button on your system 
  4. you will see PHPMyAdmin and here click on new on the left side of the bar
  5. after the click, you will see new options will appear on the PHPMyAdmin create the database and give the database a name and then click create.
  6. after the given name to database go to import on the header of PHPMyAdmin and click on import 
  7. after the click, you will see there will be option file to import here select .sql file from the system 
  8. Click on the Go in the bottom of this page 

for import SQL file or MySQL, import database see the video 




See the Screenshots to import SQL file or MySQL import database check these screenshots 


Step 1
MySQL import SQL file | MySQL import database
MySQL import SQL file | MySQL import database

Step 2
MySQL import SQL file | MySQL import database
MySQL import SQL file | MySQL import database

Step 3
MySQL import SQL file | MySQL import database
MySQL import SQL file | MySQL import database
Step 4
MySQL import SQL file | MySQL import database
MySQL import SQL file | MySQL import database


If you have any question then ask me in the comment section I will help you in import SQL file or MySQL import database feel free to ask your question Thanks...

Want to learn WordPress Click here WordPress