Useful tips for everyday
How do I change my CNF in MySQL? Editing the Mysql my. cnf File Login to your server via SSH. To edit the MySQL settings…
How do I create a private database link in Oracle? To create a private database link, you must have the CREATE DATABASE LINK system privilege.…
Why is the ibdata1 file continuously growing in MySQL? When the ibdata1 file is growing too fast within MySQL it is usually caused by a…
How do I change the data type of a field? Locate the field that you want to change, and select a new data type from…
How can we fetch data from one table and insert into another table? The SQL INSERT INTO SELECT Statement The INSERT INTO SELECT statement copies…
How do I convert multiple columns to one row in Excel? Select and name the multiple column data table you want to convert to a…
How can I open XML file in SQL Server? Instructions CREATE TABLE PointsXML — Create table for raw XML file. ( Id INT IDENTITY PRIMARY…
How use SELECT and update together in SQL? UPDATE from SELECT: Join Method. In this method, the table to be updated will be joined with…
How do you update a column with a SELECT statement in SQL? The UPDATE from SELECT query structure is the main technique for performing these…
Do I need a quorum witness? Now there is a witness, you can lose a node and keep the quorum. Even if a node is…