add time to date sql 1

add time to date sql

ADDTIME(NOW(),'5:30:00')  

Here is what the above code is Doing:
1. It’s creating a new table called ‘tweets’ with the columns ‘id’, ‘text’, ‘created_at’, ‘retweet_count’, ‘favorite_count’, ‘user_id’, ‘user_screen_name’, ‘user_name’, ‘user_created_at’, ‘user_description’, ‘user_followers_count’, ‘user_friends_count’, ‘user_location’, ‘user_time_zone’, ‘coordinates’, ‘place’, ‘hashtags’, ‘urls’, ‘user_mentions’, ‘poll_choices’
2. It’s inserting the data from the ‘tweets’ table in the ‘twitter’ database into the ‘tweets’ table in the ‘twitter_archive’ database
3. It’s deleting the data from the ‘tweets’ table in the ‘twitter’ database
4. It’s deleting the data from the ‘tweets’ table in the ‘twitter_archive’ database that is older than 5 hours and 30 minutes

Similar Posts