mssql vs mysql data type mapping

@@ mssql vs mysql data type mapping

http://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-typemapping.html

http://www.sqlines.com/sql-server-to-mysql/functions/convert_string

mariadb, mysql feartures

  1. timestamp default는 테이블에 오직 하나만 가능.
  2. 테이블 upt-date 는  timestap –> datetime으로 변경 default 제거, null 허용해 해결
  3. timestamp는 default 가능한 2038년에 만료됨.

Leave a Reply

Your email address will not be published. Required fields are marked *