If you’re building a Drupal 10 website, you’ll probably need to work with a database at some point. Whether you’re retrieving data from the database or making changes, you’ll need to use SQL queries. In this blog post, we’ll cover the basics of four common database queries in Drupal 10: insert, update, delete, and select.<\/p>\n
An insert query adds new data to a database table. Here’s an example of an insert query in Drupal 10:<\/p>\n
$query = \\Drupal::database()->insert('ttn_mysql_table');\r\n$query->fields([ 'name' => 'Rajveer', 'age' => 30,]);\r\n$query->execute();\r\n\r\n\r\n<\/pre>\nUpdate Query<\/h4>\n
An update query changes data in an existing database table. Here’s an example of an update query in Drupal 10:<\/p>\n
$query = \\Drupal::database()->update('ttn_mysql_table');\r\n$query->fields([\r\n'age' => 31,\r\n]);\r\n$query->condition('name', 'Rajveer');\r\n$query->execute();<\/pre>\nDelete Query<\/h4>\n
A delete query removes data from a database table. Here’s an example of a delete query in Drupal 10:<\/p>\n
\n$query = \\Drupal::database()->delete('ttn_mysql_table');\r\n$query->condition('age', 30);\r\n$query->execute();<\/pre>\n<\/div>\n\nSelect Query<\/h4>\n
A select query retrieves data from a database table. Here’s an example of a select query in Drupal 10:<\/p>\n
$query = \\Drupal::database()->select('ttn_mysql_table', 't');\r\n$query->fields('t', ['id', 'name']);\r\n$result = $query->execute();\r\n\r\nforeach ($result as $row) {\r\n$id = $row->id;\r\n$name = $row->name;\r\n\/\/ Do something with the results.\r\n}<\/pre>\n<\/div>\n