02:26.05 | *** join/#udbug ChanServ (ChanServ@services.) |
02:26.05 | *** mode/#udbug [+o ChanServ] by irc.freenode.net |
12:57.26 | eggyknap | presumes the ERD drawing tool macnewbold was looking for the other day should be friendly with MySQL, and pleads ignorance on that head. |
15:30.00 | macnewbold | we'll make a database-independent ERD, but if it can generate one from a mysql database, that's handy too |
15:30.19 | macnewbold | or if it will generate table creation statements from a diagram |
15:45.27 | *** join/#udbug SunSparc (n=sparky@75.148.101.137) |
15:45.27 | *** mode/#udbug [+o SunSparc] by ChanServ |
15:53.46 | *** join/#udbug fungus (n=olsonl@bromine.sosstaffing.com) |
15:53.46 | *** mode/#udbug [+o fungus] by ChanServ |
16:02.38 | eggyknap | is scared of anything that would try to write SQL based on a diagram. |
17:30.55 | *** join/#udbug SunSparc (n=sparky@75.148.101.137) |
17:30.55 | *** mode/#udbug [+o SunSparc] by ChanServ |
22:04.12 | unum | so I brought this situation before, I took some advice that was given and now need some further direction |
22:04.23 | unum | I have a task that involves three employees |
22:04.38 | unum | said task is store in a row in table in a postgresql table |
22:04.55 | unum | each employee is stored in a table(now) in the same database |
22:05.27 | unum | each employee has a unique id number that is stored in the task table |
22:05.49 | unum | how would I got about writing a query that would get all three employees names |
22:18.02 | unum | it would seem I would need to do subselects |