Trending on TikTok

Sanrio

Sriracha

  • Search History
  • Trending
Shop Departments
Japan
Korea
Greater China
Best Sellers
New Arrivals
Sale
Gift Cards
Community
More
Sign in / Sign up

English

English 简体中文 繁體中文 한국어 日本語
{{sellerTotalView > 1 ? __("sellers", {number: sellerTotalView}) : __("seller", {number: sellerTotalView}) }}, {{numTotalView > 1 ? __("items", {number: numTotalView}) : __("item", {number: numTotalView}) }}
free FREE

View Cart & Check Out Yamibuy
Yami

Nickname

Let us know how to properly address you.

Update Your Name
Account Orders Favorites
Points 0
Coupons 0
Gift Card Balance $0.00
{{ inviteNavTitle }}
Sign Out

Change Your Zip Code

Inventory information and delivery speeds may vary for different locations.

Location History

{{email ? __('Got it!') : __('Restock Alert')}}

We will notify you by email when the item back in stock.

Cancel
Yami

Jingdong book

MySQL技术内幕（第5版）

View Cart & Check Out Yamibuy
{{buttonTypePin == 3 ? __("Scan to view more PinGo") : __("Scan to start")}}
Books Computers & Internet Database
Jingdong book

MySQL技术内幕（第5版）

{{__(":people-members", {'people': item.limit_people_count})}} {{ itemCurrency }}{{ item.valid_price }} {{ itemCurrency }}{{ item.invalid_price }} {{ itemDiscount }}
Ends in
{{ itemCurrency }}{{ item.valid_price }}
{{ itemCurrency }}{{ priceFormat(item.valid_price / item.bundle_specification) }}/{{ item.unit }}
{{ itemDiscount }}
{{ itemCurrency }}{{ item.valid_price }} {{ itemCurrency }}{{ priceFormat(item.valid_price / item.bundle_specification) }}/{{ item.unit }} {{ itemCurrency }}{{ item.invalid_price }} {{itemDiscount}}
{{ itemCurrency }}{{ item.valid_price }}
Sale ends in
Sale will starts after Sale ends in
{{ getSeckillDesc(item.seckill_data) }}
{{ __( "Pay with Gift Card to get sale price: :itemCurrency:price", { 'itemCurrency' : itemCurrency, 'price' : (item.giftcard_price ? priceFormat(item.giftcard_price) : '0.00') } ) }} ({{ itemCurrency }}{{ priceFormat(item.giftcard_price / item.bundle_specification) }}/{{ item.unit }}) Details
Best before

Currently unavailable.

We don't know when or if this item will be back in stock.

Unavailable in your area.
Sold Out

Details

Full product details
Content Description

《MySQL技术内幕（第5版）》是MySQL方面名副其实的经典著作，全面介绍MySQL的基础知识以及MySQL有别于其他数据库系统的独特功能，书中特别关注如何高效地使用和管理MySQL。
《MySQL技术内幕（第5版）》由4个部分组成：第一部分集中介绍与数据库使用相关的一些基本概念，第二部分重点关注的是自己如何动手编写和使用MySQL的程序，第三部分主要是面向那些负责数据库管理的读者，第四部分提供了一些参考附录。书中包含大量示例，详尽地演示了MySQL的各项功能特性。此外，本书还为使用C语言、PHP语言和Perl语言开发数据库应用的读者提供了相关内容。
《MySQL技术内幕（第5版）》不仅适合MySQL初学者阅读，也适合想要深入了解MySQL的数据库管理人员和开发人员参考。
Author Description

Paul DuBois是作家，数据库管理员，也是开源社区和MySQL社区的领导者。他为MySQL在线文档做出了很大贡献，其著作包括MySQL and Perl for the Web、MySQL Cookbook、Using csh and tcsh和Software Portability with imake。目前，他是Oracle公司MySQL文档团队的一名技术作家。
Catalogue

目录

第1章MySQL入门 1
1．1MySQL的用途 1
1．2示例数据库 3
1．2．1美史联盟项目 4
1．2．2成绩考评项目 5
1．2．3如何运用示例数据库 5
1．3基本数据库术语 6
1．3．1结构术语 6
1．3．2查询语言术语 8
1．3．3MySQL的体系结构术语 8
1．4MySQL教程 9
1．4．1获取示例数据库发行包 10
1．4．2基本配置要求 10
1．4．3建立和断开MySQL服务器连接 11
1．4．4执行SQL语句 13
1．4．5创建数据库 15
1．4．6创建表 15
1．4．7添加新行 29
1．4．8重置sampdb数据库 32
1．4．9检索信息 33
1．4．10删除或更新已有行 56
1．5mysql交互技巧 58
1．5．1简化连接过程 58
1．5．2在调用命令时减少打字输入 60
1．6何去何从 63
第2章使用SQL管理数据 64
2．1服务器的SQL模式 65
2．2MySQL的标识符语法和命名规则 66
2．3SQL语句的大小写规则 67
2．4字符集支持 68
2．4．1指定字符集 69
2．4．2确定可用字符集和当前设置 70
2．4．3Unicode支持 71
2．5数据库的选择、创建、删除和更改 72
2．5．1选择数据库 72
2．5．2创建数据库 72
2．5．3删除数据库 73
2．5．4更改数据库 73
2．6表的创建、删除、索引和更改 73
2．6．1存储引擎的特性 73
2．6．2创建表 77
2．6．3删除表 84
2．6．4索引表 84
2．6．5更改表结构 88
2．7获取数据库元数据 90
2．7．1使用SHOW语句获取元数据 90
2．7．2借助INFORMATION_SCHEMA获取元数据 92
2．7．3从命令行获取元数据 94
2．8使用连接实现多表检索 95
2．8．1内连接 96
2．8．2对被连接表里的列引用进行限定 97
2．8．3左（外）连接和右（外）连接 97
2．9使用子查询实现多表检索 100
2．9．1带关系比较运算符的子查询 101
2．9．2IN和NOT IN子查询 102
2．9．3ALL、ANY和SOME子查询 103
2．9．4EXISTS和NOT EXISTS子查询 103
2．9．5相关子查询 104
2．9．6FROM子句里的子查询 104
2．9．7将子查询改写为连接 104
2．10使用UNION实现多表检索 106
2．11多表删除和更新 108
2．12事务处理 110
2．12．1利用事务保证语句安全执行 111
2．12．2使用事务保存点 114
2．12．3事务隔离 114
2．13外键和引用完整性 116
2．14使用FULLTEXT搜索 121
2．14．1自然语言FULLTEXT搜索 122
2．14．2布尔模式的全文搜索 124
2．14．3查询扩展全文搜索 125
2．14．4配置全文搜索引擎 126
第3章数据类型 127
3．1数据值类别 128
3．1．1数值 128
3．1．2字符串值 129
3．1．3时态（日期/时间）值 136
3．1．4空间值 136
3．1．5布尔值 136
3．1．6NULL值 136
3．2MySQL数据类型 137
3．2．1数据类型概述 137
3．2．2表定义里的特殊列类型 138
3．2．3指定列的默认值 139
3．2．4数字数据类型 140
3．2．5字符串数据类型 145
3．2．6时态（日期/时间）数据类型 156
3．3MySQL如何处理效数据值 163
3．4处理序列 164
3．4．1通用的AUTO_INCREMENT属性 164
3．4．2存储引擎特有的AUTO_INCREMENT属性 166
3．4．3使用AUTO_INCREMENT列需要考虑的问题 168
3．4．4AUTO_INCREMENT列的使用提示 168
3．4．5在AUTO_INCREMENT的情况下生成序列 170
3．5表达式计算和类型转换 171
3．5．1编写表达式 172
3．5．2类型转换 177
3．6选择数据类型 183
3．6．1列要存放什么类型的值 184
3．6．2所有值是否都在某个特定的区间内 186
第4章 视图和存储程序 188
4．1使用视图 189
4．2使用存储程序 191
4．2．1复合语句和语句分隔符 191
4．2．2存储函数和存储过程 193
4．2．3触发器 196
4．2．4事件 197
4．3视图和存储程序的安全性 199
第5章 查询优化 200
5．1使用索引 200
5．1．1索引的优点 201
5．1．2索引的代价 203
5．1．3挑选索引 203
5．2MySQL查询优化程序 206
5．2．1查询优化程序的工作原理 207
5．2．2使用EXPLAIN检查优化程序的操作 209
5．3选择利于高效查询的数据类型 214
5．4选择利于高效查询的表存储格式 216
5．5高效加载数据 217
5．6调度、锁定和并发 219
第6章 MySQL程序设计入门 221
6．1为何要自己编写MySQL程序 221
6．2MySQL提供的API 223
6．2．1C语言API 224
6．2．2Perl语言DBI API 224
6．2．3PHP语言API 225
6．3选择API 226
6．3．1执行环境 227
6．3．2性能 227
6．3．3开发时间 228
6．3．4可移植性 228
第7章 用C语言编写MySQL程序 230
7．1编译和链接客户端程序 231
7．2连接服务器 233
7．3出错处理和命令选项处理 236
7．3．1出错检查 236
7．3．2实时获取连接参数 239
7．3．3把选项处理整合进客户端程序 248
7．4处理SQL语句 252
7．4．1处理那些修改行的语句 253
7．4．2处理那些返回结果集的语句 254
7．4．3通用的语句处理器 256
7．4．4另一种语句处理方法 257
7．4．5mysql_store_result()与mysql_use_result()的对比 258
7．4．6使用结果集元数据 260
7．4．7对特殊字符和二进制数据进行编码 264
7．5交互式语句执行程序 267
7．6编写支持SSL的客户端程序 268
7．7一次执行多条语句 272
7．8使用服务器端预处理语句 273
7．9使用预处理CALL支持 282
第8章 用Perl DBI编写MySQL程序 286
8．1Perl脚本的特点 286
8．2Perl DBI概述 287
8．2．1DBI数据类型 287
8．2．2一个简单的DBI脚本 288
8．2．3出错处理 291
8．2．4处理那些修改行的语句 294
8．2．5处理那些返回结果集的语句 295
8．2．6在语句串里引用特殊字符 302
8．2．7占位符与预处理语句 305
8．2．8把查询结果绑定到脚本变量 307
8．2．9指定连接参数 307
8．2．10调试 310
8．2．11使用结果集元数据 312
8．2．12执行事务 316
8．3DBI脚本实践 317
8．3．1生成美史联盟成员名录 317
8．3．2发送成员资格更新通知 322
8．3．3编辑美史联盟成员条目 326
8．3．4寻找志趣相投的联盟成员 331
8．3．5把美史联盟成员名录放到网上 332
8．4使用DBI来开发Web应用程序 334
8．4．1配置Apache服务器来处理CGI脚本 335
8．4．2CGI．pm模块简介 336
8．4．3从Web脚本连接MySQL服务器 342
8．4．4基于Web的数据库浏览器 343
8．4．5成绩考评项目：分数浏览器 347
8．4．6美史联盟：搜索志趣相投的成员 350
第9章 用PHP语言编写MySQL程序 354
9．1PHP概述 355
9．1．1一个简单的PHP脚本 357
9．1．2利用PHP库文件实现代码封装 359
9．1．3简单的数据检索页面 363
9．1．4处理语句结果 365
9．1．5测试查询结果里的NULL值 368
9．1．6使用预处理语句 369
9．1．7利用占位符来处理数据引号问题 369
9．1．8出错处理 371
9．2PHP脚本实战 372
9．2．1一个在线录入分数的应用程序 373
9．2．2创建交互式的在线测验 382
9．2．3在线编辑美史联盟成员信息 386
第10章MySQL管理简介 393
10．1MySQL组件 393
10．2MySQL的常规管理 3

Specifications

Brand Jingdong book
Brand Origin China

Disclaimer

Product packaging, specifications and price are subject to change without notice. All information about the products on our website is provided for information purposes only. Please always read labels, warnings and directions provided with the product before use.

View Full Terms of Use
Add to favorites
{{ $isZh ? coupon.coupon_name_sub : coupon.coupon_ename_sub | formatCurrency }}
Clip coupons
{{__("Buy Directly")}} {{ itemCurrency }}{{ item.directly_price }}
Quantity
{{ quantity }}
{{ instockMsg }}
{{ limitText }}
{{buttonTypePin == 3 ? __("Scan to view more PinGo") : __("Scan to start")}}
Sold by JD@CHINA
Ship to
{{ __("Ship to United States only") }}
Free shipping over 69
Genuine guarantee
View details
Region

{{ regionInfo.title }}

Added to Cart

Keep Shopping

More to Consider

{{ item.brand_name }}

{{ item.item_name }}

{{ item.currency }}{{ item.market_price }}

{{ item.currency }}{{ item.unit_price }}

{{ item.currency }}{{ item.unit_price }}

Coupons

{{ coupon.coupon_name_new | formatCurrency }}
Clip Clipped Over
{{ getCouponDescStr(coupon) }}
{{ coupon.use_time_desc }}
Expires soon {{ formatTime(coupon.use_end_time) }}

