`

MySQL BASIC COMMAND

MySQLSQL数据结构 
阅读更多

1 come into mysql control:mysql -uname -ppassword;Enter

2 \h; show help

3 use databsename;change database

4 show databases;show all databases

   after selected db;entry show tables; view all tables' name

5 after use db;entry desc tablename;could show this table's structure(结构)

6 show variables like '%char%';view all character set

7 show variables like 'collation%';view mysql order(or collation);

8 show binlog events;show log-bin is work or not?

9 数据库备份，如果在path中配置了mysql-bin的变量，就直接在cmd中录入（否则需要运行到bin目录下再录）：

   mysqldump -uroot -proot dbname > d:\temp\0622.sql Enter

分享到：
| MySQL数据库乱码
评论
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

    MySQL ConnectorPython Revealed SQL and NoSQL Data Storage

    The X DevAPI is part of MySQL 8.0 and is an API that can be used with connectors for several programming languages and is used from the command-line interface known as MySQL Shell. You will learn to ...

    Basic_basket

    一个最基本的购物篮的Class 需要mysql_db类的支持(mysql_conn,mysql_db,mysql_recordset,mysql_command)并且需要cookies的支持.

    mysql commands

    Rational Rose是由美国的Rational公司开发的、面向对象的可视化建模工具。利用Rose工具，可以建立用UML描述的软件系统模型，它支持...而且通过其正向和逆向转出工程代码的特性，可以支持C++、Java、Visual Basic和XML

    PHP and MySQL Web Devepopment 4th Edition.pdf

    As you can see in the figure above, the DCDIAG command’s basic syntax looks like this: dcdiag.exe /s:[:] [/u:<Domain>\ /p:*||""] [/hqv] [/n:] [/f:] [/x:XMLLog.xml] [/skip:] [/test:] Although the ...

    Total Commander（TC）的CudaLister插件（32位和64位），含223个语法高亮文件，可预览大量文本文件类扩展名

    MySQL_Stored_Procedures.lcf MacroScript_(Macro_Sheduler).lcf JCL.lcf Gold_Parser.lcf Adobe_Flash.lcf XSLT.lcf VHDL.lcf T-SQL.lcf Smalltalk.lcf Rexx.lcf PL_SQL.lcf Modula 2.lcf KiXtart.lcf ...

    轻量级办公平台Sandbox.zip

    $ docker cp db_tools/data/basic_data.sql gistandard_mysql_1:/tmp $ docker-compose exec mysql bash $ mysql -uddadmin -p1234@abcd.com gistandard < /tmp/basic_data.sql 5、访问系统： http://your_ip ...

    Foundations for Analytics with Python O-Reilly-2016-Clinton W. Brownley

    If you don’t already have MySQL on your computer, the first step is to download and install MySQL. From there, the examples mirror the sqlite3 examples, including creating a database and table, ...

    Getting Started with MariaDB

    It is assumed that you have basic knowledge of software installation, editing files with a text editor, and using the command line and terminal. Product Details Paperback: 100 pages Publisher: Packt...

    drupal 6.12

    create tables, add the first user account and provide basic web site settings. The install script will attempt to create a files storage directory in the default location at sites/default/files ...

    stanford tagger

    The package includes components for command-line invocation, running as a server, and a Java API. The tagger code is dual licensed (in a similar manner to MySQL, etc.). Open source licensing is under...

    CakePHP 1.3 Application Development Cookbook.pdf

    A database engine supported by CakePHP (such as MySQL) f CakePHP installed, configured, and working properly Who this book is for If you are a CakePHP developer who wants to discover quick and easy ...

    php_6_fast_and_easy_web_development.pdf

    Basic MySQL Reference. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 513 Creating or Dropping a Database. . . . . . . . . . . . . . . . . . . . . . 514 Creating or Dropping a Table. . ...

    go系统编程(英文版)

    and MySQL databases using Go code. Then, it illustrates how to use the html/template package, which is part of the Go standard library and allows you to generate HTML output using Go ...

    Beginning Python (2005).pdf

    Try It Out: Using Basic OpenLDAP Tools 449 Try It Out: Simple LDAP Search 451 More LDAP 453 Back to the wftk 453 Try It Out: Simple Workflow Trigger 454 Try It Out: Action Queue Handler 456 ...

    VB编程资源大全（英文源码 数据库）

    1 , datafile.zip "This sample demonstrates how to do file input and output using Visual Basic. The sample creates a new database file and allows you to view, add, or delete records in this database...

    Laraboot: Laravel 5 For Beginners

    Command Console . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 ...

    .htaccess

    <br>To prevent against this (without creating lots of new 'index' files, you can enter a command into your .htaccess file to stop the directory list from being shown: 为避免这种情况（而不必创建...

    asp.net知识库

    在.NET访问MySql数据库时的几点经验！ 自动代码生成器 关于能自定义格式的、支持多语言的、支持多数据库的代码生成器的想法 发布Oracle存储过程包c#代码生成工具(CodeRobot) New Folder XCodeFactory3.0完全攻略－－...

Magicbox
Global site tag (gtag.js) - Google Analytics