MySQL Cookbook by DuBois Paul
Author:DuBois, Paul [Paul DuBois]
Language: eng
Format: epub
Tags: COMPUTERS / Database Management / General
ISBN: 9780596158620
Publisher: O'Reilly Media
Published: 2009-06-29T16:00:00+00:00
Sometimes people omit UNSIGNED so that they can create rows that contain negative numbers in the sequence column. (Using –1 to signify “has no ID” is an instance of this.) This is a bad idea. MySQL makes no guarantees about how negative numbers will be treated in an AUTO_INCREMENT column, so you’re playing with fire if you try to use them. For example, if you resequence the column, you’ll find that all your negative values get turned into positive sequence numbers.
AUTO_INCREMENT columns cannot contain NULL values, so id is declared as NOTNULL. (It’s true that you can specify NULL as the column value when you insert a new row, but for an AUTO_INCREMENT column, that really means “generate the next sequence value.”) MySQL automatically defines AUTO_INCREMENT columns as NOTNULL if you forget to.
Download
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
Access | Data Mining |
Data Modeling & Design | Data Processing |
Data Warehousing | MySQL |
Oracle | Other Databases |
Relational Databases | SQL |
Algorithms of the Intelligent Web by Haralambos Marmanis;Dmitry Babenko(7846)
Learning SQL by Alan Beaulieu(5400)
Weapons of Math Destruction by Cathy O'Neil(5032)
Big Data Analysis with Python by Ivan Marin(2967)
Blockchain Basics by Daniel Drescher(2884)
Pandas Cookbook by Theodore Petrou(2496)
Hands-On Machine Learning for Algorithmic Trading by Stefan Jansen(2491)
Mastering Python for Finance by Unknown(2467)
Building Statistical Models in Python by Huy Hoang Nguyen & Paul N Adams & Stuart J Miller(2399)
Azure Data and AI Architect Handbook by Olivier Mertens & Breght Van Baelen(2365)
Serverless Machine Learning with Amazon Redshift ML by Debu Panda & Phil Bates & Bhanu Pittampally & Sumeet Joshi(2307)
How The Mind Works by Steven Pinker(2207)
Data Wrangling on AWS by Navnit Shukla | Sankar M | Sam Palani(2079)
Building Machine Learning Systems with Python by Richert Willi Coelho Luis Pedro(2056)
Data Engineering with dbt by Roberto Zagni(2007)
Network Science with Python and NetworkX Quick Start Guide by Edward L. Platt(1954)
Driving Data Quality with Data Contracts by Andrew Jones(1950)
Python Natural Language Processing by Jalaj Thanaki(1889)
Solidity Programming Essentials by Ritesh Modi(1762)