1

I'm using MariaDB as database backend and I would like to use built in "Sequences" to get an integer number generator. I need to dinamically create sequences and get their values. Following this documentation I know the right sql commands to do it and I have tested it on MariaDB, but I haven't found a way to run this commands from Drupal 8 database connection object. I can only do selects, updates, inserts or deletes. How could I run this custom sql? I need it because I have to create custom sequences on submit some form.

5

I haven't found a way to run this commands from Drupal 8 database connection object. I can only do selects, updates, inserts or deletes

That's not true, you can also run arbitrary queries, e.g.:

\Drupal::database()->query('TRUNCATE TABLE foo');
1
  • Yes, it works. I've tried with "CREATE SEQUENCE..." but I always got an error and I supposed I didn't work. I don't know what I did to get this error. I'm sorry. You are right. It works good. – briast Nov 12 '20 at 16:04
-1

You can run your SQL query in your Drupal Project. Read this Static Queries Article. you will get detailed explaination of syntax and examples.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.