CircleCI
CircleCI
8/10
Rate it
What is CircleCI?
CircleCI is a continuous integration and delivery platform that helps users develop and publish software at scale. The technology delivers speed and configurability required to automate users pipeline from building, testing, and deploying code.

CircleCI’s integration with GitHub, GitHub Enterprise, and Bitbucket allows users to easily create a build when a code is committed. Features for automated testing in a clean container or virtual machine are also available. Team members receive notifications in case a build falls short so that they could repair immediately.

Passing builds for automated deployment to different environments allow developers to launch products more quickly. Custom job orchestration via Workflows give users full control over how they want to construct their software.
Tags

Tips

Create / Open / Delete Database
CREATE DATABASE dbNameYouWant
CREATE DATABASE dbNameYouWant CHARACTER SET utf8
USE dbNameYouWant
DROP DATABASE dbNameYouWant
ALTER DATABASE dbNameYouWant CHARACTER SET utf8
Update
UPDATE table1 SET field1=new_value1 WHERE condition
UPDATE table1, table2 SET field1=new_value1, field2=new_value2, ... WHERE table1.id1 = table2.id2 AND condition
Insert
INSERT INTO table1 (field1, field2, ...) VALUES (value1, value2, ...)
Conditions
field1 = value1
field1 <> value1
field1 LIKE 'value _ %'
field1 IS NULL
field1 IS NOT NULL
field1 IS IN (value1, value2)
field1 IS NOT IN (value1, value2)
condition1 AND condition2
condition1 OR condition2