desc table

Basic MySQL operationsReprinted please indicate Source: http://blog.csdn.net/u012637501 (embedded _ small J of the sky)I. Create a MySQL database1. Create a database and a table■ Create database statement: create database [database name]; ■ database

SQL> show all -- View all 68 system variable values SQL> show user -- display the current connected user SQL> show error -- Display error SQL> set heading off -- disable the output column title. The default value is ON. SQL> set feedback off --

Install Oracle 11g in RedHat Linux 6.0 Steps for installing Oracle in Linux Preparations before installation Transmit oracle to the root directory through ssh (this installation is under VMware) Installation Package for Linux for Oracle 11g RedHat 6.

Mysql 5.6.17 Green Edition (Installation-free) installation and configuration tutorial, 5.6.17 installation and configuration tutorial I recently used the MySql database for project development. After reading some articles about MySql, I quickly

Mysql installation directoryDatabase directory/Var/lib/mysql/Configuration File/Usr/share/mysql (mysql. server command and configuration file)Related commands/Usr/bin (commands such as mysqladmin mysqldump)Start script/Etc/init. d/mysql (directory

Mysql database optimization summary and mysql database Summary I. Common Database optimization operations 1. The table design must conform to the three paradigm. 2. Add an appropriate index, which has a great impact on the query speed. You must add

View the table field information: DESC table name; View All table information: Show create table table name; Add primary key constraint: alter table table name Add constraint primary key (for example, pK _ table name) primary key table name

Modify Table: Add field: alter table yyh_yp_managerrob add catid smallint (5), Add typeid smallint (5), Add areaid smallint (5), Add Title char (150), Add style char (5), Add thumb char (100), Add keywords char (40), Add description char (255),

I. Database Operations A) Check the number of databases currently in showdatabases; B) Create the createdatabase database name. You can also set the encoding method and calibration rules followed by the characterset encoding method collate

Update the null field value to 'none'The first thought is:Update 'client' set 'Company' = 'none' WHERE 'Company' = NULLResult errorThe correct method IS to use the is null condition.Update 'client' set 'Company' = 'none' WHERE 'Company' IS

The dispersibility and interactivity of web development determine that web development must comply with certain development specifications and technical conventions, only when each developer designs, communicates, develops, tests, and deploys

View Original Previously, ply of python was used to write a prototype of hbase-like SQL Compiler. Currently, only the lexical syntax analyzer has been initially completed, when writing the following pre-processor, logical plan generator, and

Ezsql is a very useful PHP database operation class. The famous open source blog WordPress database operation on the use of the Ezsql MySQL part. The database operations class supports virtually all major databases, such as Php-pdo, MySQL, Oracle,

Database statement: DDL (data definition language) ALTER create drop DML (data manipulation language) inset Delete update DTL (Data transaction language) Conmmit rollback savepoint Select

First, start and exit1, into MySQL: Start the MySQL Command line Client (MySQL's DOS interface), directly enter the installation of the password can be. The prompt at this point is:mysql>2, Exit Mysql:quit or exitSecond, the library operation1.

1. Export the entire database Mysqldump-u user name-p--default-character-set=latin1 Database name > exported file name (database default encoding is latin1) Mysqldump-u wcnc-p SMGP_APPS_WCNC > Wcnc.sql 2. Export a table Mysqldump-u user name-P

When you apply a database in PHP, you typically use DDL statements to create databases, datasheets, and modify table structures in your Web site in a MySQL client's console, and then apply them in your PHP scripts. It is rare to execute DDL

Encountered some errors in the project process that occurred because of a database version reason MySQL server Upgrade Data restore table structure cannot be displayed After the MySQL server upgrade, after the database data is restored, the DESC

Sql> Show All--View all 68 system variable values Sql> Show user--Displays current connected users Sql> Show Error--Display errors Sql> set heading off--Suppresses the output column header, the default value is on Sql> set Feedback

Second, SQL Structur Query Language Structured Query language is an object that operates in a relational database. DDL (data definition Language), for table or delete operations, and for modifying table constraints CREATE TABLE, ALTER TABLE,