The SELECT statement allows we to get the data from table of views. A table consists of rows and columns like a spreadsheet. The SELECT
Read moreCategory: MySQL
Create a table with auto increment and default option
In MySql, we can create a column that contains a sequence of numbers(1,2,3 and so on) by using the AUTO_INCREMENT attribute. The AUTO_INCREMENT attribute is
Read moreHow To Update The Details In A Table
We may have a requirement where the existing data in MYSQL table needs to be modified. We can do so by using the SQL UPDATE
Read moreDeletion of Rows of the Table
The DELETE command is used to delete rows that are no longer required from the database tables. It deletes the whole row from the table.
Read moreInsertion of Data Into a Table
Let’s insert a record into our table. To insert data into a table, we would need to use the INSERT INTO command. To do this,
Read moreHow To Create New Tables
We have named our database “CSC”, so now let’s create a table with this database that stores information of the students. Now select the CSC
Read moreCreation Of Database
we can create new databases and import table using phpMyAdmin. Create a database by clicking on the “New” link at the top of the left
Read moreServer Activation
Go to xampp folder and open the xampp-control.exe file from it and start Apache and MySQL Now open up the web browser and enter the
Read moreMySQL SQL
What is SQL? SQL is the standard language for dealing with Relational Databases. SQL is used to insert, search, update, and delete database records. How
Read moreMySQL Functions – References
MySQL has many built-in functions. This reference contains string, numeric, date, and some advanced functions in MySQL. MySQL String Functions Function Description ASCII Returns the
Read more