Prepared statement: Revision history

12 January 2024

• curprev 11:3411:34, 12 January 2024‎ Ucup2024 talk contribs‎ m 15,749 bytes −139‎ →‎References: Replace references that lead to 404 pages with references that are relevant to the topic undo Tag: Visual edit

12 December 2023

• curprev 21:4421:44, 12 December 2023‎ 64.215.233.52 talk‎ 15,888 bytes 0‎ SQL string literals should be surrounded by single quotes, not double quotes. undo

24 November 2023

• curprev 12:1112:11, 24 November 2023‎ Frap talk contribs‎ 15,888 bytes −21‎ →‎PureBasic undo

27 September 2023

• curprev 19:4719:47, 27 September 2023‎ Citation bot talk contribs‎ 15,909 bytes −16‎ Removed parameters. | Use this bot. Report bugs. | #UCB_CommandLine undo

20 August 2023

• curprev 02:4302:43, 20 August 2023‎ Elttaruuu talk contribs‎ m 15,925 bytes +39‎ No edit summary undo Tags: Mobile edit Mobile app edit iOS app edit

4 July 2023

• curprev 12:3612:36, 4 July 2023‎ Bearcat talk contribs‎ 15,886 bytes −1‎ No edit summary undo

3 July 2023

• curprev 11:3711:37, 3 July 2023‎ Frap talk contribs‎ 15,887 bytes +213‎ Sharpen category undo

25 June 2023

• curprev 21:1421:14, 25 June 2023‎ DanShearer talk contribs‎ m 15,674 bytes +35‎ Clarify that the database is doing the pre-compilation undo
• curprev 06:0506:05, 25 June 2023‎ Cedar101 talk contribs‎ 15,639 bytes +16‎ →‎PureBasic: fix syntaxhighlight errors undo

11 August 2022

• curprev 16:5416:54, 11 August 2022‎ Hellacioussatyr talk contribs‎ 15,623 bytes +25‎ No edit summary undo Tags: Mobile edit Mobile web edit Advanced mobile edit

7 August 2022

• curprev 23:2323:23, 7 August 2022‎ Dataflow123 talk contribs‎ 15,598 bytes +28‎ No edit summary undo
• curprev 23:2223:22, 7 August 2022‎ Dataflow123 talk contribs‎ 15,570 bytes +35‎ Code injection undo

31 May 2022

• curprev 14:1614:16, 31 May 2022‎ Frap talk contribs‎ m 15,535 bytes +172‎ →‎Java JDBC: standard 4-space Java indention undo

19 April 2022

• curprev 18:2218:22, 19 April 2022‎ Vt320 talk contribs‎ 15,363 bytes −4‎ use correct capitalization of Db2 undo

2 December 2021

• curprev 12:5612:56, 2 December 2021‎ DanShearer talk contribs‎ m 15,367 bytes 0‎ Minor grammatical fix undo Tag: Visual edit

25 October 2021

• curprev 01:0801:08, 25 October 2021‎ 73.167.60.135 talk‎ 15,367 bytes −4‎ Removing trailing "The" undo

22 October 2021

• curprev 02:4402:44, 22 October 2021‎ WikiCleanerBot talk contribs‎ m 15,371 bytes −7‎ v2.04b - Bot T20 CW#61 - Fix errors for CW project (Reference before punctuation - Link equal to linktext) undo Tag: WPCleaner

18 October 2021

