Advanced Search

Return to Snippet

Revision: 57012
at May 4, 2012 04:34 by navblue
Initial Code 
ALTER TABLE  `table` ADD  `created` DATETIME NOT NULL ,
ADD  `modified` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
add created datetime and modified timestamp columns to table

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
mysql create modify default timestamp

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL