简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

Linux平台下MySQL命令操作

WBOY
Release： 2016-06-07 17:05:49
Original
1177 people have browsed it

Linux shell 批量创建数据库/表 Shell 脚本如下： # create database and table HOST=

Linux shell 批量创建数据库/表

Shell 脚本如下：

执行脚本后，结果如下：



MySQL 从常用操作命令：

显示数据库

show databases;

切换数据库
use top123;

显示数据库表

show tables;

修改主键

alter table gametop800 add primary key(id);

删除主键

alter table gametop800 drop primary key;

添加组合主键

alter table gametop800 add primary key(id, dtime);


如果感兴趣的话，可以深入综合运用awk，cut，paste，正则表达式，数据库操作等较为复杂的语法，完成MySQL数据库操作

下面是实现了一个抓取网页，，提取特征，抽取信息，结果汇总，批量插入数据库永久保存

示例：

linux

Related labels：
database
source：php.cn
Previous article：一个完整的Oracle建表的例子 Next article：查看Oracle数据库表被锁例子故障定位
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Regular expression filter for MERN stack search boxes and checkboxes I'm trying to understand how the MERN stack works together by learning by doing, and I'm f...
From 2024-04-06 14:53:12
0
1
425
MySQL procedure skips latest records I have the following three tables; hm_deliverylog+---------------------+------------------...
From 2024-04-04 00:07:19
0
1
360
Prestashop installation issue: Unable to install custom module I am new to Prestashop module development. I'm trying to build Amy's first prestashop modu...
From 2024-04-03 19:24:44
0
1
402
PHP Tutorial: How to upload text and images to Linkedin using PHP? I try to upload text, images and links using LinkedinsRestAPI (https://learn.microsoft.com...
From 2024-04-03 18:42:29
0
1
420
Unable to receive information from my mySQL database despite having seen tutorials doing the exact same thing So I'm trying to make a program that reads and writes to a MySQL database, which led me to...
From 2024-04-03 14:46:04
0
1
298
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！