• curprev 10:0510:05, 18 October 2021‎ DanShearer talk contribs‎ 15,378 bytes +60‎ Clarify and shorten direct SQL call example undo Tag: Visual edit
• curprev 10:0010:00, 18 October 2021‎ DanShearer talk contribs‎ m 15,318 bytes −27‎ Shorten and clarify dotpoint undo Tag: Visual edit
• curprev 09:5709:57, 18 October 2021‎ DanShearer talk contribs‎ 15,345 bytes +1‎ Correct error: in context of this dot point, it is the DBMS that does the execution not the application. undo Tag: Visual edit
• curprev 09:5209:52, 18 October 2021‎ DanShearer talk contribs‎ m 15,344 bytes −20‎ Change "typical" to "common", and improve grammar undo Tag: Visual edit
• curprev 09:4909:49, 18 October 2021‎ DanShearer talk contribs‎ m 15,364 bytes −12‎ Remove redundant words and combine two sentences for clarity. undo Tag: Visual edit
• curprev 09:3609:36, 18 October 2021‎ DanShearer talk contribs‎ m 15,376 bytes −7‎ Remove non-grammatical word undo Tag: Visual edit
• curprev 09:3509:35, 18 October 2021‎ DanShearer talk contribs‎ 15,383 bytes +174‎ Add SQLite as RDBMS that supports prepared statements, with link to manual page undo Tag: Visual edit
• curprev 09:3009:30, 18 October 2021‎ DanShearer talk contribs‎ 15,209 bytes +25‎ Add "separation of code from data" into the first sentence. This is the entire nature of prepared statements, from which all features, benefits and problems arise. undo Tag: Visual edit
• curprev 09:2709:27, 18 October 2021‎ DanShearer talk contribs‎ 15,184 bytes −410‎ Remove confusing bullet points about advantages, and replace with more compact bullet points in introductory paragraph undo Tag: Visual edit
• curprev 09:2009:20, 18 October 2021‎ DanShearer talk contribs‎ m 15,594 bytes −4‎ remove redundant SQL wp link, combine text with DML link undo Tag: Visual edit
• curprev 09:1809:18, 18 October 2021‎ DanShearer talk contribs‎ 15,598 bytes +111‎ Present the purpose and benefits of a prepared statement more clearly, in a single introductory sentence. undo Tag: Visual edit
• curprev 09:0909:09, 18 October 2021‎ DanShearer talk contribs‎ 15,487 bytes −9‎ Move sentence listed under "advantages" that describes a caveat, not an advantage. undo Tag: Visual edit
• curprev 09:0609:06, 18 October 2021‎ DanShearer talk contribs‎ 15,496 bytes +157‎ Clarify difference between prepared statements and unprepared statements, using the existing example undo
• curprev 08:5308:53, 18 October 2021‎ DanShearer talk contribs‎ m 15,339 bytes +15‎ Add missing list heading undo Tag: Visual edit
• curprev 08:5308:53, 18 October 2021‎ DanShearer talk contribs‎ m 15,324 bytes −33‎ Remove redundant words undo Tag: Visual edit
• curprev 08:1008:10, 18 October 2021‎ DanShearer talk contribs‎ 15,357 bytes +13‎ Add "and security" to introductory sentence, since this is a major use case for prepared statements. undo Tag: Visual edit
• curprev 08:1008:10, 18 October 2021‎ DanShearer talk contribs‎ 15,344 bytes −20‎ Remove "the same or similar" in initial description, because it assumes the main use case is efficiency for repeated calls. This is only one use case of prepared statements. undo Tag: Visual edit
• curprev 08:0708:07, 18 October 2021‎ DanShearer talk contribs‎ 15,364 bytes +58‎ List precise statements, instead of assuming knowledge about what "queries or updates" might mean in SQL, undo Tag: Visual edit
• curprev 08:0408:04, 18 October 2021‎ DanShearer talk contribs‎ 15,306 bytes +35‎ Explain that this is mostly SQL databases, and in this common case, that SQL DML statements are where they are used. undo Tag: Visual edit
• curprev 08:0108:01, 18 October 2021‎ DanShearer talk contribs‎ m 15,271 bytes 0‎ Change order to address what a statement *is* before how it is *used* undo Tag: Visual edit
• curprev 07:5907:59, 18 October 2021‎ DanShearer talk contribs‎ m 15,271 bytes +13‎ Make immediately clear that prepared statements are precompiled, since that is their entire purpose undo Tag: Visual edit

7 September 2021

• curprev 16:2816:28, 7 September 2021‎ Dionysusnu talk contribs‎ 15,258 bytes −95‎ →‎Python DB-API: Use more idiomatic python example using with statement to handle closing undo

26 June 2021

• curprev 09:2509:25, 26 June 2021‎ SdkbBot talk contribs‎ m 15,353 bytes −1‎ →‎Software support: General fixes, removed erroneous space undo Tag: AWB

9 June 2021

• curprev 19:4419:44, 9 June 2021‎ Jarble talk contribs‎ 15,354 bytes +40‎ added Category:Articles with example code using HotCat undo

21 May 2020

• curprev 21:1521:15, 21 May 2020‎ DannyS712 bot talk contribs‎ m 15,314 bytes +36‎ Task 70: Update syntaxhighlight tags - remove use of deprecated <source> tags undo Tag: AWB

19 May 2020

• curprev 06:3906:39, 19 May 2020‎ Cedar101 talk contribs‎ m 15,278 bytes +53‎ →‎PureBasic: <source lang="vb"> undo

15 May 2020

• curprev 13:2113:21, 15 May 2020‎ 1.129.106.73 talk‎ 15,225 bytes 0‎ "shoes" for the first parameter and "7400" (matching Java code example) undo
• curprev 13:1813:18, 15 May 2020‎ 1.129.106.73 talk‎ 15,225 bytes +101‎ , and then later supply "chair" for the first parameter and "4550" for the second parameter. undo

11 May 2020

• curprev 18:2118:21, 11 May 2020‎ DannyS712 bot talk contribs‎ m 15,124 bytes +108‎ Task 70: Update syntaxhighlight tags - remove use of deprecated <source> tags undo Tag: AWB

10 May 2020

• curprev 18:1618:16, 10 May 2020‎ InternetArchiveBot talk contribs‎ 15,016 bytes +72‎ Rescuing 0 sources and tagging 1 as dead.) #IABot (v2.0 undo

22 April 2020

• curprev 22:3322:33, 22 April 2020‎ Vanisaac talk contribs‎ m 14,944 bytes +1‎ Correcting spelling: occured->occurred undo
• curprev 22:0722:07, 22 April 2020‎ Enzo Innocenzi talk contribs‎ m 14,943 bytes +779‎ Cleaned up and commented the PHP example. It now follow better practices. undo

3 February 2020

• curprev 09:0409:04, 3 February 2020‎ Bradlegar talk contribs‎ 14,164 bytes +618‎ →‎Perl DBI: Updated Perl example to match Java undo