Mysql 5 5 41 64 bit

".$myvar{'version'}."\n"; } else { goodprint "Currently running supported MySQL version ".$myvar{'version'}."\n"; } } # Checks if MySQL version is greater than equal to (major, minor) sub mysql_version_ge { my ($maj, $min) = @_; return $mysqlvermajor > $maj || ($mysqlvermajor == $maj && $mysqlverminor >= ($min || 0)); } # Checks for 32-bit boxes with more than 2GB of RAM my ($arch); sub check_architecture { if ($doremote eq 1) { return; } if (`uname` =~ /SunOS/ && `isainfo -b` =~ /64/) { $arch = 64; goodprint "Operating on 64-bit architecture\n"; } elsif (`uname` !~ /SunOS/ && `uname -m` =~ /64/) { $arch = 64; goodprint "Operating on 64-bit architecture\n"; } elsif (`uname` =~ /AIX/ && `bootinfo -K` =~ /64/) { $arch = 64; goodprint "Operating on 64-bit architecture\n"; } else { $arch = 32; if ($physical_memory > 2147483648) { badprint "Switch to 64-bit OS - MySQL cannot currently use all of your RAM\n"; } else { goodprint "Operating on 32-bit architecture with less than 2GB RAM\n"; } } } # Start up a ton of storage engine counts/statistics my (%enginestats,%enginecount,$fragtables); sub check_storage_engines { if ($opt{skipsize} eq 1) { print "\n-------- Storage Engine Statistics -------------------------------------------\n"; infoprint "Skipped due to --skipsize option\n"; return; } print "\n-------- Storage Engine Statistics -------------------------------------------\n"; infoprint "Status: "; my $engines; $engines .= (defined $myvar{'have_archive'} && $myvar{'have_archive'} eq "YES")? greenwrap "+Archive " : redwrap "-Archive " ; $engines .= (defined $myvar{'have_bdb'} && $myvar{'have_bdb'} eq "YES")? greenwrap "+BDB " : redwrap "-BDB " ; $engines .= (defined $myvar{'have_federated_engine'} && $myvar{'have_federated_engine'} eq "YES")? greenwrap "+Federated " : redwrap "-Federated " ; $engines .= (defined $myvar{'have_innodb'} && $myvar{'have_innodb'} eq "YES")? greenwrap "+InnoDB " : redwrap "-InnoDB " ; $engines .= (defined $myvar{'have_isam'} && $myvar{'have_isam'} eq "YES")? greenwrap "+ISAM " : redwrap "-ISAM " ; $engines .= (defined $myvar{'have_ndbcluster'} && $myvar{'have_ndbcluster'} eq "YES")? greenwrap "+NDBCluster " : redwrap "-NDBCluster " ; print "$engines\n"; if (mysql_version_ge(5)) { # MySQL 5 servers can have table sizes calculated quickly from information schema my @templist = `mysql $mysqllogin -Bse "SELECT ENGINE,SUM(DATA_LENGTH),COUNT(ENGINE) FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('information_schema','mysql') AND ENGINE IS NOT NULL GROUP BY ENGINE ORDER BY ENGINE ASC;"`; foreach my $line (@templist) { my ($engine,$size,$count); ($engine,$size,$count) = $line =~ /([a-zA-Z_]*)\s+(\d+)\s+(\d+)/; if (!defined($size)) { next; } $enginestats{$engine} = $size; $enginecount{$engine} = $count; } $fragtables = `mysql $mysqllogin -Bse "SELECT COUNT(TABLE_NAME) FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('information_schema','mysql') AND Data_free > 0 AND NOT ENGINE='MEMORY';"`; chomp($fragtables); } else { # MySQL my @tblist; # Now we build a database list, and loop through it to get storage engine stats for tables my @dblist = `mysql $mysqllogin -Bse "SHOW DATABASES"`; foreach my $db (@dblist) { chomp($db); if ($db eq "information_schema") { next; } my @ixs = (1, 6,

SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures and functions, triggers, SQL queries and SQL scripts from MySQL to Microsoft SQL Server (MS SQL, MSSQL), Azure SQL and Azure Synapse.SQLines Data - Data Transfer, Schema Migration and Validation toolDatabases MySQL 8.x and 5.x Microsoft SQL Server 2022, 2019, 2017, 2016, 2014, 2012, 2008 and 2005Migration ReferenceSQL Language ElementsConverting language elements and constructs: MySQL SQL Server 1 b'100' Binary string 0x04 Hex string only IdentifiersConverting identifiers: MySQL SQL Server Quoted Identifiers ` (backtick) and " (double quotes) [ ] and " (double quotes) Data TypesConverting character data types: MySQL SQL Server 1 CHAR(n), CHARACTER(n) Fixed-length string, 1 ⇐ n ⇐ 255 CHAR(n), CHARACTER(n) 2 CHARACTER VARYING(n) Variable-length string, 1 ⇐ n ⇐ 65535 CHARACTER VARYING(n) 3 LONGTEXT Character large object, ⇐ 4G VARCHAR(max) 4 LONG, LONG VARCHAR Character large object, ⇐ 16M VARCHAR(max) 5 MEDIUMTEXT Character large object, ⇐ 16M VARCHAR(max) 6 NCHAR(n) Fixed-length UTF-8 string, 1 ⇐ n ⇐ 255 NCHAR(n) 7 NVARCHAR(n) Varying-length UTF-8 string, 1 ⇐ n ⇐ 65535 NVARCHAR(n) 8 TEXT Character large object, ⇐ 64K VARCHAR(max) 9 TINYTEXT Character data, ⇐ 255 bytes VARCHAR(255) 10 VARCHAR(n) Variable-length string, 1 ⇐ n ⇐ 65535 VARCHAR(n) Converting numeric data types: MySQL SQL Server 1 BIGINT 64-bit integer BIGINT 2 DECIMAL(p,s) Fixed-point number, p ⇐ 65, default 10 DECIMAL(p,s) p ⇐ 38, default 18 3 DEC(p,s) Synonym for DECIMAL DEC(p,s) 4 DOUBLE [PRECISION] Double-precision floating-point number FLOAT 5 FIXED(p,s) Synonym for DECIMAL DECIMAL(p,s) 6 FLOAT(p) Floating-point number FLOAT 7 FLOAT4(p) Floating-point number FLOAT 8 FLOAT8 Double-precision floating-point number BINARY_DOUBLE 9 INT, INTEGER 32-bit integer INT, INTEGER 10 INT1 8-bit integer SMALLINT 11 INT2 16-bit integer SMALLINT 12 INT3 24-bit integer INT 13 INT4 32-bit integer INT 14 INT8 64-bit integer BIGINT 15 MEDIUMINT 24-bit integer INT 16 MIDDLEINT 24-bit integer INT 17 NUMERIC(p,s) Synonym for DECIMAL NUMERIC(p,s) 18 REAL Double-precision floating-point number DOUBLE PRECISION 19 SERIAL 64-bit autoincrementing integer NUMERIC(20) 20 SMALLINT 16-bit integer SMALLINT 21 TINYINT 8-bit integer SMALLINT Converting date and time data types: MySQL SQL Server 1 DATE Date (year, month and day) DATE Since SQL Server 2008 2 DATETIME(p) Date and time data with fraction DATETIME2(p) 3 TIME(p) Time (Hour, minute, second and fraction) TIME(p) 4 TIMESTAMP(p) Auto-updated datetime DATETIME2(p) 5 YEAR[(2 | 4)] Year in 2-digit or 4-digit format NUMERIC(4) Converting other data types: MySQL SQL Server 1 BINARY(n) Fixed-length byte string, 1 ⇐ n ⇐ 255 BINARY(n) 2 BIT(n) Fixed-length bit string, 1 n BINARY(n/8) 3 BLOB(n) Binary large object, ⇐ 64K VARBINARY(max) 4 BOOLEAN, BOOL 0 or 1 value; NULL is not allowed BIT 5 LONGBLOB Binary large object, ⇐ 4G VARBINARY(max) 6 LONG VARBINARY Binary

CAST(enum_col AS CHAR); CAST() also changes the result if you use it as part of a more complex expression such as CONCAT('Date: ',CAST(NOW() AS DATE)). For temporal values, there is little need to use CAST() to extract data in different formats. Instead, use a function such as EXTRACT(), DATE_FORMAT(), or TIME_FORMAT(). See Section 14.7, “Date and Time Functions”. To cast a string to a number, it normally suffices to use the string value in numeric context: mysql> SELECT 1+'1'; -> 2 That is also true for hexadecimal and bit literals, which are binary strings by default: mysql> SELECT X'41', X'41'+0; -> 'A', 65mysql> SELECT b'1100001', b'1100001'+0; -> 'a', 97 A string used in an arithmetic operation is converted to a floating-point number during expression evaluation. A number used in string context is converted to a string: mysql> SELECT CONCAT('hello you ',2); -> 'hello you 2' For information about implicit conversion of numbers to strings, see Section 14.3, “Type Conversion in Expression Evaluation”. MySQL supports arithmetic with both signed and unsigned 64-bit values. For numeric operators (such as + or -) where one of the operands is an unsigned integer, the result is unsigned by default (see Section 14.6.1, “Arithmetic Operators”). To override this, use the SIGNED or UNSIGNED cast operator to cast a value to a signed or unsigned 64-bit integer, respectively. mysql> SELECT 1 - 2; -> -1mysql> SELECT CAST(1 - 2 AS UNSIGNED); -> 18446744073709551615mysql> SELECT CAST(CAST(1 - 2 AS UNSIGNED) AS SIGNED); -> -1 If either operand is a floating-point value, the result is a floating-point value and is not affected by the preceding rule. (In this context, DECIMAL column values are regarded as floating-point values.) mysql> SELECT CAST(1 AS UNSIGNED) - 2.0; -> -1.0 The SQL mode affects the result of conversion operations (see Section 7.1.11, “Server SQL Modes”). Examples: For conversion of a “zero” date string to a date, CONVERT() and CAST() return NULL and produce a warning when the NO_ZERO_DATE SQL mode is enabled. For integer subtraction, if the NO_UNSIGNED_SUBTRACTION SQL mode is enabled, the subtraction result is signed even if any operand is unsigned.