Cargando…
MySQL for Python /
This is a practical, tutorial-style book that includes many examples to demonstrate the full potential of MySQL for Python. Every chapter starts with an explanation of the various areas for using MySQL for Python and ends with work on a sample application using the programming calls just learned. Al...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Pub.,
©2010.
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | EBSCO_ocn696354563 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 110112s2010 enka o 001 0 eng d | ||
| 040 | |a N$T |b eng |e pn |c N$T |d OCLCQ |d NLGGC |d YDXCP |d EBLCP |d OCLCQ |d COO |d OCLCQ |d AGLDB |d OCLCF |d JBG |d OCLCQ |d VTS |d STF |d M8D |d UKAHL |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO | ||
| 019 | |a 855969620 | ||
| 020 | |a 9781849510196 |q (electronic bk.) | ||
| 020 | |a 1849510199 |q (electronic bk.) | ||
| 020 | |z 9781849510189 | ||
| 020 | |z 1849510180 | ||
| 029 | 1 | |a DEBBG |b BV043099696 | |
| 029 | 1 | |a DEBSZ |b 421671998 | |
| 029 | 1 | |a GBVCP |b 803452667 | |
| 035 | |a (OCoLC)696354563 |z (OCoLC)855969620 | ||
| 050 | 4 | |a TK5105.888 |b .L85 2010eb | |
| 072 | 7 | |a COM |x 018000 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.72 |2 22 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Lukaszewski, Albert. | |
| 245 | 1 | 0 | |a MySQL for Python / |c Albert Lukaszewski. |
| 260 | |a Birmingham : |b Packt Pub., |c ©2010. | ||
| 300 | |a 1 online resource (xii, 417 pages) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 588 | 0 | |a Print version record. | |
| 505 | 0 | |a Cover; Copyright; Credits; About the Author; About the Reviewers; Table of Contents; Preface; Chapter 1: Getting Up and Running with MySQL for Python; Getting MySQL for Python; Using a package manager (only on Linux); Using RPMs and yum; Using RPMs and urpm; Using apt tools on Debian-like systems; Using an installer for Windows; Using an egg file; Using a tarball (tar.gz file); Importing MySQL for Python; Accessing online help when you need it; MySQLdb; _mysql; Connecting with a database; Creating a connection object; Creating a cursor object; Interacting with the database. | |
| 505 | 8 | |a Closing the connectionMultiple database connections; Summary; Chapter 2: Simple Querying; A brief introduction to CRUD; Forming a query in MySQL; SELECT; * (asterisk); FROM; staff; ; (semicolon); Other helpful quantifiers; WHERE; GROUP BY; HAVING; ORDER BY; LIMIT; INTO OUTFILE; Passing a query to MySQL; A simple SELECT statement; Modifying the results; Using user-defined variables; Determining characteristics of a database and its tables; Determining what tables exist; Assigning each table a number; Offering the options to the user; Allowing the user to detail a search query. | |
| 505 | 8 | |a Changing queries dynamicallyPattern matching in MySQL queries; Putting it into practice; Project: a command-line search utility; Preparing a database for searching; Planning your work, then working your plan; Develop a well-abstracted search functionality.; Specifying the search term from the command-line; Implementing and incorporating the other functions: -t, -f, and -o; Including an option for an output file; Room to grow; Summary; Chapter 3: Simple Insertion; Forming a MySQL insertion statement; INSERT; INTO; Table name; Column names; VALUES; ; ; (semicolon). | |
| 505 | 8 | |a Helpful ways to nuance an INSERT statementINSERT ... SELECT ... ; INSERT DELAYED ... ; INSERT ... ON DUPLICATE KEY UPDATE ... ; Passing an insertion through MySQL for Python; Setting up the preliminaries; A simple INSERT statement; More complex INSERT commands; Using user-defined variables; Using metadata; Querying the database for its structure; Retrieving the table structure; Changing insertion values dynamically; Validating the value of name; Validating the value of price; Querying the user for a correction; Passing fish and price for validation; Essentials: close and commit; In need of some closure. | |
| 505 | 8 | |a What happened to commit?Why are these essentials non-essential?; Project: a command-line insertion utility; The necessary modules; The main() thing; Coding the flag system; Testing the values passed by the user; Try to establish a database connection; Showing the tables; Showing the table structure, if desired; Accepting user input for the INSERT statement; Building the INSERT statement from the user input and execute it; Committing changes and closing the connection; Coding the other functions; valid_digit() and valid_string(); valid_table(); query(); Calling main(); Room to grow; Summary. | |
| 520 | |a This is a practical, tutorial-style book that includes many examples to demonstrate the full potential of MySQL for Python. Every chapter starts with an explanation of the various areas for using MySQL for Python and ends with work on a sample application using the programming calls just learned. All complicated concepts are broken down to be very easy to understand. Everything in the book is designed to help you learn and use MySQL for Python to address your programming needs in the fastest way possible. This book is meant for intermediate users of Python who want hassle-free access to their. | ||
| 590 | |a eBooks on EBSCOhost |b EBSCO eBook Subscription Academic Collection - Worldwide | ||
| 630 | 0 | 0 | |a MySQL (Electronic resource) |
| 630 | 0 | 7 | |a MySQL (Electronic resource) |2 fast |
| 650 | 0 | |a Python (Computer programme language) | |
| 650 | 0 | |a Web site development. | |
| 650 | 6 | |a Sites Web |x Développement. | |
| 650 | 7 | |a COMPUTERS |x Data Processing. |2 bisacsh | |
| 650 | 7 | |a Web site development |2 fast | |
| 776 | 0 | 8 | |i Print version: |a Lukaszewski, Albert. |t MySQL for Python. |d Birmingham : Packt Pub., 2010 |z 9781849510189 |w (OCoLC)693412115 |
| 856 | 4 | 0 | |u https://ebsco.uam.elogim.com/login.aspx?direct=true&scope=site&db=nlebk&AN=342273 |z Texto completo |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26943559 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL1336390 | ||
| 938 | |a EBSCOhost |b EBSC |n 342273 | ||
| 938 | |a YBP Library Services |b YANK |n 3595428 | ||
| 994 | |a 92 |b IZTAP | ||