view all tables

Create user and specify password:CREATE USER readonly with ENCRYPTED PASSWORD ' Ropass ';Set user default transaction read-only:Alter user readonly set Default_transaction_read_only=on;Give the user permission to view all tables in public mode:GRANT

MySQL Database service operations# Systemctl Start mysqld//Start# Systemctl Stop mysqld//stop# Systemctl Restall mysqld//restartLog in to MySQL database with a password# mysql-uroot-p ' Initialized random password 'Set User Native login

I. Introduction to Phoenix 1. What is Phoenix?There are many query tools for hbase such as: Hive,tez,impala,shark/spark,phoenix, etc. Today is mainly about Phoenix. Phoenix is a Hadoop-based OLTP technology implemented on HBase that features low

Create a database Create database name [library option]; Create a database create database mydatas charset utf8; View Database show databases; If you need Chinese set names gbk; View

MySQL Overview: MySQL is a relational database management system, the so-called Association database is to keep the data in different tables, rather than put all the data in a large warehouse. This increases speed and increases flexibility. and

MySQL database is a common relational databaseWhat are the core elements of a relational database?Primary key: Special field to uniquely identify the uniqueness of a recordFields: Data columnsRecords: Data rowsData table: Collection of data

1. First download HBase Download Address: hbase1.3.1-bin.tar.gz Unzip to any directory, for example mine is/opt/hbase-1.3.1 and configure environment variables for HBase 2. Configure HBase cd/opt/hbase-1.3.1/conf/ 2.1. Modify Hbase-env.sh sudo vim

1.1 SQL Overview 1.1.1 SQL statement IntroductionStructured Query Language (structured query Language) is referred to as SQL, which is the specification that the relational database management system should follow. Different database Manufacturers

1th Chapter  mysql User Management:1.1  user's definition:   user name + host domain   mysql> select user,host,password  from mysql.user;+------+-----------+----------+| user | host       | password |+------+-----------+----------+| root | localhost 

1 Common commands 1 Sqlplus Scott/[email PROTECTED]:1521/ORCL The back not add ; Sqlplus sys/oracle as SYSDBA "Password Authentication" Sqlplus User name arbitrary/password any as SYSDBA

First, download the relevant compression package to the official websiteHttps://www.sqlite.org/download.htmlBut to recompile one yourself, Bo master himself collected a bit, password: hixoHttps://pan.baidu.com/s/1Zdp0UMl2Mr4J2JUe28G7JQPut the

--01 MySQL database operation --Link DatabaseMysql-uroot-pmysql--Don't show password * * * *Mysql-uroot-p--Exit the databaseQuit/exit Ctrl+d--The SQL statement needs a semicolon at the end;--Show database version versionsSelect version ();--Show

I. Introduction of the TableTable is equivalent to a file, a record in the table is equivalent to a row of the file, but a record in the table has a corresponding title, called the table fieldSecond, create a table1. Basic grammarSyntax:CREATE TABLE

MySQL Common terminal commands--Link DatabaseMysql-uroot-pmysql--Don't show password * * * *Mysql-uroot-pPassword--Exit the databaseQuit/exit/ctrl + DExit (Remember this) * * * * *Quit/exit Ctrl+d--The SQL statement needs a semicolon at the

MySQL database Advanced (iii)--view One, view introduction 1, Introduction to the ViewA view is a virtual table defined by a SELECT query statement and is a very efficient way to view the data. A view contains a series of data columns and rows with

Some MongoDB learning related knowledge, recorded so that the next time to view the useReference:

5 Table Management Select Database5.1 View all tables Mysql> Show tables;+-----------------+| TABLES_IN_DAY15 |+-----------------+| Student |+-----------------+1 row in Set (0.00 sec) 5.2 Creating a table

Basic operations of the database1. Create a database# CREATE DATABASE xxx;2. View the database# show databases;3. Deleting a database# drop database xxx;4. Using/Switching databases# Use XXX;Basic operation of the table1. View all tables in the

1. Displays the names of all databases in MySQL, show databases;2. Access a database, user database_name;3. Displays the names of all the tables in the current database, show tables;4. View the current Data warehouse, select Database ();5. View all

View all databasesshow databases;Working with databasesUse database name;View the database currently in useSelect Database ();Create a databaseCreate database name Charset=utf8;Cases:Create Database Python Charset=utf8;Deleting a databasedrop