Change size in mysql table using query, mean you can increase/decrease, add, modify, delete mysql table columns and columns definition. Table of content Show Structure of table Increase column size of table How to show structure of already created table Query: desc student (note: student is a table name) Increase column size of table Query: … Read more
MySQL alter command is used to modify an existing database, table, view or other database objects that might need to change during the life cycle of a database. Or you can used when you want to change the name of your table or any table field. It is also used to add or delete an … Read more
In this article we will discuss about MySQL Query e.g. Create/show/drop database as well create/alert and delete table and table records. Table of Contents Login to MySQL Create a Database Use Database Show Database Drop Database Create a Table Show structure of table Insert Data into table Select record from Table Update record from Table … Read more
XAMPP is a software distribution which provides the Apache web server, MySQL database, PHP or many more all in one package.it also provided PhpMyadmin which gives a GUI tool for managing your MySQL databases You can to connect phpMyadmin to MySql command line. We can connect PhpMyadmin to command line in 3 ways. XAMPP Shell … Read more