CREATE DATABASE other; # Gives users database privileges that are same as those for 'coreco' database: > DROP TABLE IF EXISTS scratch.temp; > CREATE TABLE scratch.temp SELECT * FROM mysql.db where db ='coreco'; > UPDATE scratch.temp SET db = 'other'; > INSERT INTO mysql.db SELECT * FROM scratch.temp; ">Knowledgebase -
Community Platform

Knowledgebase

Documents, videos, websites and more.

Adding a new MySQL Database (collection of tables) to the DataWeb

Brief description or abstract:
From MySQL, to create a database called "other": > CREATE DATABASE other; # Gives users database privileges that are same as those for 'coreco' database: > DROP TABLE IF EXISTS scratch.temp; > CREATE TABLE scratch.temp SELECT * FROM mysql.db where db ='coreco'; > UPDATE scratch.temp SET db = 'other'; > INSERT INTO mysql.db SELECT * FROM scratch.temp;
Posting type(s):
Links & Files
URL:
Regions & Topics
Geographic regions: United States
Topic(s):
Subtopic(s):
Number of "Likes":0
Number of Views:352
Posting Details
Publication date: 0000-00-00
Tags
Tags:
Added 2003-05-30 by tpollak, Modified 2011-09-27 by kuttkeUI

Comments

No comments.