Happy in Code

Shiro教程

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

windows核心编程 第五版 英文版

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

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

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

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

目录： 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

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

很经典的java swing书籍，高清版。找了好久找到的。 Part I Foundations 1 1 Swing overview 3 1.1 AWT 3 1.2 Swing 4 Z-order 5, Platform independence 5, Swing package overview 5 1.3 MVC architecture 7 Model 7, View 8, Controller 8, Custom view and controller 8, Custom models 9 1.4 UI delegates and PLAF 11 The ComponentUI class 11, Pluggable look and feel 12, Where are the UI delegates? 13 2 Swing mechanics 15 2.1 JComponent properties, sizing, and positioning 15 Properties 15, Size and positioning 18 2.2 Event handling and dispatching 19 EventListenerList 22, Event-dispatching thread 22 2.3 Multithreading 23 Special cases 26, How do we build our own thread-safe methods 26, 2.4 Timers 27 2.5 AppContext services 28 xii CONTENTS 2.6 Inside Timers and the TimerQueue 30 2.7 JavaBeans architecture 31 The JavaBeans component model 31, Introspection 31, Properties 32, Customization 32, Communication 32, Persistency 32, A simple Swing-based JavaBean 33 2.8 Fonts, colors, graphics, and text 38 Fonts 38, Colors 40, Graphics and text 40 2.9 Using the Graphics clipping area 47 2.10 Graphics debugging 49 Graphics debugging options 50, Graphics debugging caveats 51, Using graphics debugging 51 2.11 Painting and validation 54 Double buffering 55, Optimized drawing 55, Root validation 56, RepaintManager 57, Revalidation 57, Repainting 58, Painting 59, Custom painting 61 2.12 Focus Management 61 KeyboardFocusManager 64, Key events and focus management 64, Focus and Window events 64, Focusability and traversal policies 65 2.13 Keyboard input 66 Listening for keyboard input 66, KeyStrokes 67, Scopes 68, Actions 68, InputMaps and ActionMaps 68 The flow of keyboard input 69 Part II The basics 71 3 Frames, panels, and borders 73 3.1 Frames and panels overview 73 JFrame 73, JRootPane 74, RootLayout 75, The RootPaneContainer interface 76, The WindowConstants interface 76, The WindowListener interface 76, WindowEvent 77, WindowAdapter 77, Custom frame icons 78, Centering a frame on the screen 78, Headless frames and extended frame states 79, Look and feel window decorations 79, JApplet 80, JWindow 80, JPanel 80 3.2 Borders 81 Inside borders 85 3.3 Creating a custom border 86 Understanding the code 87, Running the code 88 CONTENTS xiii 4 Layout managers 89 4.1 Layouts overview 89 LayoutManager 90, LayoutManager2 90, BoxLayout 91, Box 91, Filler 91, FlowLayout 92, GridLayout 92, GridBagLayout 92, BorderLayout 93, CardLayout 93, SpringLayout 93, JPanel 94 4.2 Comparing common layout managers 94 Understanding the code 97, Running the code 97 4.3 Using GridBagLayout 98 Default behavior of GridBagLayout 98, Introducing GridBagConstraint 98, Using the gridx, gridy, insets, ipadx and ipady constraints 99, Using weightx and weighty constraints 100, Using gridwidth and gridheight constraints 101, Using anchor constraints 102, Using fill constraints 103, Putting it all together: constructing a complaints dialog 104, A simple helper class example 109 4.4 Choosing the right layout 114 Understanding the code 119, Running the code 121 4.5 Custom layout manager, part I: labels/field pairs 121 Understanding the code 125, Running the code 128 4.6 Custom layout manager, part II: common interfaces 128 Understanding the code 136, Running the code 139 4.7 Dynamic layout in a JavaBeans container 140 Understanding the code 151, Running the code 153 5 Labels and buttons 155 5.1 Labels and buttons overview 155 JLabel 155, Text alignment 157, Icons and icon alignment 158, GrayFilter 158, The labelFor and the displayedMnemonic properties 158, AbstractButton 158, The ButtonModel interface 159, JButton 159, JToggleButton 161, ButtonGroup 161, JCheckBox and JRadioButton 162, JToolTip and ToolTipManager 163, Labels and buttons with HTML text 163 5.2 Custom buttons, part I: transparent buttons 165 Understanding the code 168, Running the code 170 5.3 Custom buttons, part II: polygonal buttons 171 Understanding the code 176, Running the code 178 5.4 Custom buttons, part III: tooltip management 180 Understanding the code 183, Running the code 186 xiv CONTENTS 6 Tabbed panes 187 6.1 JTabbedPane 187 6.2 A dynamically changeable tabbed pane 189 Understanding the code 195, Running the code 196, Interesting JTabbedPane characteristics 197 6.3 Tab validation 197 Understanding the code 200 7 Scrolling panes 202 7.1 JScrollPane 202 The ScrollPaneConstants interface 204, JViewport 204, ScrollPaneLayout 206, The Scrollable interface 209 7.2 Grab-and-drag scrolling 211 Understanding the code 212 7.3 Scrolling programmatically 213 Understanding the code 217, Running the code 219 8 Split panes 220 8.1 JSplitPane 220 8.2 Basic split pane example 221 Understanding the code 223, Running the code 224 8.3 Synchronized split pane dividers 224 Understanding the code 226, Running the code 226 9 Combo boxes 227 9.1 JComboBox 227 The ComboBoxModel interface 230, The MutableComboBoxModel interface 230, DefaultComboBoxModel 230, The ListCellRenderer interface 231, DefaultListCellRenderer 231, The ComboBoxEditor interface 231 9.2 Basic JComboBox example 232 Understanding the code 237, Running the code 238 9.3 Custom model and renderer 238 Understanding the code 243, Running the code 245 9.4 Combo boxes with memory 246 Understanding the code 250, Running the code 252 9.5 Custom editing 253 Understanding the code 255, Running the code 255 CONTENTS xv 10 List boxes and Spinners 256 10.1 JList 256 The ListModel interface 259, AbstractListModel 259, DefaultListModel 259, The ListSelectionModel interface 259, DefaultListSelectionModel 260, The ListCellRenderer interface 260, The ListDataListener interface 261, ListDataEvent 261, The ListSelectionListener interface 261, ListSelectionEvent 261 10.2 Basic JList example 261 Understanding the code 263, Running the code 263 10.3 Custom rendering 264 Understanding the code 271, Running the code 273 10.4 Processing keyboard input and searching 273 Understanding the code 275, Running the code 276 10.5 List of check boxes 276 Understanding the code 279, Running the code 281 10.6 JSpinner 281 The SpinnerModel interface 282, AbstractSpinnerModel 283 SpinnerDateModel 283, SpinnerListModel 283 SpinnerNumberModel 283 10.7 Using JSpinner to select numbers 283 Understanding the code 284, Running the code 284 10.8 Using JSpinner to select dates 285 Understanding the code 286, Running the code 286 10.9 Using JSpinner to select a value from a list 286 Understanding the code 287, Running the code 287 10.10 Extending the functionality of JSpinner 288 Understanding the code 292, Running the code 1 11 Text components and undo 292 11.1 Text components overview 294 JTextComponent 292, JTextField 294, JPasswordField 298, JTextArea 298, JEditorPane 299, JTextPane 301 11.2 Using the basic text components 304 Understanding the code 305, Running the code 306 11.3 JFormattedTextField 306 JFormattedTextField.AbstractFormatter 307, DefaultFormatter 308, MaskFormatter 308, InternationalFormatter 309, DateFormatter 309, NumberFormatter 309, JFormattedTextField.AbstractFormatterFactory 309, DefaultFormatterFactory 310 11.4 Basic JFormattedTextField example 310 Understanding the code 311, Running the code 311 xvi CONTENTS 11.5 Using Formats and InputVerifier 312 InputVerifier 312, Understanding the code 318 11.6 Formatted Spinner example 319 Understanding the code 320, Running the code 320 11.7 Undo/redo 321 The UndoableEdit interface 321, AbstractUndoableEdit 321, CompoundEdit 324, UndoableEditEvent 325, The UndoableEditListener interface 325, UndoManager 325, The StateEditable interface 328, StateEdit 328, UndoableEditSupport 329, CannotUndoException 329, CannotRedoException 329, Using built-in text component undo/redo functionality 329 12 Menus, toolbars, and actions 332 12.1 Menus, toolbars, and actions overview 332 The SingleSelectionModel interface 332, DefaultSingleSelectionModel 333, JMenuBar 333, JMenuItem 333, JMenu 334, JPopupMenu 335, JSeparator 337, JCheckBoxMenuItem 337, JRadioButtonMenuItem 337, The MenuElement interface 338, MenuSelectionManager 339, The MenuDragMouseListener interface 340, MenuDragMouseEvent 340, The MenuKeyListener interface 340, MenuKeyEvent 340, The MenuListener interface 341, MenuEvent 341, The PopupMenuListener interface 341, PopupMenuEvent 341, JToolBar 341, Custom JToolBar separators 343, Changing JToolBar’s floating frame behavior 344, The Action interface 345, AbstractAction 345 12.2 Basic text editor, part I: menus 346 Understanding the code 353, Running the code 354 12.3 Basic text editor, part II: toolbars and actions 355 Understanding the code 358, Running the code 358 12.4 Basic text editor, part III: custom toolbar components 359 Understanding the code 364, Running the code 366 12.5 Basic text editor, part IV: custom menu components 366 Understanding the code 370, Running the code 371 13 Progress bars, sliders, and scroll bars 373 13.1 Bounded-range components overview 373 The BoundedRangeModel interface 373, DefaultBoundedRangeModel 374, JScrollBar 374, JSlider 375, JProgressBar 377, ProgressMonitor 381, ProgressMonitorInputStream 381 CONTENTS xvii 13.2 Basic JScrollBar example 382 Understanding the code 386, Running the code 387 13.3 JSlider date chooser 387 Understanding the code 391, Running the code 393 13.4 JSliders in a JPEG image editor 394 The JPEGDecodeParam interface 394, The JPEGEncodeParam interface 394, The JPEGImageDecoder interface 395, The JPEGImageEncoder interface 395, JPEGCodec 395, Understanding the code 403, Running the code 405 13.5 JProgressBar in an FTP client application 406 FtpClient 406, Understanding the code 414, Running the code 417 14 Dialogs 418 14.1 Dialogs and choosers overview 418 JDialog 419, JOptionPane 421, JColorChooser 425, The ColorSelectionModel interface 425, DefaultColorSelectionModel 426, AbstractColorChooserPanel 426, ColorChooserComponentFactory 427, JFileChooser 427, FileFilter 430, FileSystemView 431, FileView 431 14.2 Constructing a Login dialog 432 Understanding the code 435, Running the code 436 14.3 Adding an About dialog 436 Understanding the code 438, Running the code 439 14.4 JOptionPane message dialogs 439 Understanding the code 444 14.5 Customizing JColorChooser 445 Understanding the code 449, Running the code 450 14.6 Customizing JFileChooser 451 ZipInputStream 451, ZipOutputStream 451, ZipFile 451, ZipEntry 452, The java.util.jar package 452, Manifest 452, Understanding the code 465, Running the code 468 Part III Advanced topics 469 15 Layered panes 471 15.1 JLayeredPane 473 15.2 Using JLayeredPane to enhance interfaces 473 15.3 Creating a custom MDI 475 xviii CONTENTS 16 Desktops & internal frames 476 16.1 JDesktopPane and JInternalFrame 476 JDesktopPane 476, JInternalFrame 476, JInternalFrame.JDesktopIcon 477, The DesktopManager interface 477, DefaultDesktopManager 479, Capturing internal frame close events 479, The InternalFrameListener interface 480, InternalFrameEvent 480, InternalFrameAdapter 481, Outline dragging mode 481 16.2 Cascading and outline dragging mode 484 Understanding the code 485, Running the code 487 16.3 Adding MDI to a text editor application 487 Understanding the code 494, Running the code 495 16.4 Examples from the first edition 495 17 Trees 498 17.1 JTree 498 Tree concepts and terminology 498, Tree traversal 499, JTree 499, The TreeModel interface 500, DefaultTreeModel 501, The TreeNode interface 501, The MutableTreeNode interface 501, DefaultMutableTreeNode 501, TreePath 502, The TreeCellRenderer interface 502, DefaultTreeCellRenderer 502, CellRenderPane 503, The CellEditor interface 501, The TreeCellEditor interface 504, DefaultCellEditor 504, DefaultTreeCellEditor 504, The RowMapper interface 505, The TreeSelectionModel interface 505, DefaultTreeSelectionModel 506, The TreeModelListener interface 506, The TreeSelectionListener interface 506, The TreeExpansionListener interface 506, The TreeWillExpandListener interface 506, TreeModelEvent 507, TreeSelectionEvent 507, TreeExpansionEvent 507 ExpandVetoException 508, JTree client properties and UI defaults 508, Controlling JTree appearance 508 17.2 Basic JTree example 509 Understanding the code 513, Running the code 514 17.3 Directory tree, part I: dynamic node retrieval 514 Understanding the code 521, Running the code 526 17.4 Directory tree, part II: popup menus, programmatic navigation, node creation, renaming, and deletion 526 Understanding the code 532, Running the code 535 17.5 Directory tree, part III: tooltips 533 Understanding the code 535, Running the code 535 CONTENTS xix 18 Tables 536 18.1 JTable 536 JTable 536, The TableModel interface 538, AbstractTableModel 539, DefaultTableModel 539, TableColumn 539, The TableColumnModel interface 541, DefaultTableColumnModel 542, The TableCellRenderer interface 543, DefaultTableCellRenderer 544, The TableCellEditor interface 544, DefaultCellEditor 545, The TableModelListener interface 545, TableModelEvent 546, The TableColumnModelListener interface 546, TableColumnModelEvent 546, JTableHeader 547, JTable selection 548, Column width and resizing 550, JTable Appearance 551, JTable scrolling 552 18.2 Stocks table, part I: basic JTable example 552 Understanding the code 557, Running the code 559 18.3 Stocks table, part II: custom renderers 559 Understanding the code 563, Running the code 564 18.4 Stocks table, part III: sorting columns 564 Understanding the code 569, Running the code 570 18.5 Stocks table, part IV: JDBC 571 Understanding the code 575, Running the code 576 18.6 Stocks table, part V: column addition and removal 576 Understanding the code 579, Running the code 580 18.7 Expense report application 580 Understanding the code 589, Running the code 591 18.8 Expense report application with variable height rows 591 Understanding the code 594, Running the code 594 18.9 A JavaBeans property editor 595 Understanding the code 601, Running the code 603 19 Inside text components 605 19.1 Text package overview 605 More about JTextComponent 605, The Document interface 608, The StyledDocument interface 608, AbstractDocument 609, The Content interface 612, The Position interface 613, The DocumentEvent interface 613, The DocumentListener interface 614, The Element interface 614, PlainDocument 615, DefaultStyledDocument 617, The AttributeSet interface 620, The MutableAttributeSet interface 622, The Style interface 622, StyleConstants 623, StyleContext 623, The Highlighter interface 624, DefaultHighlighter 625, The Caret interface 625, DefaultCaret 625, The CaretListener interface 627, CaretEvent 627, The Keymap interface 627, TextAction 628, EditorKit 629, DefaultEditorKit 629, StyledEditorKit 630, View 631, The ViewFactory interface 633 xx CONTENTS 20 Constructing an HTML Editor Application 634 20.1 HTML editor, part I: introducing HTML 635 Understanding the code 641, Running the code 642 20.2 HTML editor, part II: managing fonts 642 Understanding the code 648, Running the code 650 20.3 HTML editor, part III: document properties 650 Understanding the code 664, Running the code 667 20.4 HTML editor, part IV: working with HTML styles and tables 667 Understanding the code 676, Running the code 677 20.5 HTML editor, part V: clipboard and undo/redo 677 Understanding the code 681, Running the code 682 20.6 HTML editor, part VI: advanced font management 682 Understanding the code 691, Running the code 694 20.7 HTML editor, part VII: find and replace 695 Understanding the code 704, Running the code 708 20.8 HTML editor, part IX: spell checker (using JDBC and SQL) 708 Understanding the code 718, Running the code 721 21 Pluggable look and feel 723 21.1 Pluggable look and feel overview 723 LookAndFeel 724, UIDefaults 724, UIManager 725, The UIResource interface 725, ComponentUI 726, BasicLookAndFeel 726, How look and feel works 726, Selecting a look and feel 727, Creating a custom LookAndFeel implementation 728, Defining default component resources 729, Defining class defaults 730, Creating custom UI delegates 730, Metal themes 732 21.2 Custom look and feel, part I: using custom resources 733 Understanding the code 740, Running the code 741 21.3 Custom look and feel, part II: creating custom UI delegates 741 Understanding the code 749, Running the code 751 21.4 Examples from the first edition 751 Part IV Special topics 755 22 Printing 757 22.1 Java printing overview 757 PrinterJob 758, The Printable interface 758, The Pageable interface 759, The PrinterGraphics interface 760, PageFormat 760, Paper 761, CONTENTS xxi Book 761, PrinterException 762 22.2 Printing images 762 Understanding the code 765, Running the code 767 22.3 Print preview 767 Understanding the code 773, Running the code 776 22.4 Printing text 776 Understanding the code 780, Running the code 781 22.5 Printing tables 781 Understanding the code 785, Running the code 787 23 Constructing an XML editor 789 23.1 XML editor, part I: viewing nodes 790 Understanding the code 795, Running the code 796 23.2 XML editor, part II: viewing attributes 796 Understanding the code 800, Running the code 801 23.3 XML editor, part III: editing nodes and attributes 801 Understanding the code 807, Running the code 808 23.4 XML editor, part IV: adding, editing, and removing nodes and attributes 808 Understanding the code 817, Running the code 818 23.5 XML editor, part V: custom drag and drop 818 Understanding the code 824 24 Drag and drop 826 24.1 Drag and drop overview 826 The Transferable interface 827, Clipboard 827, The ClipboardOwner interface 827, TransferHandler 828, DropTarget 829, The DropTargetListener interface 830 24.2 Adding drag and drop support within Basic Text Editor 830 Understanding the code 832, Running the code 832 24.3 Drag and drop files to Base Text Editor 832 Understanding the code 834, Running the code 834 24.4 Drag and drop with Java objects 834 Understanding the code 841, Running the code 843 A Java Web Start 845 B Resources 849 index 853

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

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

