Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag MySQL Rss

   Items 1 to 16 of 16   
 

New MySQL Engine Supports T-SQL

MySQL has a new query processor that will run your T-SQL code.  Read more...
By Press Release 2016/04/01 | Source: SQLServerCentral.com | Category: mysql
Rating: |  Discuss |   Briefcase | 1,236 reads

Top 10 MySQL Reporting Tools

Both management and various departments rely on data reports to help guide their business decisions. Rob Gravelle presents ten open source and commercial report generation tools for MySQL and other relational databases.  Read more...
By Additional Articles 2016/01/11 | Source: Database Journal | Category: mysql
Rating: (not yet rated)  Rate this |   Briefcase | 4,338 reads

MySQL Pattern Matching using Regular Expressions

In this follow-up to Beyond the LIKE Operator: Advanced Pattern Matching with MySQL, Rob Gravelle shows how to use the REGEXP operator to match alphanumeric characters, explores the role of meta-characters, and compares standard regular expression syntax to that of MySQL.  Read more...
By Additional Articles 2015/12/02 | Source: Database Journal | Category: mysql
Rating: (not yet rated)  Rate this |   Briefcase | 3,410 reads

Common MySQL Insert and Update Tasks and Their Solutions

Inserting and updating table contents with data from other tables and/or views within the same database need not be a nail-biting ordeal. Rob Gravelle shares some common Insert and Update tasks to help avoid any problems.  Read more...
By Additional Articles 2015/09/25 | Source: Database Journal | Category: mysql
Rating: (not yet rated)  Rate this |   Briefcase | 2,429 reads

MySQL Error Handling using the Signal and Resignal Statements

MySQL introduced the SIGNAL and RESIGNAL statements in version 5.5 to allow you to raise your own error conditions from stored procedures, triggers, and events. Rob Gravelle demonstrates how to utilize both.  Read more...
By Additional Articles 2015/08/17 | Source: Database Journal | Category: mysql
Rating: (not yet rated)  Rate this |   Briefcase | 1,678 reads

Integration Services, MySql and SET FMTONLY ON

Challenges with integrating MySQL data in an ETL regime and the Amazing FMTONLY trick!  Read more...
Rating: |  Discuss |   Briefcase | 2,962 reads

Linked server creation to MySQL Server

Here is a step by step procedure to create a linked server to MySQL from SQL Server.  Read more...
By Vinayaka Gangadhar 2014/10/13 | Source: SQLServerCentral.com | Category: linked server
Rating: |  Discuss |   Briefcase | 3,086 reads

Stairway to SQL Dialects Level 3: MySQL

As part of the LAMP stack, MySQL is incredibly important for providing a reliable and platform-agnostic database platform for web development. This level looks at the syntax of MySQL and how to best port SQL code to a MySQL environment.  Read more...
By Joe Celko 2012/12/05 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,950 reads

10 tips on converting MS SQL queries to MySQL

The syntax of SQL queries in MS SQL and MySQL are similar but not identical. This article discovers 10 most popular differences between MS SQL and MySQL syntax.   Read more...
By Oleg Fedorov 2012/06/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,078 reads

20 tips on converting MySQL views to MS SQL

This article gives 20 tips how to modify MySQL views to make it compatible with Microsoft SQL Server.   Read more...
By Andrew Kuprianov 2012/05/02 | Source: SQLServerCentral.com | Category: mysql
Rating: |  Discuss |   Briefcase | 3,022 reads

Export data from MySQL to SQL Server

Many people want to create a customized migration process using SQL Server Integration Services (SSIS), but it is hard to start working with heterogeneous databases like MySQL, Postgres, DB2, etc. Check out this tip to learn about how to import data from heterogeneous databases like MySQL to SQL Server.  Read more...
By Additional Articles 2012/04/20 | Source: MSSQLTips.com | Category: mysql
Rating: (not yet rated)  Rate this |   Briefcase | 3,254 reads

Linked server to MySQL Server.

In this article, we are going to create a linked server to the MySQL Database. Once finished that task, we will select, insert, update and delete some data using SQL Server.   Read more...
By Daniel Calbimonte 2012/04/17 | Source: SQLServerCentral.com | Category: mysql
Rating: |  Discuss |   Briefcase | 5,853 reads

Microsoft SQL Server vs. MySQL

Is Microsoft SQL Server superior to MySQL or not? What are the pros and cons of using SQL Server over MySQL? Is MySQL mature enough to compete with a big player like Microsoft and Oracle? Can we fairly compare both products?  Read more...
By Additional Articles 2010/01/29 | Source: MSSQLTips.com | Category: sql server
Rating:  Rate this |   Briefcase | 8,932 reads

Did Oracle buy MySQL by accident?

The wording of the statement about MySQL that came out from Oracle after the merger was downbeat. The implication was "Oh no! Another Blooming Database to deal with". But surely they don't plan to just let it drift?  Read more...
By Tony Davis 2009/08/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 164 reads

Guest editorial: Reasons to be Cheerful

The furore surrounding the recent release of MySQL 5.1 makes Tony Davis wonder if more than a few web 2.0 developers might be peering over the SQL Server Express fence and wondering if the grass doesn't look slightly greener over here.  Read more...
By Tony Davis 2009/02/04 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 176 reads

MySQL Primer for the SQL Sever DBA

This is an introduction into Mysql for the SQL Server user. It compares the various engines of Mysql and how they compare to SQL Server.  Read more...
By Ken Kaufman 2008/08/08 | Category: mysql
Rating: |  Discuss |   Briefcase | 7,440 reads
   Items 1 to 16 of 16   
 
Tags
editorial (2)    
t-sql (2)    
database weekly (1)    
error handling (1)    
export (1)    
fmtonly (1)    
insert and update (1)    
integration services (ssis) (1)    
linked (1)    
linked server (1)    
migration (1)    
oracle (1)    
pattern matching (1)    
reporting (1)    
resignal (1)    
server (1)    
signal (1)    
sql dialects (1)    
sql server (1)    
sqlservercentral (1)    
stairway series (1)    
syntax (1)