Share this item with friends

Cancel

Yami Gift Card

Get this exclusive deal when paying with gift card

Terms and Conditions

Gift card deals are special offers for selected products;

The gift card deals will automatically be activated if a customer uses gift card balance at check out and the balance is sufficient to pay for the total price of the shopping cart products with gift card deals;

You will not be able to activate the gift card deals if you choose other payment methods besides gift card. The products will be purchased at their normal prices;

If your account balance is not enough to pay for the products with gift card deals, you can choose to reload your gift card balance by clicking on the Reload button at either shopping cart page or check out page;

Products that have gift card deals can be recognized by a special symbol showing 'GC Deal';

For any additional questions or concerns, please contact our customer service;

Yamibuy reserves the right of final interpretation.

Sold by Yami

Service Guarantee

Yami Free Shipping over $49
Yami Easy Returns
Yami Ships from United States

Shipping

  • United States

    Standard Shipping is $5.99 (Excluding Alaska & Hawaii). Free on orders of $49 or more.

    Local Express is $5.99 (Available in Parts of CA, NJ, MA & PA). Free on orders of $49 or more.

    2-Day Express (Includes Alaska & Hawaii) starts at $19.99.

Return Policy

Yami is committed to provide our customers with a peace of mind when purchasing from us. Most items shipped from Yamibuy.com can be returned within 30 days of receipt of shipment (For Food, Beverages, Snacks, Dry Goods, Health supplements, Fresh Grocery and Perishables Goods, within 7 days of receipt of shipment due to damages or quality issues; To ensure that every customer receives safe and high-quality products, we do not provide refunds or returns for beauty products once they have been opened or used, except in the case of quality issues; Some products may have different policies or requirements associated with them, please see below for products under special categories, or contact Yami Customer Service for further assistance).
Thank you for your understanding and support.

Learn More

Sold by Yami

Terms and Conditions of Yami E-Gift Card

If you choose “Redeem automatically” as your delivery method, your gift card balance will be reload automatically after your order has been processed successfully;

If you choose “Send to Email”as your delivery method, the card number and CVV will be sent to the email address automatically;

Any user can use the card number and CVV to redeem the gift card, please keep your gift card information safely. If you have any trouble receiving email, please contact Yami customer service;

Yami gift card can be used to purchase both Yami owned or Marketplace products;

Yami gift card will never expire;

Yami gift card balance does not have to be used up at once;

All rights reserved by Yami.

Return Policy

Gift card that has already been consumed is non-refundable.

Sold by JD@CHINA

Service Guarantee

Yami Free Shipping over $49
Yami Easy Returns
Yami Ships from United States

Shipping

  • United States

    Standard Shipping is $5.99 (Excluding Alaska & Hawaii). Free on orders of $49 or more.

    Local Express is $5.99 (Available in Parts of CA, NJ, MA & PA). Free on orders of $49 or more.

    2-Day Express (Includes Alaska & Hawaii) starts at $19.99.

Return Policy

You may return product within 30 days upon receiving the product. Items returned must be new in it's original packing, including the original invoice for the purchase. Customer return product at their own expense.

Sold by JD@CHINA

Service Guarantee

Yami Cross-store Free Shipping over $69
Yami 30-days Return

Yami-China FC

Yami has a consolidation warehouse in China which collects multiple sellers’ packages and combines to one order. Our Yami consolidation warehouse will directly ship the packages to your door. Cross-store free shipping over $69.

Return Policy

You may return products within 30 days upon receiving the products. Sellers take responsibilities for any wrong shipment or missing items. Packing needs to be unopened for any other than quality issues return. We promise to pack carefully, but because goods are taking long journey to destinations, simple damages to packaging may occur. Any damages not causing internal goods quality problems are not allowed to return. If you open the package and any quality problem is found, please contact customer service within three days after receipt of goods.

