Useful tips for everyday
Which is optional in vacuum in PostgreSQL? In the examples below, [tablename] is optional. Without a table specified, VACUUM will be run on available tables…
Can we use where condition in insert statement? Copying specific rows from a table: We can copy specific rows from a table to insert into…
Can I change MySQL port? You should find the directory of MySQL installation and find the my. ini file. You can then edit the port…
What are ERD tools? Entity Relationship Diagram (ERD), a database design tool that provides graphical representation of database tables, their columns and inter-relationships. ERD is…
How to create email trigger in SQL? The following Trigger is fetching the CustomerId of the inserted record and the fetched value is sent through…
What performs decimal arithmetic? Computers, calculator, or other specialized digital systems that perform arithmetic operations directly in the decimal number system represent decimal numbers in…
How do you connect PyMongo? On the python command line: import pymongo from pymongo import MongoClient connection = MongoClient() ## connects by default to db…
How to restore SQL database after log shipping? The database is called VLDB with log shipping set up successfully as shown. These are three jobs…
Is it wrong to join to another table after group by? I don’t think that it’s “wrong” in this case, because you’ve got a one-to-one…
What is a tablespace used for? A tablespace is a storage location where the actual data underlying database objects can be kept. It provides a…