Useful tips for everyday
What is a LOB segment? LOB is the acronym for Large OBject. When you create a LOB column for a table, you are actually creating…
Is there a way to repair a mySQL table? This article describes how to repair MySQL tables and databases. As a database’s tables grow, errors…
How to simulate create database if not exists for PostgreSQL? SQL procedures, introduced with Postgres 11, cannot help with this either. You can work around…
Can we use or in WHERE clause? The WHERE condition in SQL can be used in conjunction with logical operators such as AND and OR,…
How do you represent a multi-valued attribute in a database? Relationship : Storing multiple values for one attribute of an entity is done through referenced…
How do I change the default value in MySQL workbench? To change the name, data type, default value, or comment of a column, double-click the…
How do I sort pivot table results highest to lowest? To sort pivot table column: Right-click on a value cell, and click Sort. Then, click…
What is seed in rand ()? srand() uses its argument seed as a seed for a new sequence of pseudo-random numbers to be returned by…
How do you build a referral system? How to Create a Customer Referral Program Start with customer referral templates. Set your goals. Research how referrals…
What does a Trancount statement do in SQL? @@TRANCOUNT (Transact-SQL) Returns the number of BEGIN TRANSACTION statements that have occurred on the current connection. What…