Computer techniques
Databases
Auto-assign the last modification time of a row (PostgreSQL/MySQL)
PostgreSQL
Depending on the DBMS, the way to automatically assign the date and time on the modified lines differs.
Compile pgModeler on Windows
PostgreSQL
pgModeler is an Open Source software allowing to model a database, that is to say to schematize everything related to the construction of a base (tables, fields, relations, constraints ...) and oriented towards the...
Obtain SQL Server port
SQL Server
To obtain the TCP / IP port of a SQL Server database, several solutions are possible. Via a request on the server. Using the following query: SELECT DISTINCT local_tcp_port FROM sys.dm_exec_connections WHERE...
Avoid too large MySQL logs
MySQL
You can quickly have your hard drive flooded with files mysql-bin.xxxxxx (mysql-bin.000001...). These files are MySQL logs which trace all the modifications to the database.It is best to disable them by modifying...
Search in this website
  |  RSS |  Informations |