Tech-Today
This query imitate the desc operation from mysql into mssql. It produces the columns and descriptions of the Products table from the Northwind database.
- How To Install Mysql In Ubuntu 16.04
The following commands allow us to install a MySQL server on Ubuntu 16.04, create a database, user and table. And finally, tune the server. # install mysql sudo apt-get update sudo apt-get upgrade sudo apt-get install mysql-server sudo mysql_secure_installation...
- Database
MSSQLMSSQL equivalent of DESC in MYSQLPostgresqlChange postgresql's postgres passwordHow to install hstore in postgresql 9.1JDBC provider setting in java for postgresql, mysql and oracleHow to alter the sequence value in postgresqlOracleHow to change...
- Passing An Array Of Objects To Mssql Stored Procedure
Oftentimes you need to pass an array of objects (could be ids, types, etc) in an mssql stored procedure that you either need to insert into a table or use as filter. The following codes will explain the latter: Pass an array of integers: ALTER PROCEDURE...
- How To Connect Mysql Or Postgresql Server From Java Using Jdbc Driver
How to connect MySql or PostgreSql Server from Java using JDBC Driver I think the best answer to this is through coding: private static Connection getConnection() { Connection conn = null; try { Class.forName("com.mysql.jdbc.Driver"); //conn = DriverManager.getConnection("jdbc:postgresql://127.0.0.1:5432/anime",...
- Mysql Engine: Myisam Vs Innodb
MyISAM (http://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engine.html) -to create a MyISAM table, add ENGINE = MYISAM; at the end of create table script -supports table locking (this is an issue when you need to backup the whole database) -fast execution...
Tech-Today
Mysql desc operation in mssql. This query imitate the desc operation from mysql into mssql
This query imitate the desc operation from mysql into mssql. It produces the columns and descriptions of the Products table from the Northwind database.
SELECT
column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS a
INNER JOIN information_schema.columns AS b
ON a.table_catalog = b.table_catalog
AND a.table_schema = b.table_schema
AND a.table_name = b.table_name
WHERE a.table_name = 'Products';
- How To Install Mysql In Ubuntu 16.04
The following commands allow us to install a MySQL server on Ubuntu 16.04, create a database, user and table. And finally, tune the server. # install mysql sudo apt-get update sudo apt-get upgrade sudo apt-get install mysql-server sudo mysql_secure_installation...
- Database
MSSQLMSSQL equivalent of DESC in MYSQLPostgresqlChange postgresql's postgres passwordHow to install hstore in postgresql 9.1JDBC provider setting in java for postgresql, mysql and oracleHow to alter the sequence value in postgresqlOracleHow to change...
- Passing An Array Of Objects To Mssql Stored Procedure
Oftentimes you need to pass an array of objects (could be ids, types, etc) in an mssql stored procedure that you either need to insert into a table or use as filter. The following codes will explain the latter: Pass an array of integers: ALTER PROCEDURE...
- How To Connect Mysql Or Postgresql Server From Java Using Jdbc Driver
How to connect MySql or PostgreSql Server from Java using JDBC Driver I think the best answer to this is through coding: private static Connection getConnection() { Connection conn = null; try { Class.forName("com.mysql.jdbc.Driver"); //conn = DriverManager.getConnection("jdbc:postgresql://127.0.0.1:5432/anime",...
- Mysql Engine: Myisam Vs Innodb
MyISAM (http://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engine.html) -to create a MyISAM table, add ENGINE = MYISAM; at the end of create table script -supports table locking (this is an issue when you need to backup the whole database) -fast execution...