Magento
Magento
8/10
Rate it
What is Magento?
Magento is an open-source CMS wrote in PHP, that gives business owners an opportunity to expand their business operations in the digital e-commerce world. It's a powerful system, flexible, scalable and easy to customize.

Magento has a good security system, which is beyond SEO ready. Currently, it has two versions; Magento Community and Magento Enterprise. The community version is free and mostly aimed at small businesses. Magento Enterprise is a paid platform aimed at medium to large businesses. The overall performance is very impressive with exciting features and extensions. With its larger community, you can get help anywhere whenever you need it.
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