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

[TavoxPeru 0]

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 0]

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 10]

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 3]

KISS = Keep it Simple, Stupid...

[Jezstarr 0]

KISS = Keep it Simple, Stupid...

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

[iGuest 3]

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 0]

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 0]

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

[ashish17 0]

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 0]

good postingkeep on posting such posts good for newbies