It was kind of hard to get an example entity field query for drupal 8 that returns all the related content of an entity reference field. So here it is.
mysql
Articles about mysql
First we have to make sure that we have the starting and ending date in the correct drupal datetime format:
Recently i had to build a custom simple table in a drupal 8 installation that would be used as an api feed bridge between drupal 8 and a custom api feed service. This is the code i used for the custom table with an extra tip for the date field since there is no date type by default in drupal.
Recently i had to import a db from production to localhost, so i thought this would be an easy task (Murphy's law, it never is easy when you want it).
SELECT CONCAT(table_schema, '.', table_name),
CONCAT(ROUND(table_rows / 1000000, 2), 'M') rows,
CONCAT(ROUND(data_length / ( 1024 * 1024 * 1024 ), 2), 'G') DATA,
C
For Export:
mysqldump -u [user] -p [db_name] | gzip > [filename_to_compress.sql.gz]
For Import:
gunzip
Hi.Recently a client and friend of mine asked me if we could somehow 'limit' the posts of a user per week or per day or per x-days . I told him that this was possible not only for a certain node content type but for all of the content types that a user could use ( or had permissions for ) .