ever4st on Nostr: #sqlite To add a new field to an existing table in SQLite: ALTER TABLE table_name \ ...
#sqlite
To add a new field to an existing table in SQLite:
ALTER TABLE table_name \
ADD COLUMN column_name data_type;
Published at
2025-02-13 06:46:19Event JSON
{
"id": "06b53cbfc3d223258aa201639115abcc21a1c734d02cb94ef64d076bec2f5e4e",
"pubkey": "dbb19ae0e0ea853289c54c7ca810782b61306c848cad8d8416174597c3f22d5a",
"created_at": 1739429179,
"kind": 1,
"tags": [
[
"client",
"Yakihonne",
"31990:20986fb83e775d96d188ca5c9df10ce6d613e0eb7e5768a0f0b12b37cdac21b3:1700732875747"
],
[
"t",
"sqlite"
]
],
"content": "#sqlite\n\nTo add a new field to an existing table in SQLite: \n\nALTER TABLE table_name \\ \nADD COLUMN column_name data_type;",
"sig": "ec0fa8196d526cb7d9902eb6dc044f5ef85201d4cd42fe20710ec2743ce4711b8a3f3b1396b82dcaa7e663485a40790db2ca47703aa6f8132d98dd270af0e169"
}
