自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+

Happy in Code

夜深人静之时,头发斑白的老程序员会蜷缩在床上,欣赏一段精彩的子程序,或者苦思冥想一个绝妙的宏结构;而那些年少轻狂的程序员,则可能正在通过终端与别人聊得不亦乐乎。

  • 博客(1)
  • 资源 (36)
  • 收藏
  • 关注

原创 C语言数组排序小结

让我们先定义一个整型数组a[n],下面用五种方法对其从小到大排序。 (1)“冒泡法” 冒泡法大家都较熟悉。其原理为从a[0]开始,依次将其和后面的元素比较,若a[0]>a[i],则交换它们,一直比较到a[n]。同理对a[1],a[2],...a[n-1]处理,即完成排序。下面列出其代码: void bubble(int *a,int n) /*定义两个参数:数组首地址与数组大小*/ { int

2008-04-09 18:08:00 10055

100家大公司java笔试题汇总(免费)

该文档是各大大公司的java笔试题,分为单选题、多选题、简答题、编程题。

2015-08-09

windows核心编程第五版英文版

windows核心编程 第五版 英文版

2013-10-23

Introduction+to+3D+Game+Programming+with+DirectX+9.0

Introduction+to+3D+Game+Programming+with+DirectX+9.0

2013-10-23

Jump into CPP(包含全部源码)

Jump into CPP(包含全部源码) 本书讲解通俗易懂 是C++初学者的优选

2013-10-23

The C++ Standard Library A Tutorial and Reference (2nd)

The C++ Standard Library A Tutorial and Reference (2nd Edition)

2013-10-23

Mastering.Algorithms.with.C

经典C语言算法书原版。 Mastering.Algorithms.with.C

2013-10-23

Ant-The Definitive Guide,第二版2nd Edition

目录: What's Inside Conventions Used in This Book What You'll Need Using Code Examples We'd Like to Hear from You Chapter 1. Getting Started Section 1.1. Ant's Origins Section 1.2. Getting Ant Section 1.3. Ant at Work Section 1.4. Anatomy of a Build File Section 1.5. Running Ant Chapter 2. Using Properties and Types Section 2.1. Using Properties to Control Tasks Section 2.2. Using Property Files Section 2.3. Handling Data Using Types Chapter 3. Building Java Code Section 3.1. Compiling Code Section 3.2. Getting Input from the User Section 3.3. Calling Other Ant Tasks Section 3.4. Importing Other Build Files Section 3.5. Documenting Code Section 3.6. Creating JAR Files Section 3.7. Setting Build Numbers Section 3.8. Setting Timestamps Chapter 4. Deploying Builds Section 4.1. Packaging Applications for Deployment Section 4.2. Preparing to Deploy Section 4.3. Deploying Applications Section 4.4. Scheduling Automatic Builds Chapter 5. Testing Builds with JUnit Section 5.1. Using JUnit Section 5.2. Running Test Cases Section 5.3. Testing in Batches Section 5.4. Running the Build File Section 5.5. Extending JUnit Chapter 6. Getting Source Code from CVS Repositories Section 6.1. Source Control and Ant Section 6.2. Logging In Section 6.3. Working with the Server Section 6.4. Getting Version Data Section 6.5. Creating Change Logs Section 6.6. Finding Changes Between Versions Section 6.7. Creating Patches Chapter 7. Executing External Programs Section 7.1. Executing Java Code Section 7.2. Executing External Programs Section 7.3. Performing Batch Execution Section 7.4. Multithreading Tasks Section 7.5. Setting Execution Order Chapter 8. Developing for the Web Section 8.1. Creating WAR Archives Section 8.2. Creating CAB Files Section 8.3. Creating Simple Web Deployment Section 8.4. Deploying with SCP Section 8.5. Deploying to Tomcat Section 8.6. Deploying to Tomcat Section 8.7. Compiling JSPs Section 8.8. Deploying to EJB Containers Chapter 9. XML and XDoclet Section 9.1. Validating XML Documents Section 9.2. Loading Properties from XML Files Section 9.3. Creating Ant Task DTDs Section 9.4. Transforming XML Using XSLT Section 9.5. Using XDoclet Section 9.6. Developing Enterprise JavaBeans Chapter 10. Optional Tasks Section 10.1. Using Sound Section 10.2. Creating Splash Screens Section 10.3. Subtituting Text Using Regular Expressions Section 10.4. Handling Dependencies Chapter 11. Integrating Ant with Eclipse Section 11.1. Introducing Eclipse Section 11.2. Running Ant Build Files Section 11.3. Using a Different Version of Ant Section 11.4. Using the Ant View Chapter 12. Extending Ant Section 12.1. Creating a Simple Custom Ant Task Section 12.2. Extending the Task Class Section 12.3. Creating Custom Listeners Section 12.4. Creating Custom Loggers Section 12.5. Creating Custom Filters Section 12.6. Creating Custom Selectors Section 12.7. Creating New Types

2012-10-10

jcabi-log-0.2.1.jar

jcabi可以让log4j的控制台日志信息,不同级别,显示颜色不一样。 warn级别及以上,是有颜色的高亮显示。debug, info是没有颜色

2012-10-10

MySQL版块提问所需脚本

下面MYSQL提问的DDL脚本,测试数据,存储过程脚本 http://topic.csdn.net/u/20100818/00/a06764d5-f809-4611-8247-04bd0ab8658b.html?seed=964565921&r=67903001#r_67903001

2010-08-24

MySQL存储过程编程

国外经典MYSQL存储过程书籍,内容讲的很全面和细致 MySQL.Stored.Procedure.Programming

2010-08-03

scripting in java-languages-frameworks-and-patterns

scripting in java-languages-frameworks-and-patterns

2010-07-31

精通shell脚本编程

国外经典SHELL脚本编程书籍,2009年出版 PART 1 ■ ■ ■ Basic Scripting Techniques ■CHAPTER 1 Shell Script Debugging . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 ■CHAPTER 2 Standard Function Library . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 ■CHAPTER 3 Date and Time Manipulation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 ■CHAPTER 4 Comparisons and Tests . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 ■CHAPTER 5 Accepting Command-Line Options, Switches, and Parameters. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 ■CHAPTER 6 Testing Variables and Assigning Defaults . . . . . . . . . . . . . . . . . . . . . . 37 ■CHAPTER 7 Indirect Reference Variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43 ■CHAPTER 8 Shell Process Tree . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49 ■CHAPTER 9 Data Redirection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 ■CHAPTER 10 Piping Input to read . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65 PART 2 ■ ■ ■ System Interaction and Advanced Techniques ■CHAPTER 11 Math from the Shell . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75 ■CHAPTER 12 cron . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81 ■CHAPTER 13 Self-Linked Scripts. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87 ■CHAPTER 14 Throttling Parallel Processes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91 ■CHAPTER 15 Command-Line Editing and History. . . . . . . . . . . . . . . . . . . . . . . . . . . . 99 ■CHAPTER 16 Scripting from the Command Line. . . . . . . . . . . . . . . . . . . . . . . . . . . . 103 ■CHAPTER 17 Automating User Input with expect . . . . . . . . . . . . . . . . . . . . . . . . . . . 107 ■CHAPTER 18 User Input Timeout. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115 ■CHAPTER 19 Instant Keyboard Response . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121 ■CHAPTER 20 Directory Copying . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125 ■CHAPTER 21 A Brief Tour of the X Display Environment . . . . . . . . . . . . . . . . . . . . 131 ■CHAPTER 22 X Navigation Window. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 141 ■CHAPTER 23 Command-Line E-mail Attachments . . . . . . . . . . . . . . . . . . . . . . . . . . 151 ■CHAPTER 24 Text-Processing One-Liners . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 157 ■CHAPTER 25 Editing Files in Place . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 173 ■CHAPTER 26 Evaluating Variables in a Flat File . . . . . . . . . . . . . . . . . . . . . . . . . . . . 181 ■CHAPTER 27 Read Piped Input. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 183 ■CHAPTER 28 Free-Format Output Using cat . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 185 ■CHAPTER 29 Automating Interactive Processes . . . . . . . . . . . . . . . . . . . . . . . . . . . . 187 PART 3 ■ ■ ■ Useful Scripts ■CHAPTER 30 Automating E-Mail with procmail . . . . . . . . . . . . . . . . . . . . . . . . . . . . 193 ■CHAPTER 31 Process-Management Monitor . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 201 ■CHAPTER 32 Managing File Counts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 211 ■CHAPTER 33 Processes Running from inittab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 215 ■CHAPTER 34 Automatic RCS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 219 ■CHAPTER 35 Colorful /proc Reporting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 223 ■CHAPTER 36 Password-Aging Notification. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 231 ■CHAPTER 37 A Pseudo–shadow File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 241 ■CHAPTER 38 Linux Gold-System Build . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 245 ■CHAPTER 39 System Snapshots . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 251 ■CHAPTER 40 Removing Large Files and Log Rolling . . . . . . . . . . . . . . . . . . . . . . . . 261 ■CHAPTER 41 Core Finder . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 265 ■CHAPTER 42 Network Adapter Failover . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 267 ■APPENDIX A Test Switches . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 273 ■APPENDIX B Special Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 275 ■APPENDIX C Other Shell-Scripting Resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 277

2010-07-31

MySQL.Cookbook第二版.chm

Chapter 1. Using the mysql Client Program Section 1.0. Introduction Recipe 1.1. Setting Up a MySQL User Account Recipe 1.2. Creating a Database and a Sample Table Recipe 1.3. Starting and Stopping mysql Recipe 1.4. Specifying Connection Parameters Using Option Files Recipe 1.5. Protecting Option Files from Other Users Recipe 1.6. Mixing Command-Line and Option File Parameters Recipe 1.7. What to Do if mysql Cannot Be Found Recipe 1.8. Issuing SQL Statements Recipe 1.9. Canceling a Partially Entered Statement Recipe 1.10. Repeating and Editing SQL Statements Recipe 1.11. Using Auto-Completion for Database and Table Names Recipe 1.12. Telling mysql to Read Statements from a File Recipe 1.13. Telling mysql to Read Statements from Other Programs Recipe 1.14. Entering an SQL One-Liner Recipe 1.15. Using Copy and Paste as a mysql Input Source Recipe 1.16. Preventing Query Output from Scrolling off the Screen Recipe 1.17. Sending Query Output to a File or to a Program Recipe 1.18. Selecting Tabular or Tab-Delimited Query Output Format Recipe 1.19. Specifying Arbitrary Output Column Delimiters Recipe 1.20. Producing HTML or XML Output Recipe 1.21. Suppressing Column Headings in Query Output Recipe 1.22. Making Long Output Lines More Readable Recipe 1.23. Controlling mysql's Verbosity Level Recipe 1.24. Logging Interactive mysql Sessions Recipe 1.25. Creating mysql Scripts from Previously Executed Statements Recipe 1.26. Using User-Defined Variables in SQL Statements Recipe 1.27. Numbering Query Output Lines Recipe 1.28. Using mysql as a Calculator Recipe 1.29. Using mysql in Shell Scripts Chapter 2. Writing MySQL-Based Programs Section 2.0. Introduction Recipe 2.1. Connecting, Selecting a Database, and Disconnecting Recipe 2.2. Checking for Errors Recipe 2.3. Writing Library Files Recipe 2.4. Issuing Statements and Retrieving Results Recipe 2.5. Handling Special Characters and NULL Values in Statements Recipe 2.6. Handling Special Characters in Identifiers Recipe 2.7. Identifying NULL Values in Result Sets Recipe 2.8. Techniques for Obtaining Connection Parameters Recipe 2.9. Conclusion and Words of Advice Chapter 3. Selecting Data from Tables Section 3.0. Introduction Recipe 3.1. Specifying Which Columns to Select Recipe 3.2. Specifying Which Rows to Select Recipe 3.3. Giving Better Names to Query Result Columns Recipe 3.4. Using Column Aliases to Make Programs Easier to Write Recipe 3.5. Combining Columns to Construct Composite Values Recipe 3.6. WHERE Clauses and Column Aliases Recipe 3.7. Debugging Comparison Expressions Recipe 3.8. Removing Duplicate Rows Recipe 3.9. Working with NULL Values Recipe 3.10. Writing Comparisons Involving NULL in Programs Recipe 3.11. Sorting a Result Set Recipe 3.12. Using Views to Simplify Table Access Recipe 3.13. Selecting Data from More Than One Table Recipe 3.14. Selecting Rows from the Beginning or End of a Result Set Recipe 3.15. Selecting Rows from the Middle of a Result Set Recipe 3.16. Choosing Appropriate LIMIT Values Recipe 3.17. What to Do When LIMIT Requires the Wrong Sort Order Recipe 3.18. Calculating LIMIT Values from Expressions Chapter 4. Table Management Section 4.0. Introduction Recipe 4.1. Cloning a Table Recipe 4.2. Saving a Query Result in a Table Recipe 4.3. Creating Temporary Tables Recipe 4.4. Checking or Changing a Table's Storage Engine Recipe 4.5. Generating Unique Table Names Chapter 5. Working with Strings Section 5.0. Introduction Recipe 5.1. String Properties Recipe 5.2. Choosing a String Data Type Recipe 5.3. Setting the Client Connection Character Set Properly Recipe 5.4. Writing String Literals Recipe 5.5. Checking a String's Character Set or Collation Recipe 5.6. Changing a String's Character Set or Collation Recipe 5.7. Converting the Lettercase of a String Recipe 5.8. Converting the Lettercase of a Stubborn String Recipe 5.9. Controlling Case Sensitivity in String Comparisons Recipe 5.10. Pattern Matching with SQL Patterns Recipe 5.11. Pattern Matching with Regular Expressions Recipe 5.12. Controlling Case Sensitivity in Pattern Matching Recipe 5.13. Breaking Apart or Combining Strings Recipe 5.14. Searching for Substrings Recipe 5.15. Using FULLTEXT Searches Recipe 5.16. Using a FULLTEXT Search with Short Words Recipe 5.17. Requiring or Excluding FULLTEXT Search Words Recipe 5.18. Performing Phrase Searches with a FULLTEXT Index Chapter 6. Working with Dates and Times Section 6.0. Introduction Recipe 6.1. Choosing a Temporal Data Type Recipe 6.2. Changing MySQL's Date Format Recipe 6.3. Setting the Client Time Zone Recipe 6.4. Determining the Current Date or Time Recipe 6.5. Using TIMESTAMP to Track Row Modification Times Recipe 6.6. Extracting Parts of Dates or Times Recipe 6.7. Synthesizing Dates or Times from Component Values Recipe 6.8. Converting Between Temporal Data Types and Basic Units Recipe 6.9. Calculating the Interval Between Two Dates or Times Recipe 6.10. Adding Date or Time Values Recipe 6.11. Calculating Ages Recipe 6.12. Shifting a Date-and-Time Value to a Different Time Zone Recipe 6.13. Finding the First Day, Last Day, or Length of a Month Recipe 6.14. Calculating Dates by Substring Replacement Recipe 6.15. Finding the Day of the Week for a Date Recipe 6.16. Finding Dates for Any Weekday of a Given Week Recipe 6.17. Performing Leap Year Calculations Recipe 6.18. Canonizing Not-Quite-ISO Date Strings Recipe 6.19. Treating Dates or Times as Numbers Recipe 6.20. Forcing MySQL to Treat Strings as Temporal Values Recipe 6.21. Selecting Rows Based on Their Temporal Characteristics Chapter 7. Sorting Query Results Section 7.0. Introduction Recipe 7.1. Using ORDER BY to Sort Query Results Recipe 7.2. Using Expressions for Sorting Recipe 7.3. Displaying One Set of Values While Sorting by Another Recipe 7.4. Controlling Case Sensitivity of String Sorts Recipe 7.5. Date-Based Sorting Recipe 7.6. Sorting by Calendar Day Recipe 7.7. Sorting by Day of Week Recipe 7.8. Sorting by Time of Day Recipe 7.9. Sorting Using Substrings of Column Values Recipe 7.10. Sorting by Fixed-Length Substrings Recipe 7.11. Sorting by Variable-Length Substrings Recipe 7.12. Sorting Hostnames in Domain Order Recipe 7.13. Sorting Dotted-Quad IP Values in Numeric Order Recipe 7.14. Floating Values to the Head or Tail of the Sort Order Recipe 7.15. Sorting in User-Defined Orders Recipe 7.16. Sorting ENUM Values Chapter 8. Generating Summaries Section 8.0. Introduction Recipe 8.1. Summarizing with COUNT⁠(⁠ ⁠ ⁠) Recipe 8.2. Summarizing with MIN⁠(⁠ ⁠ ⁠) and MAX⁠(⁠ ⁠ ⁠) Recipe 8.3. Summarizing with SUM⁠(⁠ ⁠ ⁠) and AVG⁠(⁠ ⁠ ⁠) Recipe 8.4. Using DISTINCT to Eliminate Duplicates Recipe 8.5. Finding Values Associated with Minimum and Maximum Values Recipe 8.6. Controlling String Case Sensitivity for MIN⁠(⁠ ⁠ ⁠) and MAX⁠(⁠ ⁠ ⁠) Recipe 8.7. Dividing a Summary into Subgroups Recipe 8.8. Summaries and NULL Values Recipe 8.9. Selecting Only Groups with Certain Characteristics Recipe 8.10. Using Counts to Determine Whether Values Are Unique Recipe 8.11. Grouping by Expression Results Recipe 8.12. Categorizing Noncategorical Data Recipe 8.13. Controlling Summary Display Order Recipe 8.14. Finding Smallest or Largest Summary Values Recipe 8.15. Date-Based Summaries Recipe 8.16. Working with Per-Group and Overall Summary Values Simultaneously Recipe 8.17. Generating a Report That Includes a Summary and a List Chapter 9. Obtaining and Using Metadata Section 9.0. Introduction Recipe 9.1. Obtaining the Number of Rows Affected by a Statement Recipe 9.2. Obtaining Result Set Metadata Recipe 9.3. Determining Whether a Statement Produced a Result Set Recipe 9.4. Using Metadata to Format Query Output Recipe 9.5. Listing or Checking Existence of Databases or Tables Recipe 9.6. Accessing Table Column Definitions Recipe 9.7. Getting ENUM and SET Column Information Recipe 9.8. Using Table Structure Information in Applications Recipe 9.9. Getting Server Metadata Recipe 9.10. Writing Applications That Adapt to the MySQL Server Version Recipe 9.11. Determining the Default Database Recipe 9.12. Monitoring the MySQL Server Recipe 9.13. Determining Which Storage Engines the Server Supports Chapter 10. Importing and Exporting Data Section 10.0. Introduction Recipe 10.1. Importing Data with LOAD DATA and mysqlimport Recipe 10.2. Specifying the Datafile Location Recipe 10.3. Specifying the Structure of the Datafile Recipe 10.4. Dealing with Quotes and Special Characters Recipe 10.5. Importing CSV Files Recipe 10.6. Reading Files from Different Operating Systems Recipe 10.7. Handling Duplicate Key Values Recipe 10.8. Obtaining Diagnostics About Bad Input Data Recipe 10.9. Skipping Datafile Lines Recipe 10.10. Specifying Input Column Order Recipe 10.11. Preprocessing Input Values Before Inserting Them Recipe 10.12. Ignoring Datafile Columns Recipe 10.13. Exporting Query Results from MySQL Recipe 10.14. Exporting Tables as Text Files Recipe 10.15. Exporting Table Contents or Definitions in SQL Format Recipe 10.16. Copying Tables or Databases to Another Server Recipe 10.17. Writing Your Own Export Programs Recipe 10.18. Converting Datafiles from One Format to Another Recipe 10.19. Extracting and Rearranging Datafile Columns Recipe 10.20. Using the SQL Mode to Control Bad Input Data Handling Recipe 10.21. Validating and Transforming Data Recipe 10.22. Using Pattern Matching to Validate Data Recipe 10.23. Using Patterns to Match Broad Content Types Recipe 10.24. Using Patterns to Match Numeric Values Recipe 10.25. Using Patterns to Match Dates or Times Recipe 10.26. Using Patterns to Match Email Addresses or URLs Recipe 10.27. Using Table Metadata to Validate Data Recipe 10.28. Using a Lookup Table to Validate Data Recipe 10.29. Converting Two-Digit Year Values to Four-Digit Form Recipe 10.30. Performing Validity Checking on Date or Time Subparts Recipe 10.31. Writing Date-Processing Utilities Recipe 10.32. Using Dates with Missing Components Recipe 10.33. Importing Non-ISO Date Values Recipe 10.34. Exporting Dates Using Non-ISO Formats Recipe 10.35. Importing and Exporting NULL Values Recipe 10.36. Guessing Table Structure from a Datafile Recipe 10.37. Exchanging Data Between MySQL and Microsoft Access Recipe 10.38. Exchanging Data Between MySQL and Microsoft Excel Recipe 10.39. Exporting Query Results as XML Recipe 10.40. Importing XML into MySQL Recipe 10.41. Epilogue Chapter 11. Generating and Using Sequences Section 11.0. Introduction Recipe 11.1. Creating a Sequence Column and Generating Sequence Values Recipe 11.2. Choosing the Data Type for a Sequence Column Recipe 11.3. The Effect of Row Deletions on Sequence Generation Recipe 11.4. Retrieving Sequence Values Recipe 11.5. Renumbering an Existing Sequence Recipe 11.6. Extending the Range of a Sequence Column Recipe 11.7. Reusing Values at the Top of a Sequence Recipe 11.8. Ensuring That Rows Are Renumbered in a Particular Order Recipe 11.9. Starting a Sequence at a Particular Value Recipe 11.10. Sequencing an Unsequenced Table Recipe 11.11. Using an AUTO_INCREMENT Column to Create Multiple Sequences Recipe 11.12. Managing Multiple Simultaneous AUTO_INCREMENT Values Recipe 11.13. Using AUTO_INCREMENT Values to Relate Tables Recipe 11.14. Using Sequence Generators as Counters Recipe 11.15. Generating Repeating Sequences Recipe 11.16. Numbering Query Output Rows Sequentially Chapter 12. Using Multiple Tables Section 12.0. Introduction Recipe 12.1. Finding Rows in One Table That Match Rows in Another Recipe 12.2. Finding Rows with No Match in Another Table Recipe 12.3. Comparing a Table to Itself Recipe 12.4. Producing Master-Detail Lists and Summaries Recipe 12.5. Enumerating a Many-to-Many Relationship Recipe 12.6. Finding Rows Containing Per-Group Minimum or Maximum Values Recipe 12.7. Computing Team Standings Recipe 12.8. Using a Join to Fill or Identify Holes in a List Recipe 12.9. Calculating Successive-Row Differences Recipe 12.10. Finding Cumulative Sums and Running Averages Recipe 12.11. Using a Join to Control Query Output Order Recipe 12.12. Combining Several Result Sets in a Single Query Recipe 12.13. Identifying and Removing Mismatched or Unattached Rows Recipe 12.14. Performing a Join Between Tables in Different Databases Recipe 12.15. Using Different MySQL Servers Simultaneously Recipe 12.16. Referring to Join Output Column Names in Programs Chapter 13. Statistical Techniques Section 13.0. Introduction Recipe 13.1. Calculating Descriptive Statistics Recipe 13.2. Per-Group Descriptive Statistics Recipe 13.3. Generating Frequency Distributions Recipe 13.4. Counting Missing Values Recipe 13.5. Calculating Linear Regressions or Correlation Coefficients Recipe 13.6. Generating Random Numbers Recipe 13.7. Randomizing a Set of Rows Recipe 13.8. Selecting Random Items from a Set of Rows Recipe 13.9. Assigning Ranks Chapter 14. Handling Duplicates Section 14.0. Introduction Recipe 14.1. Preventing Duplicates from Occurring in a Table Recipe 14.2. Dealing with Duplicates When Loading Rows into a Table Recipe 14.3. Counting and Identifying Duplicates Recipe 14.4. Eliminating Duplicates from a Table Recipe 14.5. Eliminating Duplicates from a Self-Join Result Chapter 15. Performing Transactions Section 15.0. Introduction Recipe 15.1. Choosing a Transactional Storage Engine Recipe 15.2. Performing Transactions Using SQL Recipe 15.3. Performing Transactions from Within Programs Recipe 15.4. Using Transactions in Perl Programs Recipe 15.5. Using Transactions in Ruby Programs Recipe 15.6. Using Transactions in PHP Programs Recipe 15.7. Using Transactions in Python Programs Recipe 15.8. Using Transactions in Java Programs Recipe 15.9. Using Alternatives to Transactions Chapter 16. Using Stored Routines, Triggers, and Events Section 16.0. Introduction Recipe 16.1. Creating Compound-Statement Objects Recipe 16.2. Using a Stored Function to Encapsulate a Calculation Recipe 16.3. Using a Stored Procedure to Return Multiple Values Recipe 16.4. Using a Trigger to Define Dynamic Default Column Values Recipe 16.5. Simulating TIMESTAMP Properties for Other Date and Time Types Recipe 16.6. Using a Trigger to Log Changes to a Table Recipe 16.7. Using Events to Schedule Database Actions Chapter 17. Introduction to MySQL on the Web Section 17.0. Introduction Recipe 17.1. Basic Principles of Web Page Generation Recipe 17.2. Using Apache to Run Web Scripts Recipe 17.3. Using Tomcat to Run Web Scripts Recipe 17.4. Encoding Special Characters in Web Output Chapter 18. Incorporating Query Results into Web Pages Section 18.0. Introduction Recipe 18.1. Displaying Query Results as Paragraph Text Recipe 18.2. Displaying Query Results as Lists Recipe 18.3. Displaying Query Results as Tables Recipe 18.4. Displaying Query Results as Hyperlinks Recipe 18.5. Creating a Navigation Index from Database Content Recipe 18.6. Storing Images or Other Binary Data Recipe 18.7. Retrieving Images or Other Binary Data Recipe 18.8. Serving Banner Ads Recipe 18.9. Serving Query Results for Download Recipe 18.10. Using a Template System to Generate Web Pages Chapter 19. Processing Web Input with MySQL Section 19.0. Introduction Recipe 19.1. Writing Scripts That Generate Web Forms Recipe 19.2. Creating Single-Pick Form Elements from Database Content Recipe 19.3. Creating Multiple-Pick Form Elements from Database Content Recipe 19.4. Loading a Database Record into a Form Recipe 19.5. Collecting Web Input Recipe 19.6. Validating Web Input Recipe 19.7. Storing Web Input in a Database Recipe 19.8. Processing File Uploads Recipe 19.9. Performing Searches and Presenting the Results Recipe 19.10. Generating Previous-Page and Next-Page Links Recipe 19.11. Generating Click to Sort Table Headings Recipe 19.12. Web Page Access Counting Recipe 19.13. Web Page Access Logging Recipe 19.14. Using MySQL for Apache Logging Chapter 20. Using MySQL-Based Web Session Management Section 20.0. Introduction Recipe 20.1. Using MySQL-Based Sessions in Perl Applications Recipe 20.2. Using MySQL-Based Storage in Ruby Applications Recipe 20.3. Using MySQL-Based Storage with the PHP Session Manager Recipe 20.4. Using MySQL for Session-Backing Store with Tomcat Appendix A. Obtaining MySQL Software Obtaining Sample Source Code and Data Obtaining MySQL and Related Software Appendix B. Executing Programs from the Command Line Setting Environment Variables Executing Programs Appendix C. JSP and Tomcat Primer Servlet and JavaServer Pages Overview Setting Up a Tomcat Server Tomcat's Directory Structure Restarting Applications Without Restarting Tomcat Web Application Structure Elements of JSP Pages Appendix D. References Recipe MySQL Resources Recipe Perl Resources Recipe Ruby Resources Recipe PHP Resources Recipe Python Resources Recipe Java Resources Recipe Other Resources

2010-07-24

Packt.MySQL.Admin.Cookbook.2010.pdf

What this book covers Chapter 1, Replication: In this chapter, you will see how to set up MySQL replication, useful for load balancing, online backups, and fail-over scenarios. Advanced replication scenarios using the blackhole engine and streaming slave deployment are discussed beyond the basic topics. Chapter 2, Indexing: You will be shown how to create, drop, and modify indexes, perhaps the most important means of optimizing your MySQL servers' performance. Fulltext indexing, clustered and non-clustered indexes are compared and presented with their respective strengths and typical use cases. Moreover, you will learn how to identify duplicate indexes, which can hinder your servers' performance. Chapter 3, Tools: This chapter will get you acquainted with the MySQL Administrator and Query Browser GUI Tools as well as the MySQL command-line client and how to use it in concert with external scripts and tools. You will also see how to create custom diagrams for MySQL Administrator and share connection profiles between multiple computers. Chapter 4, Backing Up and Restoring MySQL Data: In this chapter, we introduce the basic approaches to backing up your database and restoring data again. Advanced techniques like on-the-fly compression, point in time recovery, avoiding extended lock situations, backup in replication scenarios, and partial backup and restore are also covered. Chapter 5, Managing Data: You will learn some tricks beyond the basic SQL commands, which enable you to delete data in a highly efficient manner and insert data based on existing database content, and how to import and export data to and from your database. Chapter 6, Monitoring and Analyzing a MySQL Installation: We present approaches to monitoring table space usage, and how to use database metadata to your advantage. Typical performance bottlenecks and lock contention problems are discussed as well. Chapter 7, Configuring MySQL: This chapter deals with MySQL configuration and how to best leverage available settings to their full potential. Table space management, pool sizing, and logging options are discussed along with platform-specific caveats and advanced installation scenarios, such as multiple instances on one server. Chapter 8, MySQL User Management: Management of MySQL user accounts is discussed in detail throughout this chapter. Typical user roles with appropriate privileges and approaches to restricting access sensibly are proposed. You will also learn how to regain access to your database in case the administrative user credentials are lost. Chapter 9, Managing Schemas: This chapter includes topics such as adding and removing columns to and from tables and choosing a suitable storage engine and character set for individual needs. Another recipe covers a technique to add a new primary key column to a table already filled with data. Ways to manage and automate database schema evolution, as part of a software life cycle are presented as well. And if you have always missed "ADD INDEX IF NOT EXISTS", you will find a solution to this, too. Appendix, Good to Know: In this final part of the book you can find several things that can turn out useful in everyday situations, but did not fit the step-by-step recipe format naturally. Topics range from choosing character sets to getting the most out of 32 bit address space limitations.

2010-07-23

Fedora 10和Redhat 企业版Linux宝典

Part I: Getting Started in Fedora and RHEL Chapter 1: An Overview of Fedora and Red Hat Enterprise Linux Chapter 2: Installing Fedora Chapter 3: Getting Started with the Desktop Chapter 4: Using Linux Commands Part II: Using Fedora and RHEL Chapter 5: Accessing and Running Applications Chapter 6: Publishing with Fedora and RHEL Chapter 7: Gaming in Fedora and RHEL Chapter 8: Music, Video, and Images in Linux Chapter 9: Using the Internet and the Web Part III: Administering Fedora and RHEL Chapter 10: Understanding System Administration Chapter 11: Setting Up and Supporting Users Chapter 12: Automating System Tasks Chapter 13: Backing Up and Restoring Files Chapter 14: Computer Security Issues Part IV: Fedora and RHEL Network and Server Setup Chapter 15: Setting Up a Local Area Network Chapter 16: Connecting to the Internet. Chapter 17: Setting Up a Print Server Chapter 18: Setting Up a File Server Chapter 19: Setting Up a Mail Server Chapter 20: Setting Up an FTP Server Chapter 21: Setting Up a Web Server Chapter 22: Setting Up an LDAP Address Book Server Chapter 23: Setting Up a DHCP Boot Server Chapter 24: Setting Up a MySQL Database Server Chapter 25: Making Servers Public with DNS Chapter 26: Integrating Fedora with Apple Macs

2010-07-21

Linux命令行入门:Beginning the Linux Command Line

CHAPTER 1 Starting Linux Command-Line Administration . . . . . . . . . . . . . . . . . . . . . 1 CHAPTER 2 Performing Essential Command-Line Tasks. . . . . . . . . . . . . . . . . . . . . . 27 CHAPTER 3 Administering the Linux File System . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47 CHAPTER 4 Working with Text Files. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69 CHAPTER 5 Managing Partitions and Logical Volumes . . . . . . . . . . . . . . . . . . . . . . . 91 CHAPTER 6 Managing Users and Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 133 CHAPTER 7 Managing Permissions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 163 CHAPTER 8 Managing Software . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 179 CHAPTER 9 Process and System Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 197 CHAPTER 10 System Logging . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 217 CHAPTER 11 Configuring the Network. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 237 CHAPTER 12 Configuring a File Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 277 CHAPTER 13 Working with the Kernel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 299 CHAPTER 14 Introduction to Bash Shell Scripting . . . . . . . . . . . . . . . . . . . . . . . . . . . . 319 APPENDIX Installing Linux. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 353

2010-07-21

Linux操作系统下C语言编程入门(中文)

4 第一章 基础知识 ....................................................................................... 10 进程介绍 .................................................................................... 第二章 17 文件操作 .................................................................................... 第三章 27 时间概念 .................................................................................... 第四章 31 信号处理 .................................................................................... 第五章 39 消息管理 .................................................................................... 第六章 49 线程操作 .................................................................................... 第七章 54 网络编程 .................................................................................... 第八章 87 Linux 下 C 开发工具介绍 ................................................................ 第九章

2010-07-21

SecureCRT-650+SecureFX-651,内含注册机

真正可用的SecureCRT注册机,找了好久找到的。X86

2010-07-19

JacORB_2.3.0

免费的CORBA服务,OMG CORBA Java实现。里面包含源码以及如何使用,还有一些示例

2010-07-09

Linux与Unix Shell编程指南

Linux与Unix Shell编程指南,pdf的。

2010-03-01

pentaho多维报表组件mondrian和web的集成

pentaho多维报表组件mondrian和web的集成,一个word文档。本文档是从CSDN下载的,由于写博客文章不能传附件,只能搁这里面了。

2009-12-15

java开源技术选型手册

java开源技术选型手册 struts spring hibernate ajax 众多开源技术的讲解

2009-07-28

java1.5 api 中文 chm格式

java jdk1.5 api,中文,chm格式 分享原则,不设资源分,免费下载

2009-07-28

15天学会jQuery

jQuery是非常简单好用的javascript框架,本电子教程详细讲述了jQuery的各种用法

2009-03-19

MySQL技术培训资料(具体优化部分)

MySQL技术培训资料,具体优化部分,中国数码集团内部培训资料

2009-02-01

MySQL技术培训资料

MySQL技术培训资料,中国数码集团内部培训资料

2009-02-01

实现SOA的相关技术

本文档为pdf格式,讲述实现SOA的相关技术

2009-02-01

中国移动BOSS业务规范(正式版)

中国移动BOSS业务规范(正式版),java

2009-02-01

struts2中文教程

struts2中文教程 struts2使用起来比struts1强大和方便许多,是非常值得推崇的javaEE框架

2008-12-30

JAVA学生成绩管理系统

JAVA做的学生成绩管理系统,SWING做的界面。SQLServer数据库.初学JAVA,如果有见到我程序的朋友,见笑了。偶是菜鸟,对JAVA只有一点认识。热爱JAVA的朋友,共同学习进步啦!祝愿大家都学好JAVA

2008-06-21

数据结构与常用算法

数据结构 算法 C语言 JAVA

2008-05-29

IE错误窗口

IE错误窗口

2008-04-27

JBuilder程序设计实例

JBuilder程序设计实例

2008-04-09

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

提示
确定要删除当前文章?
取消 删除