Hey guys,
I've been dealing with a bizarre and frustrating problem on my web server (it's a LAMP stack) where for some reason, every time you create a field of type TIMESTAMP (from the UI, from SQL code, or programmatically from PHP) it makes a unilateral decision that I absolutely need to add "ON UPDATE CURRENT_TIMESTAMP" to the syntax. This means that every time I update a record with a timestamp (even if I'm not changing it), that timestamp will automatically be forced to be = the current date/time. I Googled up a workaround...
ALTER TABLE table_name
CHANGE column_name
column_name TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
..but I'm guessing there's some super-simple bit of SQL I can use in CREATE TABLE queries to prevent this wackadellic behavior altogether... or is there? Any of you ever fought with this one before? How did you get it to stop inserting "ON UPDATE CURRENT_TIMESTAMP" because it felt like it? Any clues as to the actual cause of this bug? Thanks in advance
- Home Board index General Other Programming Languages
- Search
-
- It is currently 23 Apr 2024, 01:50
- All times are UTC-05:00
SQL timestamps: ON UPDATE do nothing?
Discuss other programming languages besides AutoHotkey
Return to “Other Programming Languages”
Jump to
- AutoHotkey Foundation
- About This Community
- Forum Issues
- AutoHotkey (v2, current version)
- Ask for Help (v2)
- Gaming
- Scripts and Functions (v2)
- Gaming
- Tutorials (v2)
- Tips and Tricks
- Wish List
- Suggestions on Documentation Improvements
- Bug Reports
- AutoHotkey Development
- AutoHotkey_H
- Ask for Help
- Development
- Editors
- Adventure IDE
- Old Topics
- AHK Studio
- Notepad++
- Pulovers Macro Creator
- SciTE4AutoHotkey
- Visual Studio Code
- Announcements
- General Discussion
- AutoHotkey (v1.1 and older)
- Ask for Help (v1)
- Gaming Help (v1)
- Scripts and Functions (v1)
- Gaming Scripts (v1)
- Tutorials (v1)
- Tips and Tricks (v1)
- General
- Other Utilities & Resources
- Other Programming Languages
- C/C++
- ASM
- C#
- KeySharp
- Off-topic Discussion
- RPA
- Other languages
- Looking for Volunteers in other languages
- Deutsch (German)
- Ich brauche Hilfe
- Spiele
- Skripte und Funktionen
- Tutorials
- Tooltime
- Allgemeines
- 中文 (Chinese)
- 请求帮助
- 脚本函数
- 教程资料
- 相关工具
- 其他
- Español (Spanish)
- Pedir Ayuda
- Automatización de Juegos
- Scripts y Funciones
- Tutoriales
- Otras Utilidades y Recursos
- General
- Русский (Russian)
- Помощь
- Скрипты для Игр
- Скрипты и библиотеки
- Статьи и руководства
- Прочие ресурсы и ПО.
- Свободное общение
- Français (French)
- J'ai besoin d'aide
- Scripts et Fonctions
- Tutoriels
- Autres Utilitaires et Ressources
- Hors Sujet
- Português (Portuguese)
- Ajuda e Suporte Geral
- Scripts e Funções
- Tutoriais
- Outras Ferramentas e Recursos
- Outros Assuntos
- 한국어 (Korean)
Who is online
Users browsing this forum: No registered users and 35 guests