MySQL随手记录

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.