MySQL Practice (Practice when you are free)

Source: Internet
Author: User

Mysql-h192.168.137.10-uroot-p123

Mysql-uroot-p123

mysqladmin-uroot-p password "Redhat"

Mysqladmin-uroot-predhat password "123"

Grant all on * * to [e-mail protected] "%" identified by "Redhat";

MySQL -uzhang -predhat

Create DATABASE Luzhi default character set UTF8;

Create database luzhi1 character set UTF8;

Drop database Luzhi;

Drop database if exists luzhi1;

Create database if not exists luzhi444;

Drop database if exists luzhi444;

Use MySQL;

Show tables;

select * from user;

DESC user;

Select Database ();

Select version ();

Select DayOfMonth (current_date);

Mysql>use mytest;

Mysql> CREATE TABLE MyClass (

-ID Int (4) NOT null primary key auto_increment,

, name char (a) is not NULL,

, sex int (3) NOT null default 0,

-degree double (16,2));

mysql> INSERT INTO MyClass values (1, ' Tom ', 96.45), (2, ' Joan ', 82.99), (2, ' Wang ', 96.59);

SELECT * from MyClass;

SELECT * from MyClass ORDER by ID limit 0, 2;

Mysql> Delete from MyClass where id=1;

PHP Operation:

<?php

$con = mysql_connect ("localhost", "Peter", "abc123");

if (! $con)

{

Die (' Could not connect: '. Mysql_error ());

}

mysql_select_db ("my_db", $con);

mysql_query ("DELETE from Persons WHERE lastname= ' Griffin '"); mysql_close ($con);

?>

mysql> Update MyClass set name= ' Mary ' where id=1;

Mysql> ALTER TABLE MyClass add passtest int (4) Default ' 0 ';

Mysql> Rename table MyClass to Youclass;

Create user [email protected] identified by '123456;

Grant Select on mydb.* to [email protected];

Drop user Guest;

Grant SELECT, INSERT, UPDATE, delete on new_db.* to [email protected]'%' identified by '88888888;

Example 1

Drop database if exists school; Delete if SCHOOL is present

Create Database School; Building a library SCHOOL

Use school; Open Library SCHOOL

CREATE TABLE teacher// Create tables teacher

(

ID int (3) auto_increment NOT null primary key,

Name Char (TEN) is not NULL,

Address varchar (+) default ' Shenzhen ',

Year Date

); End of Build table

The following is the Insert field

Insert into teacher values (",'Allen', ' Dalian One ' , ' 1976-10-10 - );

Insert into teacher values (",'jack', ' Dalian II ', ' 1975-12-23);

It is also possible to type the above commands at the MySQL prompt, but it is not easy to debug.

1, you can write the above command as is written in a text file, assuming that school.sql, and then copied to c:\\ , and in the DOS State into the directory [Url=file://\\mysql\\bin]\\mysql\\bin[/url], and type the following command:

Mysql-uroot-p Password < C:\\school.sql

If successful, empty a row without any display, and if there is an error, there is a hint. (The above command has been debugged, you can use it only if you remove // comment).

2, or enter the command line after using mysql> source c:\\school.sql; You can also add School.sql file into the database.

Example 2

Drop database if exists school; Delete if SCHOOL is present

Create Database School; Building a library SCHOOL

Use school; Open Library SCHOOL

CREATE TABLE teacher// Create tables teacher

(

ID int (3) auto_increment NOT null primary key,

Name Char (TEN) is not NULL,

Address varchar (+) Default ' Shenzhen ',

Year Date

); End of Build table

The following is the Insert field

Insert into teacher values (' ' ', ' Glchengang ', ' Shenzhen one ', ' 1976-10-10 ');

Insert into teacher values (' ' ', ' Jack ', ' Shenzhen one ', ' 1975-12-23 ');

Note: In the table under construction

1 . Set the ID to a numeric field of length 3 : Int (3); and let it automatically add one to each record : auto_ Increment; cannot be empty: not null; and let him be the main field primary key.

2 . Set NAME to a character field of length ten

3, the ADDRESS is set to the length of the character field, and the default value is Shenzhen.

4 . Set year as the Date field.


This article is from the "Tiandaochouqin" blog, make sure to keep this source http://luzhi1024.blog.51cto.com/8845546/1655472

MySQL Practice (Practice when you are free)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.