var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Concept Of Schemas
I have looked around a bit on the web but did not find a definitive answer/example.
I want to be able to discern different customer data by using the concept of schemas.
SELECT * from BIGDB.Customer1.patient_information
WHERE BIGDB is the database and Customer1 is the schema
and lastly the table
If it does support schemas like this, sorry another question, can you backup and restore individual schemas?
As I indicated I have searched for a while now and am either not getting it, it does not exist, or I am searching with the incorrect 'terms'
In MySQL CREATE SCHEMA is synonymous for CREATE DATABASE. So your query above can only do SELECT * FROM DATABASE.TABLE;
Tags for this Thread