MySQL随手记录

最新推荐文章于 2023-02-22 15:42:43 发布

原创最新推荐文章于 2023-02-22 15:42:43 发布 · 292 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#MySql #学习笔记

数据库专栏收录该内容

2 篇文章

订阅专栏

这篇博客详细记录了MySQL的登录、创建数据库、删除数据库、创建用户及授权等基本操作，还提到了如何修改字段长度。此外，内容中还穿插介绍了MarkdownPad 2编辑器的特性，如LivePreview实时预览功能和高度定制化的编辑体验。

1.登录

mysql -h host_name -u user_name -p

-h 目标主机提示符（主机名或IP地址.ps:主机名我测试没有成功，网上有人说主机名可以。）
-u 表示用户名标识符
-p 密码提示符

2.创建数据库

.删除数据库

DROP DATABASE `database_name`;

3.创建用户

4.授权

修改root用户，禁止远程登录

GRANT ALL PRIVILEGES ON *.* TO root@"localhost";

5. 常用操作

5.1 修改字段长度

ALTER TABLE `table_name` MODIFY COLUMN `filed_name` VARCHAR(`new_length_value`);


public class test{

    public static void main(String [] args){

    }

}

Welcome to MarkdownPad 2

MarkdownPad is a full-featured Markdown editor for Windows.

Built exclusively for Markdown

Enjoy first-class Markdown support with easy access to Markdown syntax and convenient keyboard shortcuts.

Give them a try:

Bold (Ctrl+B) and Italic (Ctrl+I)
Quotes (Ctrl+Q)
Code blocks (Ctrl+K)
Headings 1, 2, 3 (Ctrl+1, Ctrl+2, Ctrl+3)
Lists (Ctrl+U and Ctrl+Shift+O)

See your changes instantly with LivePreview

Don’t guess if your hyperlink syntax is correct; LivePreview will show you exactly what your document looks like every time you press a key.

Make it your own

Fonts, color schemes, layouts and stylesheets are all 100% customizable so you can turn MarkdownPad into your perfect editor.

A robust editor for advanced Markdown users

MarkdownPad supports multiple Markdown processing engines, including standard Markdown, Markdown Extra (with Table support) and GitHub Flavored Markdown.

With a tabbed document interface, PDF export, a built-in image uploader, session management, spell check, auto-save, syntax highlighting and a built-in CSS management interface, there’s no limit to what you can do with MarkdownPad.