عنوان

MySQL Connector/Python revealed :

شابک

1484236947

شابک

9781484236949

شابک اشتباه

1484236939

شابک اشتباه

9781484236932

عنوان اصلي

MySQL Connector/Python revealed :

نام عام مواد

[Book]

ساير اطلاعات عنواني

SQL and NoSQL data storage using MySQL for Python programmers /

نام نخستين پديدآور

Jesper Wisborg Krogh.

محل نشرو پخش و غیره

[United States] :

محل نشرو پخش و غیره

New York, NY :

نام ناشر، پخش کننده و غيره

Apress,

نام ناشر، پخش کننده و غيره

Distributed to the Book trade worldwide by Springer

تاریخ نشرو بخش و غیره

2018.

تاریخ نشرو بخش و غیره

©2018

نام خاص و کميت اثر

1 online resource

متن يادداشت

Includes index.

متن يادداشت

Intro; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Part I: Getting Ready; Chapter 1: Introduction and Installation; Introduction; Versions; Community and Enterprise Editions; APIs; Downloading; Installation; pip -- All Platforms; Microsoft Windows -- MySQL Installer; Linux -- MySQL Yum Repository; Verifying the Installation; MySQL Server; Installation; Configuration; Creating the Application User; Installing the world Sample Database; Code Examples; Summary; Part II: The Legacy APIs; Chapter 2: Connecting to MySQL.

متن يادداشت

Creating the Connection from PythonSyntax; Common Connection Options; Connection Examples; Reconfiguration and Reconnect; Connection Best Practices; Configuration Files; Alternatives to Hardcoding the Configuration; Using MySQL Configuration Files; General Configuration; Connection; Character Set; Query Behavior; Warnings; Summary; Chapter 3: Basic Query Execution; Simple Execution; Executing the Query: cmd_query(); Retrieving Rows -- get_rows(); Automatic Conversion into Native Python Types; Retrieving Rows -- get_rows() With Limit; Retrieving Rows -- get_row(); Consuming Results; Cursors.

متن يادداشت

InstantiationMySQLCursor -- Execution Flow; MySQLCursor -- Query Execution; MySQLCursor -- Properties; column_names; description; lastrowid; rowcount; statement; with_rows; The Dictionary and Named Tuple Cursor Subclasses; Handling User Input; Validating the Input; Query Parameterization; Prepared Statements; Summary; Chapter 4: Advanced Query Execution; Multi-Query Execution; Multiple Queries with Support for Results; Connection -- cmd_query_iter(); Cursor -- execute(); Multiple Queries Based on a Template; Extended Inserts; Buffered Results; Stored Procedures; Loading Data Using a CSV File.

متن يادداشت

Loading a Server-Side FileLoading an Application-Side File; Load Data Example; Connection Properties; Transactions; Default Database; Time Zones; Other Connection Utility Methods; Connection Methods; cmd_change_user(); cmd_reset_connection() and reset_session(); is_connected(); ping(); Server Information Methods; Column Information; Field Types; MySQL Column Flags; The C Extension; The mysql.connector.connect() Function; The _mysql_connector Module; Summary; Chapter 5: Connection Pooling and Failover; Connection Pooling -- Background; The pooling. MySQLConnectionPool Class.

متن يادداشت

The pooling. PooledMySQLConnection ClassConfiguration Options; Using Connection Pools; Creating a Connection Pool; Using Connection Pool Connections; Using the mysql.connector.connect() Function; Using the get_connection() Method; Executing Queries; Reconfiguring the Connections; Connection Failover; Failover Configuration; Coding for Failover; Failover Example; Summary; Part III: The X DevAPI; Chapter 6: The X DevAPI; The MySQL X Plugin; The mysqlx Module; Creating a Session; Passing Individual Options; Passing an URI; Connection Examples; Working with the Session; Transactions.

بدون عنوان

0

بدون عنوان

8

بدون عنوان

8

بدون عنوان

8

بدون عنوان

8

متن يادداشت

Move data back and forth between database and application. The must-have knowledge in this book helps programmers learn how to use the official driver, MySQL Connector/Python, by which Python programs communicate with the MySQL database. This book takes you from the initial installation of the connector through basic query execution, then through more advanced topics, error handing, and troubleshooting. The book covers both the traditional API as well as the new X DevAPI. The X DevAPI is part of MySQL 8.0 and is an API that can be used with connectors for several programming languages and is used from the command-line interface known as MySQL Shell. You will learn to use the connector by working through code examples and following a discussion of how the API calls work. By the end of the book, you will be able to use MySQL as the back-end storage for your Python programs, and you'll even have the option of choosing between SQL and NoSQL interfaces. What You'll Learn: Install MySQL Connector/Python Connect to MySQL and configure database access Execute SQL and NoSQL queries from your Python program Trap errors and troubleshoot problems Store data from different languages using MySQL's character set support Work in the X DevAPI that underlies all of MySQL's language connectors.

منبع سفارش / آدرس اشتراک

Safari Books Online

شماره انبار

CL0500000990

عنوان

MySQL Connector/Python revealed.

شماره استاندارد بين المللي کتاب و موسيقي

9781484236932

موضوع مستند نشده

MySQL (Electronic resource)

موضوع مستند نشده

MySQL (Electronic resource)

موضوع مستند نشده

Python (Computer program language)

موضوع مستند نشده

Computer programming-- software development.

موضوع مستند نشده

COMPUTERS-- Databases-- General.

موضوع مستند نشده

Databases.

موضوع مستند نشده

Programming & scripting languages: general.

موضوع مستند نشده

Python (Computer program language)

موضوع مستند نشده

COM-- 021000

موضوع مستند نشده

UMT

موضوع مستند نشده

UMT

موضوع مستند نشده

UN

موضوع مستند نشده

UN

شماره

ويراست

شماره رده

مستند نام اشخاص تاييد نشده

Krogh, Jesper Wisborg

تاريخ عمليات

20200823032212.0

قواعد فهرست نويسي ( بخش توصيفي )

pn

نام الکترونيکي

نوع ماده

[Book]

تكميل شده

Y