MySQL Connector/Python Developer Guide

1 MySQL Connector/Python Developer Guide Abstract This manual describes how to install and configure MySQL Connector/Python , a self-contained python driver for communicating with MySQL servers, and how to use it to develop database applications. MySQL Connector/Python is highly recommended for use with MySQL Server , , and Please upgrade to MySQL Connector/Python For notes detailing the changes in each release of Connector/Python , see MySQL Connector/Python Release Notes. For legal information, see the Legal Notices. For help with using MySQL , please visit the MySQL Forums, where you can discuss your issues with other MySQL users. Licensing information.

2 This product may include third-party software, used under license. MySQL Connector/. python Community License Information User Manual has information about licenses relating to MySQL . Connector/Python community releases up to and including version MySQL Connector/Python Commercial License Information User Manual has information about licenses relating to MySQL Connector/Python commercial releases up to and including version MySQL Connector/Python Community License Information User Manual has information about licenses relating to MySQL Connector/Python community releases in the release series. MySQL Connector/Python Commercial License Information User Manual has information about licenses relating to MySQL Connector/Python commercial releases in the release series.

3 Document generated on: 2022-03-18 (revision: 72339). Table of Contents Preface and Legal Notices .. vii 1 Introduction to MySQL Connector/Python .. 1. 2 Guidelines for python Developers .. 3. 3 Connector/Python Versions .. 5. 4 Connector/Python Installation .. 7. Obtaining Connector/Python .. 8. Installing Connector/Python from a Binary Distribution .. 8. Installing Connector/Python from a Source Distribution .. 10. Verifying Your Connector/Python Installation .. 11. 5 Connector/Python Coding Examples .. 13. Connecting to MySQL Using Connector/Python .. 13. Creating Tables Using Connector/Python .. 14. Inserting Data Using Connector/Python .

4 17. Querying Data Using Connector/Python .. 18. 6 Connector/Python Tutorials .. 21. Tutorial: Raise Employee's Salary Using a Buffered Cursor .. 21. 7 Connector/Python Connection Establishment .. 23. Connector/Python Connection Arguments .. 23. Connector/Python Option-File Support .. 29. 8 The Connector/Python C Extension .. 31. Application Development with the Connector/Python C Extension .. 31. The _mysql_connector C Extension Module .. 32. 9 Connector/Python Other Topics .. 33. Connector/Python Connection Pooling .. 33. Connector/Python Django Back End .. 35. 10 Connector/Python API Reference .. 37. Module .. 39. () Method.

5 39. Property .. 39. Property .. 39. Property .. 40. Property .. 40. Property .. 40. Class .. 40. () Constructor .. 40. () Method .. 40. () Method .. 41. () Method .. 41. () Method .. 41. () Method .. 41. () Method .. 42. () Method .. 43. () Method .. 43. () Method .. 43. () Method .. 43. () Method .. 43. () Method .. 43. () Method .. 44. () Method .. 44. () Method .. 44. () Method .. 45. () Method .. 45. () Method .. 45. () Method .. 45. () Method .. 45. iii MySQL Connector/Python Developer Guide () Method .. 45. () Method .. 46. () Method .. 46. () Method .. 46. () Method .. 46. () Method .. 46. () Method .. 46. () Method .. 47.

6 () Method .. 47. () Method .. 47. () Method .. 48. () Method .. 48. () Method .. 48. Property .. 49. Property .. 49. Property .. 49. Property .. 49. Property .. 49. Property .. 49. Property .. 50. Property .. 50. Property .. 50. Property .. 50. Property .. 51. Property .. 51. Property .. 51. Property .. 51. Property .. 52. Property .. 52. Class .. 52. Constructor .. 52. () Method .. 52. () Method .. 53. () Method .. 53. Property .. 53. Class .. 54. Constructor .. 54. () Method .. 54. () Method .. 54. Property .. 54. Class .. 55. Constructor .. 55. () Method .. 56. () Method .. 56. () Method .. 57. () Method .. 57. () Method .. 58.

7 () Method .. 58. () Method .. 59. () Method .. 59. () Method .. 59. Property .. 60. Property .. 60. Property .. 61. Property .. 61. Property .. 61. Property .. 62. Subclasses .. 62. iv MySQL Connector/Python Developer Guide Class .. 62. Class .. 63. Class .. 63. Class .. 63. Class .. 64. Class .. 64. Class .. 64. Class .. 65. Class .. 66. Class .. 66. Class .. 67. Class .. 67. Class .. 67. Errors and Exceptions .. 67. errorcode Module .. 68. Exception .. 69. Exception .. 70. Exception .. 70. Exception .. 70. Exception .. 70. Exception .. 71. Exception .. 71. Exception .. 71. Exception .. 71. Exception .. 71. Exception .. 71. () Function.

8 71. 11 Connector/Python C Extension API Reference .. 73. _mysql_connector Module .. 74. () Class .. 74. () Method .. 74. () Method .. 74. () Method .. 75. () Method .. 75. () Method .. 75. () Method .. 75. () Method .. 75. () Method .. 75. () Method .. 76. () Method .. 76. () Method .. 76. () Method .. 76. () Method .. 77. () Method .. 77. () Method .. 77. () Method .. 77. () Method .. 77. () Method .. 77. () Method .. 78. () Method .. 78. () Method .. 78. () Method .. 78. () Method .. 78. () Method .. 78. () Method .. 78. () Method .. 79. () Method .. 79. () Method .. 79. v MySQL Connector/Python Developer Guide () Method .. 79.

9 () Method .. 79. () Method .. 79. () Method .. 79. () Method .. 80. () Method .. 80. () Method .. 80. () Method .. 80. () Method .. 81. () Method .. 81. () Method .. 81. () Method .. 81. () Method .. 81. () Method .. 81. Property .. 82. Index .. 83. vi Preface and Legal Notices This manual describes how to install, configure, and develop database applications using MySQL . Connector/Python , the python driver for communicating with MySQL servers. Legal Notices Copyright 2012, 2022, Oracle and/or its affiliates. This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws.

10 Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate , broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited. The information contained herein is subject to change without notice and is not warranted to be error- free. If you find any errors, please report them to us in writing. If this is software or related documentation that is delivered to the Government or anyone licensing it on behalf of the Government, then the following notice is applicable: GOVERNMENT END USERS.