nixCraft Linux Forum

nixCraft

Linux / UNIX Tech Support Forum

Creating Schema in mySQL

This is a discussion on Creating Schema in mySQL within the Databases servers forums, part of the Mastering Servers category; Hi I have created MySQL Database and it is working fine. I have many tables and would like to group ...

Register free or login to your existing account and remove all advertisements.


Go Back   nixCraft Linux Forum > Mastering Servers > Databases servers

Linux answers from nixCraft.


Databases servers Discussions of databases of all types - especially MySQL.

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 09-16-2008, 11:59 PM
ish ish is offline
Junior Member
User
 
Join Date: Sep 2008
OS: Debian
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
ish is on a distinguished road
Question Creating Schema in mySQL

Hi

I have created MySQL Database and it is working fine. I have many tables and would like to group them up. I come from Microsoft SQL Sever, where I used to group tables in to Schema name. eg
DatabaseName/SchemaName/TableName

But i can't see in MySQL how do I implement same sort of thing. I can only create database and table, but not schema name.

Please can you help.

many thank
Reply With Quote
  #2 (permalink)  
Old 09-17-2008, 04:20 AM
nixcraft's Avatar
Never say die
User
 
Join Date: Jan 2005
Location: BIOS
OS: RHEL
Posts: 2,635
Thanks: 11
Thanked 232 Times in 172 Posts
Rep Power: 10
nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute
Default

You mean you would like to see a diagram of a complex database schema or you'd like to define schema?
__________________
Vivek Gite
Linux Evangelist
Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group.
Always use CODE tags for posting system output and commands!
Do you run a Linux? Let's face it, you need help
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads

Thread Thread Starter Forum Replies Last Post
Creating bootable CD hrishikesh CentOS / RHEL / Fedora 4 07-09-2008 12:44 PM
creating a group mailing list on linux sunguru The Hangout 1 06-07-2008 03:49 PM
creating firewall ramsatpm Networking, Firewalls and Security 1 03-28-2008 10:15 AM
How do I prevent the normal users creating alphabetic password saro_113 Shell scripting 2 08-30-2007 11:34 AM
HP UX creating user account with SAM - it is easy to use rockdalinux HP-UX 0 12-20-2006 03:01 PM


All times are GMT +5.5. The time now is 10:46 AM.


Powered by vBulletin® Version 3.8.4 - Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.2
©2005-2009 nixCraft. All rights reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38