[{"template":"default","lang":"zh-CN","langs":["en","ja","zh-CN","zh-TW"],"summary":{"raw":"如果你认为本站对你有帮助，欢迎通过以下方式来支持本站。谢谢！","html":"

如果你认为本站对你有帮助，欢迎通过以下方式来支持本站。谢谢！

\n"},"visible":true,"routable":true,"title":"捐赠","comment":{"enabled":false},"discuss":{"enabled":false},"menu":{"footer":true,"header":false},"keywords":[],"webmention":{"enabled":true,"accept":true,"callback":{"secret":{"hash":{"sha256":"44bb9da44b424c6dfc9233819e907029ff2ccdfaa89919d3696ddf8db7ff6647"}}}},"pingback":{"enabled":true,"accept":true},"slug":"donate","taxonomy":{"category":[],"tag":[],"series":[]},"route":"/donate/","toc":{"enabled":false},"published":{"date":"2013-01-07 01:40"},"modified":{"date":"2024-04-18T10:03:42.278Z"},"data":{},"author":[{"email":{"value":{"encrypted":"ODgyZjdiZDg4OTVmMjllOGZkNmFmYg==","algorithm":"aes-256-gcm","iv":"067f6d66f2ba5dd50c8443be"},"hash":{"md5":"8770854a9222b6bf1ee195220793bcf1"}},"url":"https://dallas.lu","name":"达拉斯・卢","lang":"zh-CN","user":"dallaslu"}],"contributor":[],"sponsor":[],"image":[],"audio":[],"video":[],"photo":[],"content":{"html":"

如果你认为本站对你有帮助，欢迎通过以下方式来支持本站。谢谢！

PayPal

https://paypal.me/dallaslu

Lightning

https://getalby.com/p/dallaslu

\n","headings":[{"level":2,"text":"PayPal","id":"paypal"},{"level":2,"text":"Lightning","id":"lightning"}],"links":[{"href":"https://paypal.me/dallaslu","type":"mention"},{"href":"https://getalby.com/p/dallaslu","type":"mention"}]}},{"template":"default","lang":"zh-CN","langs":["en","ja","zh-CN","zh-TW"],"summary":{"raw":"通过 RSS/Atom 订阅，你可以随时关注这里的更新状况，不访问也不会错过任何内容。","html":"

通过 RSS/Atom 订阅，你可以随时关注这里的更新状况，不访问也不会错过任何内容。

\n"},"visible":true,"routable":true,"title":"订阅","comment":{"enabled":false},"discuss":{"enabled":false},"menu":{"footer":true,"header":false},"keywords":[],"webmention":{"enabled":true,"accept":true,"callback":{"secret":{"hash":{"sha256":"44bb9da44b424c6dfc9233819e907029ff2ccdfaa89919d3696ddf8db7ff6647"}}}},"pingback":{"enabled":true,"accept":true},"slug":"subscribe","taxonomy":{"category":[],"tag":[],"series":[]},"route":"/subscribe/","toc":{"enabled":false},"published":{"date":"2009-03-21 17:13"},"modified":{"date":"2024-04-18T10:03:42.278Z"},"data":{},"author":[{"email":{"value":{"encrypted":"ODgyZjdiZDg4OTVmMjllOGZkNmFmYg==","algorithm":"aes-256-gcm","iv":"067f6d66f2ba5dd50c8443be"},"hash":{"md5":"8770854a9222b6bf1ee195220793bcf1"}},"url":"https://dallas.lu","name":"达拉斯・卢","lang":"zh-CN","user":"dallaslu"}],"contributor":[],"sponsor":[],"image":[],"audio":[],"video":[],"photo":[],"content":{"html":"

通过 RSS/Atom 订阅，你可以随时关注这里的更新状况，不访问也不会错过任何内容。

所有文章

订阅地址：

https://dallas.lu/feed

更多方式

𝕏 @dallaslu

\n","headings":[{"level":2,"text":"所有文章","id":"所有文章"},{"level":2,"text":"更多方式","id":"更多方式"}],"links":[{"href":"https://dallas.lu/feed","type":"mention"},{"href":"https://x.com/dallasLu","type":"mention"}]}},{"template":"default","lang":"zh-CN","langs":["en","ja","zh-CN","zh-TW"],"summary":{"raw":"嗨，你好！本站话题涉及软件开发、互联网、软件使用经验。了解更多关于本站和作者的信息","html":"

嗨，你好！本站话题涉及软件开发、互联网、软件使用经验。了解更多关于本站和作者的信息

\n"},"visible":true,"routable":true,"title":"欢迎访问","comment":{"enabled":false},"discuss":{"enabled":false},"menu":"首页","keywords":[],"webmention":{"enabled":true,"accept":true,"callback":{"secret":{"hash":{"sha256":"44bb9da44b424c6dfc9233819e907029ff2ccdfaa89919d3696ddf8db7ff6647"}}}},"pingback":{"enabled":true,"accept":true},"slug":"(article)","taxonomy":{"category":[],"tag":[],"series":[]},"route":"/","toc":{"enabled":false},"published":{"date":"2009-03-06 09:46"},"modified":{"date":"2024-04-18T10:03:42.278Z"},"data":{"routes":{"canonical":"/articles"}},"author":[{"email":{"value":{"encrypted":"ODgyZjdiZDg4OTVmMjllOGZkNmFmYg==","algorithm":"aes-256-gcm","iv":"067f6d66f2ba5dd50c8443be"},"hash":{"md5":"8770854a9222b6bf1ee195220793bcf1"}},"url":"https://dallas.lu","name":"达拉斯・卢","lang":"zh-CN","user":"dallaslu"}],"contributor":[],"sponsor":[],"image":[],"audio":[],"video":[],"photo":[],"content":{"html":"

嗨，你好！本站话题涉及软件开发、互联网、软件使用经验。了解更多关于本站和作者的信息

查看文章

Mastodon

\n","headings":[],"links":[{"href":"https://dallas.lu/about/","type":"mention"},{"href":"https://dallas.lu/archives/","type":"mention"},{"href":"https://m.dallas.lu/@i","type":"mention","content":""}]}},{"template":"default","lang":"zh-CN","langs":["en","ja","zh-CN","zh-TW"],"summary":{"raw":"欢迎留言。","html":"

欢迎留言。

\n"},"visible":true,"routable":true,"title":"留言","comment":{"enabled":true,"reply":true,"reverse":false},"discuss":{"enabled":false},"menu":{"header":true,"footer":false},"keywords":[],"webmention":{"enabled":true,"accept":true,"callback":{"secret":{"hash":{"sha256":"44bb9da44b424c6dfc9233819e907029ff2ccdfaa89919d3696ddf8db7ff6647"}}}},"pingback":{"enabled":true,"accept":true},"slug":"guestbook","taxonomy":{"category":[],"tag":[],"series":[]},"route":"/guestbook/","toc":{"enabled":false},"published":{"date":"2008-06-24 23:39"},"modified":{"date":"2024-08-22T06:05:34.041Z"},"data":{},"author":[{"email":{"value":{"encrypted":"ODgyZjdiZDg4OTVmMjllOGZkNmFmYg==","algorithm":"aes-256-gcm","iv":"067f6d66f2ba5dd50c8443be"},"hash":{"md5":"8770854a9222b6bf1ee195220793bcf1"}},"url":"https://dallas.lu","name":"达拉斯・卢","lang":"zh-CN","user":"dallaslu"}],"contributor":[],"sponsor":[],"image":[],"audio":[],"video":[],"photo":[],"content":{"html":"

欢迎留言。

\n","headings":[],"links":[]}},{"template":"default","lang":"zh-CN","langs":["en","ja","zh-CN","zh-TW"],"summary":{"raw":"以伟大的 GFW 为界，与一切纸老虎泾渭分明。","html":"

\n
以伟大的 GFW 为界，与一切纸老虎泾渭分明。
\n

\n"},"visible":true,"routable":true,"title":"关于","comment":{"enabled":false},"discuss":{"enabled":false},"menu":{"header":true,"footer":false},"keywords":[],"webmention":{"enabled":true,"accept":true,"callback":{"secret":{"hash":{"sha256":"44bb9da44b424c6dfc9233819e907029ff2ccdfaa89919d3696ddf8db7ff6647"}}}},"pingback":{"enabled":true,"accept":true},"slug":"about","taxonomy":{"category":[],"tag":[],"series":[]},"route":"/about/","toc":{"enabled":false},"published":{"date":"2008-06-18 12:04"},"modified":{"date":"2024-08-29T08:34:12.230Z"},"data":{"process":{"markdown":true,"twig":true}},"author":[{"email":{"value":{"encrypted":"ODgyZjdiZDg4OTVmMjllOGZkNmFmYg==","algorithm":"aes-256-gcm","iv":"067f6d66f2ba5dd50c8443be"},"hash":{"md5":"8770854a9222b6bf1ee195220793bcf1"}},"url":"https://dallas.lu","name":"达拉斯・卢","lang":"zh-CN","user":"dallaslu"}],"contributor":[],"sponsor":[],"image":[],"audio":[],"video":[],"photo":[],"content":{"html":"

\n
以伟大的 GFW 为界，与一切纸老虎泾渭分明。
\n

站点

幻想牢骚，奇技淫巧，侧重软件开发、互联网、软件使用经验。开始于2008年1月1日，旨在记录个人经验，分享和谐盛世。

作者

Dallas 是美国地名，因谐音选作英文名。1989年那场政治风波前夜出生，托当代教育制度的福，主修软件工程专业，现在是一名IT从业人员。

联系

S/MIME

此证书由亚洲诚信赞助。

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Serial Number	`0C:24:34:23:D1:78:D6:04:F1:B6:BF:96:AF:A9:73:7D`
SHA256 Fingerprint	`4C:42:78:71:B6:1E:69:08:04:E2:62:9E:12:11:8E:1F:10:48:46:D4:EA:A1:79:1D:5F:2E:1B:CE:27:38:95:7D`
SHA1 Fingerprint	`F1:86:54:35:47:70:68:BA:45:3F:A9:1E:E6:F7:9F:F1:09:C9:75:80`
过期时间	2026年09月20日

主机搬迁历史

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

时间	主机
2009年	胡戈戈同学的 Site5 博客主机
2010年	盘古VPS
2011年	VPSYOU
2011年	欧诺VPS
2012年	KVM.LA
2012年	Linode VPS
2020年	Google Cloud
2021年	Linode VPS
2023年	CloudCone HS6
2023年	Dedicated Server

程序

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

时间
2008	WordPress
2021	Grav
2023	Press

\n","headings":[{"level":2,"text":"站点","id":"站点"},{"level":2,"text":"作者","id":"作者"},{"level":2,"text":"联系","id":"联系"},{"level":3,"text":"Email / Hangouts / iMessage / Jabble(XMPP) / Delta Chat / Mastodon / Nostr","id":"email--hangouts--imessage--jabblexmpp--delta-chat--mastodon--nostr"},{"level":3,"text":"Telegram","id":"telegram"},{"level":3,"text":"Martix","id":"martix"},{"level":3,"text":"PGP","id":"pgp"},{"level":3,"text":"S/MIME","id":"smime"},{"level":2,"text":"主机搬迁历史","id":"主机搬迁历史"},{"level":2,"text":"程序","id":"程序"}],"links":[{"href":"https://t.me/dallaslu","type":"mention"},{"href":"https://matrix.to/#/@i:dallas.lu","type":"mention"},{"href":"https://dallas.lu/3FD3143FDA11A510.pub.asc","type":"mention"},{"href":"https://www.trustasia.com/","type":"mention"},{"href":"https://dallas.lu/0x09C97580_public.pem","type":"mention"},{"href":"http://www.gegehost.com/","type":"mention"},{"href":"https://www.linode.com/?r=ae55e4ac259593b7f0698627838194ba4451a878","type":"mention"},{"href":"https://www.linode.com/?r=ae55e4ac259593b7f0698627838194ba4451a878","type":"mention"},{"href":"https://app.cloudcone.com/?ref=9410","type":"mention"}]}},{"template":"default","lang":"zh-CN","langs":["en","zh-CN"],"summary":{"raw":"欢迎访问本网站。如果您继续浏览和使用，您同意遵守并受以下使用条款的约束，这些条款连同我们的隐私政策一起管理 dallas.lu 与您的关系。如果您不同意这些条款的任何部分，请不要使用本网站。","html":"

欢迎访问本网站。如果您继续浏览和使用，您同意遵守并受以下使用条款的约束，这些条款连同我们的隐私政策一起管理 dallas.lu 与您的关系。如果您不同意这些条款的任何部分，请不要使用本网站。

\n"},"visible":true,"routable":true,"title":"使用条款","comment":{"enabled":false},"discuss":{"enabled":false},"menu":{"label":"条款","footer":true,"header":false},"keywords":[],"webmention":{"enabled":true,"accept":true,"callback":{"secret":{"hash":{"sha256":"44bb9da44b424c6dfc9233819e907029ff2ccdfaa89919d3696ddf8db7ff6647"}}}},"pingback":{"enabled":true,"accept":true},"slug":"terms","taxonomy":{"category":[],"tag":[],"series":[]},"route":"/terms/","toc":{"enabled":false},"published":{"date":"2024-04-18T10:03:42.282Z"},"modified":{"date":"2024-04-18T10:03:42.282Z"},"data":{},"author":[{"email":{"value":{"encrypted":"ODgyZjdiZDg4OTVmMjllOGZkNmFmYg==","algorithm":"aes-256-gcm","iv":"067f6d66f2ba5dd50c8443be"},"hash":{"md5":"8770854a9222b6bf1ee195220793bcf1"}},"url":"https://dallas.lu","name":"达拉斯・卢","lang":"zh-CN","user":"dallaslu"}],"contributor":[],"sponsor":[],"image":[],"audio":[],"video":[],"photo":[],"content":{"html":"

1. 术语定义

“本网站”指 dallas.lu。
“用户”、“您”指访问此网站的人员。
“内容”包括文本、图像、声音、视频，以及用户可能在网站上浏览的其他材料。

2. 使用条款

本网站上提供的内容仅用于您的一般信息和非商业用途，可随时更改而不另行通知。
本网站使用 Cookies 来处理浏览偏好。如果您允许使用 Cookies，则个人信息可能会被存储或使用。
本网站或第三方不提供任何保证或担保，明示或暗示，关于内容的准确性、时效性、性能、完整性或适用性于特定目的。您承认这样的信息和材料可能包含不准确或错误，我们明确排除因此引起的责任，在法律允许的最大范围内。
您使用本网站上的任何信息或材料完全由您自己承担风险，我们不承担责任。确保通过本网站提供的产品、服务或信息符合您的具体要求。
本网站的包括但不限于设计、布局、外观和图形，均为我们或授权给我们的所有。复制是被禁止的。
未经授权使用此网站可能会引起索赔并构成犯罪。
本网站偶尔也会包含指向其他网站的链接。这些链接提供给您以方便查看更多信息。它们并不意味着我们认可网站。我们对链接网站的内容不负责任。

3. 版权声明

4. 适用法律

您对本网站的使用以及因使用本网站而产生的任何争议均受您所在国家/地区法律的约束。

联系方式

如有关于这些条款的任何疑问，请通过 legal@dallas.lu 与我们联系。

\n","headings":[{"level":2,"text":"1. 术语定义","id":"1-术语定义"},{"level":2,"text":"2. 使用条款","id":"2-使用条款"},{"level":2,"text":"3. 版权声明","id":"3-版权声明"},{"level":2,"text":"4. 适用法律","id":"4-适用法律"},{"level":2,"text":"联系方式","id":"联系方式"}],"links":[]}},{"template":"default","lang":"zh-CN","langs":["en","zh-CN"],"summary":{"raw":"欢迎访问 dallas.lu（以下简称“我们”、“我们的网站”）。我们承诺保护您的隐私和数据。本隐私政策阐明了当您使用我们的网站时，我们如何收集、使用和保护您的个人信息。","html":"

欢迎访问 dallas.lu（以下简称“我们”、“我们的网站”）。我们承诺保护您的隐私和数据。本隐私政策阐明了当您使用我们的网站时，我们如何收集、使用和保护您的个人信息。

\n"},"visible":true,"routable":true,"title":"隐私政策","comment":{"enabled":false},"discuss":{"enabled":false},"menu":{"label":"隐私","footer":true,"header":false},"keywords":[],"webmention":{"enabled":true,"accept":true,"callback":{"secret":{"hash":{"sha256":"44bb9da44b424c6dfc9233819e907029ff2ccdfaa89919d3696ddf8db7ff6647"}}}},"pingback":{"enabled":true,"accept":true},"slug":"privacy","taxonomy":{"category":[],"tag":[],"series":[]},"route":"/privacy/","toc":{"enabled":false},"published":{"date":"2024-04-18T10:03:42.278Z"},"modified":{"date":"2024-04-18T10:03:42.278Z"},"data":{},"author":[{"email":{"value":{"encrypted":"ODgyZjdiZDg4OTVmMjllOGZkNmFmYg==","algorithm":"aes-256-gcm","iv":"067f6d66f2ba5dd50c8443be"},"hash":{"md5":"8770854a9222b6bf1ee195220793bcf1"}},"url":"https://dallas.lu","name":"达拉斯・卢","lang":"zh-CN","user":"dallaslu"}],"contributor":[],"sponsor":[],"image":[],"audio":[],"video":[],"photo":[],"content":{"html":"

1. 我们收集的信息

1.1 自动收集的信息

当您访问我们的网站时，我们可能自动收集某些信息，包括但不限于您的IP地址、语言偏好、访问日期和时间、浏览的页面以及您访问时使用的设备类型。我们通过使用 Cookies和类似技术来进行这种自动数据收集。

1.2 主动提供的信息

如果您在我们的网站上进行注册、发表评论或与我们联系，我们可能会要求您提供个人信息，如姓名、电子邮件地址等。

2. 如何使用您的信息

我们使用收集到的信息来：

提供、维护和改进我们的网站；
分析网站的使用方式，以优化用户体验；
通过电子邮件与您沟通，包括发送内容更新或营销信息，前提是您同意接收此类信息。

3. 信息共享和披露

我们不会将您的个人信息出售、租赁或以其他方式提供给第三方，除非：

获得您的明确同意；
为了遵守法律义务、执行我们的政策、保护我们或他人的权利、财产或安全；
与提供网站运营所需服务的第三方服务提供商共享，如网站托管、分析服务和广告服务，这些服务提供商仅在为我们提供服务时访问您的信息，并受严格的保密协议约束。

4. 数据安全

我们采取合理的措施保护您的个人信息免受丢失、滥用、未经授权的访问、披露、更改和破坏。

5. 第三方链接

本网站可能包含指向第三方网站的链接。请注意，我们对这些外部网站的隐私政策不负责。

6. 儿童隐私

我们的网站不针对13岁以下的儿童。如果我们得知收集了13岁以下儿童的个人信息，我们将采取措施删除这些信息。

7. 更新我们的隐私政策

我们可能会不时更新本隐私政策。我们鼓励您定期查看此页面了解我们的隐私实践。本隐私政策最近一次更新日期为 2024年3月27日。

联系我们

如果您对本隐私政策有任何疑问，请通过 legal@dallas.lu 与我们联系。

\n","headings":[{"level":2,"text":"1. 我们收集的信息","id":"1-我们收集的信息"},{"level":3,"text":"1.1 自动收集的信息","id":"11-自动收集的信息"},{"level":3,"text":"1.2 主动提供的信息","id":"12-主动提供的信息"},{"level":2,"text":"2. 如何使用您的信息","id":"2-如何使用您的信息"},{"level":2,"text":"3. 信息共享和披露","id":"3-信息共享和披露"},{"level":2,"text":"4. 数据安全","id":"4-数据安全"},{"level":2,"text":"5. 第三方链接","id":"5-第三方链接"},{"level":2,"text":"6. 儿童隐私","id":"6-儿童隐私"},{"level":2,"text":"7. 更新我们的隐私政策","id":"7-更新我们的隐私政策"},{"level":2,"text":"联系我们","id":"联系我们"}],"links":[]}},{"template":"links","lang":"zh-CN","langs":["en","zh-CN"],"summary":{"raw":"","html":"\n"},"visible":true,"routable":true,"title":"链接","comment":{"enabled":false,"reply":true},"discuss":{"enabled":false},"menu":{"footer":true},"keywords":[],"webmention":{"enabled":true,"accept":true,"callback":{"secret":{"hash":{"sha256":"44bb9da44b424c6dfc9233819e907029ff2ccdfaa89919d3696ddf8db7ff6647"}}}},"pingback":{"enabled":true,"accept":true},"slug":"links","taxonomy":{"category":[],"tag":[],"series":[]},"route":"/links/","toc":{"enabled":false},"published":{"date":"2024-06-28T06:29:10.990Z"},"modified":{"date":"2024-06-28T06:29:10.994Z"},"data":{"data":{"authors":[{"id":"taoshu","name":"涛叔","mail":null,"avatar":null}],"group":[{"id":"friends"},{"id":"guru"}],"links":[{"name":"涛叔","author":"taoshu","url":"https://taoshu.in","feed":"https://taoshu.in/feed/","corver":"","thumb":"","icon":""},{"name":"挨踢路","url":"https://itlu.net"},{"name":"KAIX.IN","url":"https://kaix.in"},{"name":"土木坛子","url":"https://tumutanzi.com"},{"name":"拾月","url":"https://www.skyue.com"},{"name":"Jiajun的技术笔记","url":"https://jiajunhuang.com"},{"name":"频率","url":"https://pinlyu.com/"},{"name":"人间历险计","url":"https://www.meettea.com"},{"name":"Leeiio Chaos Made","url":"https://leeiio.me/","description":"The world is golden. 關注前端，後台，電影，音樂，攝影，設計。我是個興趣廣泛滴人。"},{"name":"非理勿试（Never Try It Yourself）","url":"https://www.ntiy.com"}]}},"author":[{"email":{"value":{"encrypted":"ODgyZjdiZDg4OTVmMjllOGZkNmFmYg==","algorithm":"aes-256-gcm","iv":"067f6d66f2ba5dd50c8443be"},"hash":{"md5":"8770854a9222b6bf1ee195220793bcf1"}},"url":"https://dallas.lu","name":"达拉斯・卢","lang":"zh-CN","user":"dallaslu"}],"contributor":[],"sponsor":[],"image":[],"audio":[],"video":[],"photo":[],"content":{"html":"","headings":[],"meta":{},"links":[]}},{"template":"default","lang":"zh-CN","langs":["en","zh-CN"],"summary":{"raw":"达拉斯・卢","html":"

达拉斯・卢

\n"},"visible":true,"routable":true,"comment":{"enabled":false},"discuss":{"enabled":false},"menu":{"header":false,"footer":false},"keywords":[],"webmention":{"enabled":true,"accept":true,"callback":{"secret":{"hash":{"sha256":"44bb9da44b424c6dfc9233819e907029ff2ccdfaa89919d3696ddf8db7ff6647"}}}},"pingback":{"enabled":true,"accept":true},"slug":"/","taxonomy":{"category":[],"tag":[],"series":[]},"route":"/","toc":{"enabled":false},"published":{"date":"2024-07-17T09:55:32.358Z"},"modified":{"date":"2024-07-17T09:55:32.358Z"},"data":{"style":"","script":""},"author":[{"email":{"value":{"encrypted":"ODgyZjdiZDg4OTVmMjllOGZkNmFmYg==","algorithm":"aes-256-gcm","iv":"067f6d66f2ba5dd50c8443be"},"hash":{"md5":"8770854a9222b6bf1ee195220793bcf1"}},"url":"https://dallas.lu","name":"达拉斯・卢","lang":"zh-CN","user":"dallaslu"}],"contributor":[],"sponsor":[],"image":[],"audio":[],"video":[],"photo":[],"content":{"html":"

达拉斯・卢

Dallas 是美国地名，因谐音选作英文名。侧重软件开发、互联网、软件使用经验。开始于2008年1月1日，旨在记录个人经验，分享和谐盛世。

\n","headings":[],"links":[]}}]

标签: SQL

SQL 批量删除表

2008