how do I disable the require primary key when creating a table y mysql database?
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Accepted Answer
Hi there,
To do that you can use the DigitalOcean API:
https://docs.digitalocean.com/reference/api/api-reference/#operation/databases_patch_config
You can find a list of the available configuration options via the link above, but specifically for disabling the required primary keys, you can do the following:
curl -X PATCH \
-H "Content-Type: application/json" \
-H "Authorization: Bearer $DIGITALOCEAN_TOKEN" \
-d '{"config": {"sql_require_primary_key": false}}' \
"https://api.digitalocean.com/v2/databases/your-db-id-here/config"
Alternatively, you could use the doctl CLI to do the same:
https://docs.digitalocean.com/reference/doctl/reference/databases/configuration/update/
Hope that this helps!
- Bobby
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.