gdata.io.handleScriptLoaded({"version":"1.0","encoding":"UTF-8","feed":{"xmlns":"http://www.w3.org/2005/Atom","xmlns$openSearch":"http://a9.com/-/spec/opensearchrss/1.0/","xmlns$gd":"http://schemas.google.com/g/2005","xmlns$georss":"http://www.georss.org/georss","xmlns$thr":"http://purl.org/syndication/thread/1.0","xmlns$blogger":"http://schemas.google.com/blogger/2008","id":{"$t":"tag:blogger.com,1999:blog-4095748245355156272"},"updated":{"$t":"2023-12-23T10:10:36.395+05:30"},"category":[{"term":"Make Money"},{"term":"Earn Tricks"},{"term":"PC Tips"},{"term":"Sundar Pichai"},{"term":"Cash"},{"term":"PayPal"},{"term":"DATABASE"},{"term":"Neal Mohan"},{"term":"internet"},{"term":"Wrong answer"},{"term":"email"},{"term":"CEO"},{"term":"boot"},{"term":"functions"},{"term":"installation process"},{"term":"Remote employees"},{"term":"facebook"},{"term":"Apache"},{"term":"data types"},{"term":"Encapsulation"},{"term":"Hosting"},{"term":"Launch"},{"term":"Website"},{"term":"microsoft"},{"term":"Maximize earning potential"},{"term":"Facebook Tips"},{"term":"whatsapp"},{"term":"Inheritance"},{"term":"google"},{"term":"Free Antivirus n key"},{"term":"Pc Tricks"},{"term":"computer"},{"term":"navbar"},{"term":"Content"},{"term":"Facebook Timeline"},{"term":"NASA"},{"term":"free"},{"term":"Object-Oriented Programming"},{"term":"Spare time"},{"term":"James Webb Space Telescope"},{"term":"tool"},{"term":"Points"},{"term":"Top Ten Antivirus 2012"},{"term":"Tasks"},{"term":"Funny Java Tricks"},{"term":"programming"},{"term":"software bundle"},{"term":"Work from home"},{"term":"Chatbot"},{"term":"Freelancing"},{"term":"Howto"},{"term":"PHP"},{"term":"youtube"},{"term":"Step-by-step guide"},{"term":"Best  Tricks"},{"term":"ChatGPT"},{"term":"Mobile app"},{"term":"Free Sms to World"},{"term":"Web Traffic"},{"term":"tricks"},{"term":"file handling"},{"term":"Best  Tips"},{"term":"Learn PHP"},{"term":"NEWS"},{"term":"XAMPP"},{"term":"LG"},{"term":"AI"},{"term":"Bard"},{"term":"Telecommuting"},{"term":"Remote work"},{"term":"Flexible work"},{"term":"Orkut Ha(k"},{"term":"Online jobs"},{"term":"leptop"},{"term":"Remote work culture"},{"term":"Videos"},{"term":"format"},{"term":"Article"},{"term":"Instagram"},{"term":"hotspot"},{"term":"Android"},{"term":"Susan Wojcicki"},{"term":"Trading"},{"term":"control structures"},{"term":"Gift cards"},{"term":"PHP applications"},{"term":"Net tips"},{"term":"MYSQL"},{"term":"Search engines"},{"term":"Earn money online"},{"term":"MariaDB"},{"term":"Market value"},{"term":"web development"},{"term":"OpenAI"},{"term":"Mobile Tips"},{"term":"gadgets"},{"term":"Net Funny Tricks"},{"term":"blog"},{"term":"web applications"},{"term":"Windows Tricks"},{"term":"wifi"},{"term":"Abstraction"},{"term":"Polymorphism"},{"term":"windows"},{"term":"Wechat"},{"term":"computer setup"},{"term":"highspeed"},{"term":"MVC"},{"term":"dynamic content"},{"term":"4GSpeed"},{"term":"Facebook Tricks"},{"term":"Safe On Facebook"},{"term":"mobile"},{"term":"Atta Pol"},{"term":"variables"},{"term":"recharge"},{"term":"SEO Tips"},{"term":"iOS"},{"term":"PHP programming"},{"term":"Mobile as a Webcam"},{"term":"Remote jobs"},{"term":"database connectivity"},{"term":"Artificial Intelligence"},{"term":"Free Call"},{"term":"Rewards"},{"term":"Surveys"},{"term":"bootable pendrive"},{"term":"Blogger Tricks"},{"term":"Orkut tips"},{"term":"FB Status Updater"},{"term":"Post"},{"term":"OOP"},{"term":"Share price"},{"term":"Extra income"},{"term":"operators"},{"term":"web server"},{"term":"bluestacks"},{"term":"PHP scripts"},{"term":"Blogger Widgets"},{"term":"Java Tricks"},{"term":"Alphabet"},{"term":"scripting language"},{"term":"Virtual work"}],"title":{"type":"text","$t":"Get Tricks - All Type of Tricks"},"subtitle":{"type":"html","$t":"The site gives knowledge and tricks about social sites, computer tricks, the Internet and earning money online. All Information and tips are in One Place."},"link":[{"rel":"http://schemas.google.com/g/2005#feed","type":"application/atom+xml","href":"https://www.blogger.com/feeds/4095748245355156272/posts/default/-/DATABASE?alt\u003djson-in-script\u0026max-results\u003d5"},{"rel":"self","type":"application/atom+xml","href":"https://www.blogger.com/feeds/4095748245355156272/posts/default/-/DATABASE?alt\u003djson-in-script\u0026max-results\u003d5"},{"rel":"alternate","type":"text/html","href":"http://www.gettrickz.com/search/label/DATABASE"},{"rel":"hub","href":"http://pubsubhubbub.appspot.com/"}],"author":[{"name":{"$t":"Juber Khan Baloch"},"uri":{"$t":"https://www.blogger.com/profile/03500557746501068520"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"35","height":"35","src":"//www.blogger.com/img/blogger_logo_round_35.png"}}],"generator":{"version":"7.00","uri":"https://www.blogger.com","$t":"Blogger"},"openSearch$totalResults":{"$t":"2"},"openSearch$startIndex":{"$t":"1"},"openSearch$itemsPerPage":{"$t":"5"},"entry":[{"id":{"$t":"tag:blogger.com,1999:blog-4095748245355156272.post-8333260498802518629"},"published":{"$t":"2023-02-09T13:04:00.004+05:30"},"updated":{"$t":"2023-02-13T12:16:12.060+05:30"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"installation process"},{"scheme":"http://www.blogger.com/atom/ns#","term":"PHP programming"},{"scheme":"http://www.blogger.com/atom/ns#","term":"Apache"},{"scheme":"http://www.blogger.com/atom/ns#","term":"DATABASE"},{"scheme":"http://www.blogger.com/atom/ns#","term":"computer setup"},{"scheme":"http://www.blogger.com/atom/ns#","term":"MYSQL"},{"scheme":"http://www.blogger.com/atom/ns#","term":"MariaDB"},{"scheme":"http://www.blogger.com/atom/ns#","term":"PHP"},{"scheme":"http://www.blogger.com/atom/ns#","term":"scripting language"},{"scheme":"http://www.blogger.com/atom/ns#","term":"PHP applications"},{"scheme":"http://www.blogger.com/atom/ns#","term":"web server"},{"scheme":"http://www.blogger.com/atom/ns#","term":"XAMPP"},{"scheme":"http://www.blogger.com/atom/ns#","term":"software bundle"},{"scheme":"http://www.blogger.com/atom/ns#","term":"PHP scripts"}],"title":{"type":"text","$t":"Start Learning PHP and MySQL: A Comprehensive Guide to Setting Up PHP on Your Windows or Linux PC"},"content":{"type":"html","$t":"\u003cdiv class\u003d\"separator\" style\u003d\"clear: both; text-align: center;\"\u003e\u003ca href\u003d\"https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRpIIDvMi4XTfNz61qP3MYxzdi1y_RWCcOeTX3qK8lfZ6uCm7XiwIfiqp3Jyw2uA9kImed5gnKHPe7geKlcS3NvHAvnXDkuqXnHkbk2ygEc5A0puL3YjpW_FuTpOW8cN1aul2tqT4HJrNDXYMsWqEvN8jLqFzRxSEEXJtfjwUsLSo30MUrExV00LjAyA/s800/A-Comprehensive-Guide-to-Setting-Up-PHP-on-Your-Windows-or-Linux-PC.jpg\" imageanchor\u003d\"1\" style\u003d\"clear: left; float: left; margin-bottom: 1em; margin-right: 1em;\"\u003e\u003cimg alt\u003d\"A Comprehensive Guide to Setting Up PHP on Your Windows or Linux PC\" border\u003d\"0\" data-original-height\u003d\"533\" data-original-width\u003d\"800\" height\u003d\"213\" src\u003d\"https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRpIIDvMi4XTfNz61qP3MYxzdi1y_RWCcOeTX3qK8lfZ6uCm7XiwIfiqp3Jyw2uA9kImed5gnKHPe7geKlcS3NvHAvnXDkuqXnHkbk2ygEc5A0puL3YjpW_FuTpOW8cN1aul2tqT4HJrNDXYMsWqEvN8jLqFzRxSEEXJtfjwUsLSo30MUrExV00LjAyA/w320-h213/A-Comprehensive-Guide-to-Setting-Up-PHP-on-Your-Windows-or-Linux-PC.jpg\" title\u003d\"A Comprehensive Guide to Setting Up PHP on Your Windows or Linux PC\" width\u003d\"320\" /\u003e\u003c/a\u003e\u003c/div\u003e\u003cp\u003eGetting started with PHP programming can be a simple process with the right tools in place. In order to write and run PHP code on your computer, you will need to set up an environment that includes a web server and a database management system.\nThe most popular choice for setting up a local PHP development environment is to use a software stack such as XAMPP. This software bundle includes Apache as the web server, PHP as the scripting language, and MariaDB as the database management system.\nBy following a simple installation process, you can have a fully functional PHP environment ready to use on your computer. This will allow you to create and run PHP scripts and applications, as well as interact with a database using MySQL.\nIn summary, to start using PHP on your computer, you will need to set up a web server and database management system. The easiest way to accomplish this is by using a software bundle like XAMPP.\u003c/p\u003e\n\u003cp\u003eXAMPP is a popular, free, and open-source software stack that includes Apache, MariaDB, PHP, and Perl, and makes it easy to set up a local development environment for web applications. Whether you are a beginner or an experienced developer, getting started with PHP on XAMPP is easy and straightforward. In this article, we will show you how to install and use XAMPP to start using PHP on your Windows or Linux PC.\u003c/p\u003e\n\n\u003cp\u003e\u003cb\u003e\u003cspan style\u003d\"font-size: medium;\"\u003eInstalling XAMPP on Windows\u003c/span\u003e\u003c/b\u003e\u003c/p\u003e\n\u003cp\u003e\nTo install XAMPP on Windows, you will first need to download the installation package from the official website. Once you have downloaded the package, you can double-click it to start the installation process. During the installation process, you will be prompted to select the components you want to install, and you will also be asked to specify the directory in which you want to install XAMPP. After the installation is complete, you can start the XAMPP control panel, which will allow you to start and stop the Apache and MariaDB services.\u003c/p\u003e\n\u003cp style\u003d\"text-align: center;\"\u003e\n\u003ca class\u003d\"btn btn-info\" href\u003d\"https://www.apachefriends.org/download.html\"\u003e\u003cb\u003e\u003cspan style\u003d\"font-size: large;\"\u003eCLICK HERE TO DOWNLOAD XAMMP\u003c/span\u003e\u003c/b\u003e\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003e\u003cb\u003e\u003cspan style\u003d\"font-size: medium;\"\u003eVerifying PHP Installation with XAMPP\u003c/span\u003e\u003c/b\u003e\u003c/p\u003e\n\u003cp\u003e\nXAMPP is a popular, free, and open-source software stack that includes Apache, MariaDB, PHP, and Perl. Once you have successfully installed XAMPP on your Windows or Linux PC, you can verify the PHP installation by creating a PHP file and accessing it through a web browser.\n\nTo start, ensure that XAMPP is running and all the necessary services (Apache, PHP, and MariaDB) are active. You can check this in the XAMPP control panel.\n\nNext, locate the htdocs or www directory within the XAMPP folder on your PC. This is where you will save all your PHP files and folders. To test your PHP installation, create a file named \"test.php\" within this directory.\u003c/p\u003e\u003cp\u003e\n\u003c/p\u003e\u003cblockquote class\u003d\"tr_bq\"\u003e\u003cb\u003e\n\u0026lt;?php\u003cbr /\u003e\necho \"Hello World\";\u003cbr /\u003e\n\u0026nbsp;?\u0026gt;\u003c/b\u003e\u003c/blockquote\u003e\n\u003cp\u003eSave the file and access it through your web browser. If everything is set up correctly, you should see the message \"Hello World!\" displayed in your browser.\n  \"In order to run a PHP file on your local system, you will need to access it through a web browser. This can be achieved by using the following URL format: localhost://[filename]. Replace [filename] with the name of your PHP file, including the .php extension. For example, if your file is named test.php, the URL to access it in your browser would be localhost://test.php. Ensure that your web server (such as XAMPP) is running and configured correctly before attempting to access the PHP file in your browser.\"\n\nWith this simple test, you have successfully confirmed the installation and setup of PHP on your Windows or Linux PC using XAMPP.\n\u003c/p\u003e\n\u003cp\u003e\u003cb\u003e\u003cspan style\u003d\"font-size: medium;\"\u003eInstalling XAMPP on Linux\u003c/span\u003e\u003c/b\u003e\u003c/p\u003e\n\u003cp\u003e\nTo install XAMPP on Linux, you will first need to download the installation package from the official website. Once you have downloaded the package, you can extract its contents to the directory in which you want to install XAMPP. Next, you will need to navigate to the extracted directory in a terminal window and run the following command to start the installation process:\n\u003c/p\u003e\n\u003cblockquote\u003e\u003cb\u003esudo bash xampp-linux-x64-7.4.15-0-installer.run\u003c/b\u003e\u003c/blockquote\u003e\n\n\u003cp\u003eDuring the installation process, you will be prompted to select the components you want to install, and you will also be asked to specify the directory in which you want to install XAMPP. After the installation is complete, you can start the XAMPP control panel, which will allow you to start and stop the Apache and MariaDB services.\u003c/p\u003e\u003cp\u003e\n\n\u003c/p\u003e\u003cp\u003eOnce XAMPP is installed and running, you can test your PHP installation by creating a PHP file and accessing it in a web browser. For example, you can create a file called test.php in the htdocs directory of your XAMPP installation and add the following code to it:\u003c/p\u003e\n\n\u003cblockquote class\u003d\"tr_bq\"\u003e\u003cb\u003e\n\u0026lt;?php\u003cbr /\u003e\necho \"Hello World\";\u003cbr /\u003e\n\u0026nbsp;?\u0026gt;\u003c/b\u003e\u003c/blockquote\u003e\n\u003cp\u003eSave the file and access it through your web browser. If everything is set up correctly, you should see the message \"Hello World\" displayed in your browser.\n  \"In order to run a PHP file on your local system, you will need to access it through a web browser. This can be achieved by using the following URL format: localhost://[filename]. Replace [filename] with the name of your PHP file, including the .php extension. For example, if your file is named test.php, the URL to access it in your browser would be localhost://test.php. Ensure that your web server (such as XAMPP) is running and configured correctly before attempting to access the PHP file in your browser.\"\n\nWith this simple test, you have successfully confirmed the installation and setup of PHP on your Windows or Linux PC using XAMPP.\n\u003c/p\u003e\n\n\u003cp\u003e\u003c/p\u003e\u003cp\u003e\u003c/p\u003e\u003cp\u003e\u003c/p\u003e\u003cp\u003e\u003c/p\u003e"},"link":[{"rel":"edit","type":"application/atom+xml","href":"https://www.blogger.com/feeds/4095748245355156272/posts/default/8333260498802518629"},{"rel":"self","type":"application/atom+xml","href":"https://www.blogger.com/feeds/4095748245355156272/posts/default/8333260498802518629"},{"rel":"alternate","type":"text/html","href":"https://www.gettrickz.com/2020/01/start-learn-phpmysql-start-using-php-in.html","title":"Start Learning PHP and MySQL: A Comprehensive Guide to Setting Up PHP on Your Windows or Linux PC"}],"author":[{"name":{"$t":"Juber Khan Baloch"},"uri":{"$t":"https://www.blogger.com/profile/03500557746501068520"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"35","height":"35","src":"//www.blogger.com/img/blogger_logo_round_35.png"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRpIIDvMi4XTfNz61qP3MYxzdi1y_RWCcOeTX3qK8lfZ6uCm7XiwIfiqp3Jyw2uA9kImed5gnKHPe7geKlcS3NvHAvnXDkuqXnHkbk2ygEc5A0puL3YjpW_FuTpOW8cN1aul2tqT4HJrNDXYMsWqEvN8jLqFzRxSEEXJtfjwUsLSo30MUrExV00LjAyA/s72-w320-c-h213/A-Comprehensive-Guide-to-Setting-Up-PHP-on-Your-Windows-or-Linux-PC.jpg","height":"72","width":"72"}},{"id":{"$t":"tag:blogger.com,1999:blog-4095748245355156272.post-307787340563360934"},"published":{"$t":"2016-05-08T16:40:00.003+05:30"},"updated":{"$t":"2023-02-16T17:32:05.344+05:30"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"DATABASE"},{"scheme":"http://www.blogger.com/atom/ns#","term":"MYSQL"},{"scheme":"http://www.blogger.com/atom/ns#","term":"PHP"}],"title":{"type":"text","$t":"Start Learn PHP/MYSQL : What Is MySQL ? Why MySQL ?"},"content":{"type":"html","$t":"\u003cdiv dir\u003d\"ltr\" style\u003d\"text-align: left;\" trbidi\u003d\"on\"\u003e\n\u003cdiv class\u003d\"separator\" style\u003d\"clear: both; text-align: center;\"\u003e\n\u003c/div\u003e\n\u003cdiv class\u003d\"row\"\u003e\n\u003cdiv class\u003d\"col-md-3\"\u003e\n\u003ca href\u003d\"https://lh3.googleusercontent.com/-nkFcdel9Ds4/Vy8fcPnnw2I/AAAAAAAADpM/90Lusyis2jMcMWcBRurYOxHP1aCJH890ACLcB/s1600/MySQL.svg.png\" style\u003d\"clear: left; float: left; margin-bottom: 1em; margin-right: 1em;\"\u003e\u003cimg border\u003d\"0\" height\u003d\"166\" src\u003d\"https://lh3.googleusercontent.com/-nkFcdel9Ds4/Vy8fcPnnw2I/AAAAAAAADpM/90Lusyis2jMcMWcBRurYOxHP1aCJH890ACLcB/w320-h166/MySQL.svg.png\" width\u003d\"320\" /\u003e\u003c/a\u003e\u003c/div\u003e\n\u003cdiv class\u003d\"col-md-9\"\u003e\nMySQL is the most popular database system used with PHP. MySQL is an open-source relational database management system (RDBMS). In July 2013, it was the world's second most widely used RDBMS, and the most widely used open-source client–server model RDBMS It is named after Michael Widenius' (who is a co-founder of MySQL) daughter, My, while \"SQL\" stands as the abbreviation for Structured Query Language. The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation. For proprietary use, several paid editions are available, and offer additional functionality.\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cb\u003eWhat Is MySql:\u003c/b\u003e\u003cbr /\u003e\n\u003cul\u003e\n\u003cli\u003e\nMySQL is a database system used on the web\u003c/li\u003e\n\u003cli\u003e\nMySQL is a database system that runs on a server\u003c/li\u003e\n\u003cli\u003e\nMySQL is ideal for both small and large applications\u003c/li\u003e\n\u003cli\u003e\nMySQL is very fast, reliable, and easy to use\u003c/li\u003e\n\u003cli\u003e\nMySQL uses standard SQL\u003c/li\u003e\n\u003cli\u003e\nMySQL compiles on a number of platforms\u003c/li\u003e\n\u003cli\u003e\nMySQL is free to download and use\u003c/li\u003e\n\u003cli\u003e\nMySQL is developed, distributed, and supported by Oracle Corporation\u003c/li\u003e\n\u003c/ul\u003e\nPHP combined with MySQL are cross-platform (you can develop in Windows and serve on a Unix platform)\u003cbr /\u003e\n\u003cb\u003eDefinition And Features\u003c/b\u003e\u003cbr /\u003e\nMySQL is a relational database system. MySQL is faster, more reliable, and Free , better than any other database system (including commercial systems such as Oracle and DB2).We can safely say that there is a large bandwidth of opinion.\u003cbr /\u003e\nThere is an ever increasing number of MySQL users, and majority of them are quite satisfied with MySQL.\u003cbr /\u003e\nIts also that MySQL still lacks a number of features that are taken for granted with other database systems. If you require such features, then MySQL is not the database system for you.\u003cbr /\u003e\n\u003cb\u003eFeatures of MySQL\u003c/b\u003e\u003cbr /\u003e\nThe following list shows the most important properties of MySQL. This section is directed to the reader who already has some knowledge of relational databases. We will use some terminology from the relational database world without defining our terms exactly. On the other hand, the explanations should make it possible for database novices to understand to some extent what we are talking about.\u003cbr /\u003e\n\u003cb\u003eRelational Database System\u003c/b\u003e: Like almost all other database systems on the market, MySQL is a relational database system.\u003cbr /\u003e\n\u003cb\u003eClient/Server Architecture\u003c/b\u003e: MySQL is a client/server system. There is a database server (MySQL) and arbitrarily many clients (application programs), which communicate with the server; that is, they query data, save changes, etc. The clients can run on the same computer as the server or on another computer (communication via a local network or the Internet)\u003cbr /\u003e\nAlmost all of the familiar large database systems (Oracle, Microsoft SQL Server, etc.) are client/server systems. These are in contrast to the file-server systems, which include Microsoft Access, dBase and FoxPro. The decisive drawback to file-server systems is that when run over a network, they become extremely inefficient as the number of users grows.\u003cbr /\u003e\n\u003cb\u003eWhy MySQL?\u003c/b\u003e\u003cbr /\u003e\nMany of the world's largest and fastest-growing organizations including Facebook, Google, Adobe, Alcatel Lucent and Zappos rely on MySQL to save time and money powering their high-volume Web sites, business-critical systems and packaged software.\u003cbr /\u003e\n\u003cb\u003eType Of Query Example:\u003c/b\u003e\u003cbr /\u003e\nCreate Statement:Use To Create Database and Tables\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cblockquote\u003e\nCREATE DATABASE dbname;\u003c/blockquote\u003e\nFor Tables:\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cblockquote\u003e\nCREATE TABLE table_name\n(\ncolumn_name1 data_type(size),\ncolumn_name2 data_type(size),\ncolumn_name3 data_type(size),\n....\n);\u003c/blockquote\u003e\nAlter Statement:is used to add, delete, or modify columns in an existing table\u003cbr /\u003e\nTo add a column in a table, use the following syntax:\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cblockquote\u003e\nALTER TABLE table_name\nADD column_name datatype\u003c/blockquote\u003e\nTo delete a column in a table:\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cblockquote\u003e\nALTER TABLE table_name\nDROP COLUMN column_name\u003c/blockquote\u003e\nTo change the data type of a column in a table:\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cblockquote\u003e\nALTER TABLE table_name\nALTER COLUMN column_name datatype\u003c/blockquote\u003e\nInsert Statement:is used to add new records to a MySQL table\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cblockquote\u003e\nINSERT INTO table_name (column1, column2, column3,...)\nVALUES (value1, value2, value3,...)\u003c/blockquote\u003e\nUpdate Statement:is used to update existing records in a table\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cblockquote\u003e\nUPDATE table_name\nSET column1\u003dvalue, column2\u003dvalue2,...\nWHERE some_column\u003dsome_value \u003c/blockquote\u003e\nDelete statement: is used to delete records from a table\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cblockquote\u003e\nDELETE FROM table_name\nWHERE some_column \u003d some_value\n\u003c/blockquote\u003e\nSelect Statement:Its Use Display all the data From Table\u003cbr /\u003e\n\u003cbr /\u003e\n\u003cblockquote\u003e\nSELECT * FROM table_name\u003c/blockquote\u003e\n\u003c/div\u003e\n\u003c/div\u003e\n\u003c/div\u003e\n"},"link":[{"rel":"replies","type":"application/atom+xml","href":"https://www.gettrickz.com/feeds/307787340563360934/comments/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"https://www.gettrickz.com/2016/05/start-learn-phpmysql-what-is-mysql-why.html#comment-form","title":"0 Comments"},{"rel":"edit","type":"application/atom+xml","href":"https://www.blogger.com/feeds/4095748245355156272/posts/default/307787340563360934"},{"rel":"self","type":"application/atom+xml","href":"https://www.blogger.com/feeds/4095748245355156272/posts/default/307787340563360934"},{"rel":"alternate","type":"text/html","href":"https://www.gettrickz.com/2016/05/start-learn-phpmysql-what-is-mysql-why.html","title":"Start Learn PHP/MYSQL : What Is MySQL ? Why MySQL ?"}],"author":[{"name":{"$t":"Juber Khan Baloch"},"uri":{"$t":"https://www.blogger.com/profile/03500557746501068520"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"35","height":"35","src":"//www.blogger.com/img/blogger_logo_round_35.png"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"https://lh3.googleusercontent.com/-nkFcdel9Ds4/Vy8fcPnnw2I/AAAAAAAADpM/90Lusyis2jMcMWcBRurYOxHP1aCJH890ACLcB/s72-w320-c-h166/MySQL.svg.png","height":"72","width":"72"},"thr$total":{"$t":"0"}}]}});