Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [ddl]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2 votes
2 answers
2k views

User Error: DDL statements are not allowed in transactions Magento 2.2.6

I want to achieve following functionality: Whenever user tries to insert new data, i want to remove all old data from my custom table and insert new data. For this, i want to use truncateTable() ...
2 votes
0 answers
620 views

What is the DDL cache, and what is it used for?

I never found any resource what the DDL cache is used for, and what kind of data it contains. Also it always worked for me, so I had no need to look into this yet.
6 votes
2 answers
4k views

How to set CURRENT_TIMESTAMP as a default value in Magento DDL

I am updating my table structure and everything work good, but default value for column created_at is 0000-00-00 00:00:00 again and again. I want it to be equal to current time (CURRENT_TIMESTAMP); ...
0 votes
1 answer
242 views

What `null` size means in Framework/DB/Ddl/Table.php?

I refer to this file, function addColumn I need to confirm whether I have understood correctly or not the null value of field size. When I set size null , does this mean that the index's size will be ...
1 vote
1 answer
1k views

Magento 2: Any Difference between TYPE_NUMERIC and TYPE_DECIMAL?

In Magento 2's migration/data-definition-language, there are two column type constants #File: vendor/magento/framework/DB/Ddl/Table.php const TYPE_NUMERIC = 'numeric'; const TYPE_DECIMAL = 'decimal';...