MySQL General Guides tutorials
If you have created a database and decide later that one of the column names you chose isn't exactly what you want, you can rename it. You do this using alter table and change. Together they can be used to rename a MySQL column.
Related Tutorials
Changing Column Size
Changing the size of a column in MySQL is pretty easy. By using alter table and modify you are able to choose a column on a specified table and resize it. Learn how to resize a MySQL column.
Fixing column encoding mess in MySQL
Just had an interesting issue with an encoding mess on a column containing non-ASCII text. The solution was not immediately obvious so I decided it's worth sharing.
Query to find the second highest column value in a table
In this ms sql server tutorial you will learn query to find the second highest column value in a table.
Query to find the second lowest column value in a table
In this ms sql server tutorial you will learn query to find the second lowest column value in a table.
Using SELECT to retrieve data
This tutorial deeply covers the SELECT statement of the T-SQL/SQL language. Starts from the basics - how to retrieve the values inside a column to ordering data, selecting multiple columns and then tables, joining them..
MySQL Update And Delete
The statement UPDATE is used to change the value in a table.
MySQL Creating account and changing password
This MySQL provide the new creating account or you want to change the password then make new user .This lesson you learn how to create new password.
Backup and Restore MySQL Databases
It is a good idea to backup your MySQL data occasionally as a precautionary measure. It is also a good idea to create a backup before making any major changes, incase something goes wrong and you need to revert to the unmodified version. Database backups can also be used to transfer your database from one server to another if you change web hosts.
Setting the minimum word length for MySQL text search
MySQL text search function comes by default with a minimum word length of four letters.If you try searching for the word 'PHP', you'll get zero matches even if there are.As of MySQL 4.x.x you can change the minimum word length to whatever you want. That is how you do it.
 
Categories