Drupal
Drupal
7/10
Rate it
What is Drupal?
Drupal is a free and open-source content management framework written in PHP and distributed under the GNU General Public License. Drupal provides a back-end framework for at least 2.3% of all websites worldwide – ranging from personal blogs to corporate, political, and government sites. Systems also use Drupal for knowledge management and business collaboration.

As of March 2019, the Drupal community comprised more than 1.37 million members, including 114,000 users actively contributing, resulting in more than 42,650 free modules that extend and customize Drupal functionality, over 2,750 free themes that change the look and feel of Drupal, and at least 1,270 free distributions that allow users to quickly and easily set up a complex, use-specific Drupal in fewer steps.
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