crate database

" ###################### #crate Database Mysql-u $USER CREATE DATABASE $DATABASE Eof [$-eq 0] echo "created DB" | | Echo DB already exists ###################### #create table Mysql-u $USER $DATABASE CREATE TABLE $TABLE ( ID int, Name varchar (100), Mark Int, De

password for the MySQL session initiated by the user account. To set a default password in this file, you can add the following content:Copy the Code code as follows:[Client]Password = 123456Then, don't forget to modify the permissions:chmod. my.cnfThis allows the MySQL database to be accessed through a script, as follows:#!/bin/bashMysql= ' which MySQL '$MYSQL test-u Root show databases;Show tables;SELECT * FROM Employees where salary > 4000;Eof2. C

 http://blog.csdn.net/robinjwong/article/details/18502195 1. Relational database A relational database is a database that uses a relational model to organize data. The relational model was first proposed by IBM researcher Dr. E.f.codd in 1970, and in the following decades the concept of the relational model was fully developed and gradually became the mainst

MSSQL Server 2005 Restore Database Bak files, Web sites using Virtual host site will often encounter, in general, the host has an online management program, but sometimes not, you need to restore the local backup SQL database. In this case, MSSQL Server 2008 will also appear, sometimes the "backup set of database backup and the existing XX

recovery. 2, creating a tablespace The table space is done using the crate tablespace command, and it is important to note that, in general, the table space is created by a privileged user or DBA, and if you create a tablespace with another user, the user must have the Create System permissions for the tablespace. 1), creating a data table space After the database is established, it is best to create

Database Name, database instance name and database domain name I. Database Name what is database name? The database name is the ID of a database, just like the ID card number of a perso

Detailed Description: Database Name, Instance name, ORACLE_SID, database domain name, Global Database Name, service name----------------------------------------------------Database Name, Instance name, database domain name, Global Databa