Shipping Information

Yami Consolidation Service Shipping Fee $9.99(Free shipping over $69)

Sellers in China will ship their orders within 1-2 business days once the order is placed. Packages are sent to our consolidation warehouse in China and combined there. Our Yami consolidation warehouse will directly ship the packages to you via UPS. The average time for UPS to ship from China to the United States is about 10 working days and it can be traced using the tracking number. Due to the pandemic, the delivery time may be delayed by about 5 days. The package needs to be signed by the guest. If the receipt is not signed, the customer shall bear the risk of loss of the package.

Sold by JD@CHINA

Service Guarantee

Free shipping over 69
Genuine guarantee

Shipping

Yami Consolidated Shipping $9.99(Free shipping over $69)


Seller will ship the orders within 1-2 business days. The logistics time limit is expected to be 7-15 working days. In case of customs clearance, the delivery time will be extended by 3-7 days. The final receipt date is subject to the information of the postal company.

Yami Points information

All items are excluding from any promotion or points events on Yamibuy.com

Return Policy

You may return product within 30 days upon receiving the product. Items returned must be new in it's original packing, including the original invoice for the purchase. Customer return product at their own expense.

Yami

Download the Yami App

Back Top

Recommended for You

About the brand

Jingdong book

为您推荐

Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g
144

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g
144

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g
144

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g
144

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g
144

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g
144

周销量 600+

$1.66 $1.99 83折

Reviews{{'('+ commentList.posts_count + ')'}}

Have your say. Be the first to help other guests.

Write a review
{{ totalRating }} Write a review

  • {{i}} star

    {{i}} stars

    {{ parseInt(commentRatingList[i]) }}%

Yami Yami
{{ comment.user_name }}

{{ showTranslate(comment) }}Show Less

{{ strLimit(comment,800) }}Show more

Show Original

{{ comment.content }}

Yami
Show All

{{ formatTime(comment.in_dtm) }} VERIFIED PURCHASE {{groupData}}

{{ comment.likes_count }} {{ comment.likes_count }} {{ comment.reply_count }} {{comment.in_user==uid ? __('Delete') : __('Report')}}
Yami Yami
{{ comment.user_name }}

{{ showTranslate(comment) }}Show Less

{{ strLimit(comment,800) }}Show more

Show Original

{{ comment.content }}

Yami
Show All

{{ formatTime(comment.in_dtm) }} VERIFIED PURCHASE {{groupData}}

{{ comment.likes_count }} {{ comment.likes_count }} {{ comment.reply_count }} {{comment.in_user==uid ? __('Delete') : __('Report')}}

No related comment~

Load more reviews

Review

Yami Yami

{{commentDetails.user_name}}

{{ showTranslate(commentDetails) }}Show Less

{{ strLimit(commentDetails,800) }}Show more

Show Original

{{ commentDetails.content }}

Yami
Show All

{{ formatTime(commentDetails.in_dtm) }} VERIFIED PURCHASE {{groupData}}

{{ commentDetails.likes_count }} {{ commentDetails.likes_count }} {{ commentDetails.reply_count }} {{commentDetails.in_user==uid ? __('Delete') : __('Report')}}

Please write at least one word

Comments{{'(' + replyList.length + ')'}}

Yami Yami

{{ reply.reply_user_name }}reply to{{ reply.parent_user_name }}

{{ showTranslate(reply) }}Show Less

{{ strLimit(reply,800) }}Show more

Show Original

{{ reply.reply_content }}

{{ formatTime(reply.reply_in_dtm) }}

{{ reply.reply_likes_count }} {{ reply.reply_likes_count }} {{ reply.reply_reply_count }} {{reply.reply_in_user==uid ? __('Delete') : __('Report')}}

Please write at least one word

Cancel

That’s all the comments so far!

Write a review
How would you rate this item?

Please add your comment.

  • A nice nickname will make your comments more popular!
  • The nickname in your account will be changed to the same as here.
Thanks for your review
Our community rely on great reviews like yours to find the best of Asia.

Report

If you find this content inappropriate and think it should be removed from the Yami.com site, let us know please.

Cancel

Are you sure to delete your review?

Cancel

You’ve Recently Viewed

About the brand

Jingdong book