scripting in java-languages-frameworks-and-patterns

国外经典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

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

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.

Part I First Steps with MySQL Chapter 1: Introduction to MySQL ..................................................................................................3 Chapter 2: Installing and Upgrading MySQL Server .......................................................................9 Chapter 3: Accessing MySQL ..........................................................................................................49 Part II Developing with MySQL Chapter 4: How MySQL Extends and Deviates from SQL ............................................................87 Chapter 5: MySQL Data Types .....................................................................................................159 Chapter 6: MySQL Index Types ...................................................................................................219 Chapter 7: Stored Routines, Triggers, and Events .......................................................................241 Chapter 8: MySQL Views ..............................................................................................................301 Chapter 9: Transactions in MySQL ..............................................................................................319 Part III Core MySQL Administration Chapter 10: MySQL Server Tuning ..............................................................................................349 Chapter 11: Storage Engines .........................................................................................................375 Chapter 12: Caching with MySQL ...............................................................................................423 Chapter 13: Backups and Recovery ..............................................................................................439 Chapter 14: User Management .....................................................................................................473 Chapter 15: Partitioning ................................................................................................................495 Chapter 16: Logging and Replication ...........................................................................................517 Chapter 17: Measuring Performance ............................................................................................545 Part IV Extending Your Skills Chapter 18: Query Analysis and Index Tuning ...........................................................................589 Chapter 19: Monitoring Your Systems .........................................................................................633 Chapter 20: Securing MySQL .......................................................................................................649 Chapter 21: The MySQL Data Dictionary ....................................................................................667 Chapter 22: Scaling and High Availability Architectures .............................................................727 Appendix A: MySQL Proxy ...........................................................................................................749 Appendix B: Functions and Operators .........................................................................................783 Appendix C: Resources .................................................................................................................813

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

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

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

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

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

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

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

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

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

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

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

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

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

中国移动BOSS业务规范（正式版），java

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

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

数据结构 算法 C语言 JAVA

IE错误窗口

JBuilder程序设计实例