I have to write insert query for Magento 2
cms_block table, what should i write for the column
row_id block_id created_in updated_in title identifier content 254 254 1 2147483647 Designer designer "<p><span></span></p>" creation_time update_time is_active 2018-08-21 00:21:47 2018-09-18 01:00:07 1
These are the entries which are already there in
cms_block, I have to create a msyql script insert queries so that i can run it on mysql console.
created_in = 1 mean? similarly what is
updated_in= 2147483647 mean
looking at their data types they are
update_time i will use timestamp, but what to use for
updated_in in my sql query.
And if there is another approach to achieve that, I looked on this link:- Magento 2: How to insert data into custom table in model file?
But my requirement is to run insert query on the MySQL terminal for Magento 2, and for that, I don't the meaning of two columns created_in, updated_in and if that's epoc time then how to do that in MySQL query
UPDATE WHEN I MANUALLY INSERT VALUE FOR ALL COLUMNS , following error occurs
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`webster`.`cms_block`, CONSTRAINT `CMS_BLOCK_BLOCK_ID_SEQUENCE_CMS_BLOCK_SEQUENCE_VALUE` FOREIGN KEY (`block_id`) REFERENCES `sequence_cms_block` (`sequence_value`) ON DELETE CASCADE)