mysql - current_timestamp and null

29
February 12, 2019, at 11:20 AM

I have question about mysql configuration. I have the same database on AWS and local apache server on ubuntu.

In my table I have column type timestamp with current_timestamp and when I trying to add new row with NULL on my local server it works fine and puting current date, but when I trying the same on AWS then I see error with information that column should not be null. I want to change my local server configuration to the same like AWS. Maybe somebody knows where I can do this?

READ ALSO
How to export a database (.sql) file to remote database through wifi? [on hold]

How to export a database (.sql) file to remote database through wifi? [on hold]

I have external database where I have export thesql file to my local now I want to import the same database through terminal by using wifi to another

22
how can i structure posts, shared posts and pages table in mysql database?

how can i structure posts, shared posts and pages table in mysql database?

I am working on a social networking site and i need to structure my POSTS table, SHARED_POSTS table and PAGES table and i don't know the best way to go about thisi have my USERS table and each post being made by a user is stored in the POSTS table with the current...

46
Mysql order on calculation with variable from outside tables

Mysql order on calculation with variable from outside tables

Can I do a calculation like this in MySQL:

35