Jump to content
dil_bert

ER-Diagram: How To Publish Examples Here On This Forum

Recommended Posts

hello dear all , 

 

topic: questions with some eplanations - for db-related areas and topics - export er-diagram 

 

 i want to post questions with some eplanations - for db-related areas and topics.  Well i know that there are some good tools out there which help here alot. 

The question is : how to export the data so that i can implement the data into a forum like this !?! 

 

Question can i export the data form https://www.draw.io/  to this forum!? 

 

Love to hear from you 

regards 

 

 

 

Share this post


Link to post
Share on other sites

The reply form lists accepted file types

Quote

Accepted file types gif, jpeg, jpe, jpg, png, mp4, 3gp, mov, ogg, ogv, mpg, mpeg, flv, webm, wmv, avi, m4v

EG

register.PNG.6c53f7dc3e6e1f6e681ac7e47be34dc3.PNG

Text, such as a SQL data dump, can be placed inside (<>) code frames. EG

DROP TABLE IF EXISTS `result`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `result` (
  `pupilid` int(10) unsigned NOT NULL,
  `subjectid` int(10) unsigned NOT NULL,
  `pcent` tinyint(4) DEFAULT '0',
  `schoolyear` int(4) NOT NULL DEFAULT '0',
  `resultid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`resultid`),
  KEY `index_2` (`pupilid`),
  KEY `index_3` (`subjectid`)
) ENGINE=MyISAM AUTO_INCREMENT=163 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `result`
--

LOCK TABLES `result` WRITE;
/*!40000 ALTER TABLE `result` DISABLE KEYS */;
INSERT INTO `result` VALUES (1,1,78,2014,1),(3,1,58,2014,2),(4,1,54,2014,3),(8,1,91,2014,4),(9,1,62,2014,5),
(11,1,77,2014,6),(13,1,60,2014,7),(14,1,64,2014,8),(15,1,93,2014,9),(18,1,87,2014,10),
(19,1,60,2014,11),(20,1,81,2014,12),(1,2,87,2014,13),(2,2,53,2014,14),(4,2,87,2014,15),
(12,2,93,2014,16),(14,2,62,2014,17),(15,2,74,2014,18),(16,2,90,2014,19),(17,2,87,2014,20),
(21,2,73,2014,21),(22,2,53,2014,22),(23,2,86,2014,23),(2,3,88,2014,24),(5,3,85,2014,25),
(6,3,68,2014,26),(8,3,78,2014,27),(12,3,50,2014,28),(19,3,53,2014,29),(7,4,69,2014,30),
(10,4,90,2014,31),(13,4,57,2014,32),(19,4,57,2014,33),(22,4,62,2014,34),(23,4,92,2014,35),
(24,4,95,2014,36),(1,5,79,2014,37),(2,5,76,2014,38),(5,5,94,2014,39),(7,5,58,2014,40),
(9,5,50,2014,41),(11,5,68,2014,42),(14,5,51,2014,43),(18,5,94,2014,44),(20,5,86,2014,45),
(21,5,52,2014,46),(22,5,87,2014,47),(23,5,53,2014,48),(24,5,86,2014,49),(6,6,87,2014,50),
(10,6,81,2014,51),(13,6,51,2014,52),(22,6,54,2014,53),(23,6,67,2014,54),(24,6,77,2014,55),
(6,7,92,2014,56),(9,7,89,2014,57),(10,7,74,2014,58),(14,7,53,2014,59),(18,7,86,2014,60),
(21,7,85,2014,61),(2,8,71,2014,62),(4,8,52,2014,63),(5,8,89,2014,64),(7,8,58,2014,65),
(11,8,63,2014,66),(16,8,93,2014,67),(17,8,91,2014,68),(20,8,82,2014,69),(21,8,87,2014,70),
(24,8,93,2014,71),(3,9,66,2014,72),(4,9,90,2014,73),(5,9,69,2014,74),(6,9,69,2014,75),
(9,9,87,2014,76),(13,9,91,2014,77),(15,9,54,2014,78),(17,9,84,2014,79),(18,9,72,2014,80),
(19,9,58,2014,81),(1,1,73,2015,82),(3,1,95,2015,83),(4,1,84,2015,84),(8,1,73,2015,85),
(9,1,93,2015,86),(11,1,71,2015,87),(13,1,93,2015,88),(14,1,79,2015,89),(15,1,94,2015,90),
(18,1,60,2015,91),(19,1,71,2015,92),(20,1,77,2015,93),(1,2,74,2015,94),(2,2,81,2015,95),
(4,2,85,2015,96),(12,2,83,2015,97),(14,2,63,2015,98),(15,2,81,2015,99),(16,2,82,2015,100),
(17,2,70,2015,101),(21,2,82,2015,102),(22,2,66,2015,103),(23,2,60,2015,104),(2,3,82,2015,105),
(5,3,96,2015,106),(6,3,96,2015,107),(8,3,93,2015,108),(12,3,82,2015,109),(19,3,73,2015,110),
(7,4,94,2015,111),(10,4,81,2015,112),(13,4,62,2015,113),(19,4,84,2015,114),(22,4,60,2015,115),
(23,4,64,2015,116),(24,4,83,2015,117),(1,5,84,2015,118),(2,5,77,2015,119),(5,5,71,2015,120),
(7,5,66,2015,121),(9,5,95,2015,122),(11,5,64,2015,123),(14,5,92,2015,124),(18,5,92,2015,125),
(20,5,88,2015,126),(21,5,65,2015,127),(22,5,77,2015,128),(23,5,93,2015,129),(24,5,61,2015,130),
(6,6,79,2015,131),(10,6,77,2015,132),(13,6,88,2015,133),(22,6,76,2015,134),(23,6,93,2015,135),
(24,6,62,2015,136),(6,7,86,2015,137),(9,7,69,2015,138),(10,7,69,2015,139),(14,7,76,2015,140),
(18,7,77,2015,141),(21,7,96,2015,142),(2,8,78,2015,143),(4,8,77,2015,144),(5,8,95,2015,145),
(7,8,68,2015,146),(11,8,74,2015,147),(16,8,67,2015,148),(17,8,91,2015,149),(20,8,83,2015,150),
(21,8,80,2015,151),(24,8,93,2015,152),(3,9,88,2015,153),(4,9,66,2015,154),(5,9,81,2015,155),
(6,9,73,2015,156),(9,9,61,2015,157),(13,9,66,2015,158),(15,9,86,2015,159),(17,9,60,2015,160),
(18,9,94,2015,161),(19,9,79,2015,162);
/*!40000 ALTER TABLE `result` ENABLE KEYS */;
UNLOCK TABLES;

 

Share this post


Link to post
Share on other sites
Posted (edited)

hello dear Barand 

many thanks - as allways your answers are excellent - and just overwhelming!  I am happy and glad to see such a convincing answer. 

 

 

 

i also had a look at the ASCII generators for ERD diagrams (perhaps that fit well within markup syntax)?

For example, that could generate something like the diagram below: to create such diagrams i guess such a tool might be helpfull: http://asciiflow.com/

 

 


[CODE]

 ---------
 |  Hai  |
 ---------
     |
     |
    /|\
 ---------         ------------          ---------
 |  Foo  |-------< |  FooBar  | >------- |  Bar  |
 ---------         ------------          ---------
    \|/
     |
     |
 ---------
 |  Bai  |
 ---------
 
[/CODE]

 

Edited by dil_bert

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.