HOME       >>       Programming

How To Understand A Database Schema A very nice and simple tutorial


TavoxPeru

Yesterday while i'm seaching for a data model and database schema at the Library of Free Data Models for a new project of a friend of mine i found there this nice and simple tutorial on How to Understand a Database Schema.

 

As its name says, this tutorial will help you to better understand a Database Schema and covers the following basics topics that every Database Schema must define:

Primary and Foreign Keys.

One-to-Many and Many-to-Many Relationships.

Inheritance.

"Rabbit's Ears", (Recursive relationships).

The Scope of this tutorial is the process of buying on Starbucks and Amazon.com, covering Customers, Deliveries, Orders, Products and Suppliers and how they are related.

 

I think that this simple tutorial on How to Understand a Database Schema will be very helpful to everybody not only to newbies on this topic.

 

Best regards,


faulty.lee

Sounds interesting, even though I've been using database for quite a few years already, but there always something new to learn. I've downloading the video now. Let see what's did I miss.


yordan

Nice tutorial, you are right, thanks for the info.
The author is fantastic. I love his KISS concept.

Our motto - Keep It Simple and Straightforward (KISS)


iGuest

KISS = Keep it Simple, Stupid...


Jezstarr

KISS = Keep it Simple, Stupid...

That's what my teacher taught me, haha...well its a good tutorial, explains some good points.

iGuest

Can i dump .csv file in mysql database? if yes how? How To Understand A Database Schema

Hello One and All,

I have to dump a csv file into  mysql database, is it possilble to dump the content of csv file to  mysql table. Can anyone please tell me how can I do it, is there any api's available for this. Please let me know abot it.

regards,

Raghu


TavoxPeru

Yes, it is possilble to import the contents of a csv file into a mysql table.

 

To import your data use the LOAD DATA INFILE sql statement, for example:

 

LOAD DATA INFILE "dumpfile.csv" INTO TABLE your_table FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY """" LINES TERMINATED BY "\\r\\n";'

 

I don't know which version of MySql you are using so for details take a look at any of the following pages:

LOAD DATA INFILE MySQL 5.0

LOAD DATA INFILE MySQL 5.1

LOAD DATA INFILE MySQL 5.4

LOAD DATA INFILE MySQL 6.0

Also since MySQL 5.x, a new engine named MySQL CSV Storage Engine has been provided to help with the management and use of delimited data found in common flat files.

 

For more information visit:

A Look at the MySQL CSV Storage Engine (Excellent Article)

MySQL CSV Storage Engine Documentation

Best regards,

celina234

hello all, i like to know more about database and sql.please upgrade in furure


ashish17

oh its great i m also looking for such tutorials and found it so easily ......and it provide sql which is very needful for me...thanks to all!!! for such a useful postingkeep posting...


surfermac

good postingkeep on posting such posts good for newbies



VIEW DESKTOP VERSION REGISTERGET FREE HOSTING

Xisto.com offers Free Web Hosting to its Members for their participation in this Community. We moderate all content posted here but we cannot warrant full correctness of all content. While using this site, you agree to have read and accepted our terms of use, cookie and privacy policy. Copyright 2001-2019 by Xisto Corporation. All Rights Reserved.