mysql - Inserting data from a join within tables -

-

i'm trying figure out how extend table of company_ids using group reference table. given company_name, want company_ids, join them company_groups table, , group_ids. there, want every company_id associated group_id, , insert them in companies table proper company_name.

the structure bit atypical. single company name can have many ids, because id isn't used unique identifier single company. i'm trying make sure of them copied companies table. i'm sure there's simple join command, i've never been @ joining tables within themselves. can help? thanks!

+---------------+ |   companies   | +---------------+ | company_id pk | | company_name  | +---------------+  +----------------+ | company_groups | +----------------+ | company_id pk  | | group_id       | +----------------+

here's example. in companies table, have company "tesla", 3 different ids.

+--------------+------------+ | company_name | company_id | +--------------+------------+ | tesla        |     647552 | | tesla        |     927572 | | tesla        |     748563 | +--------------+------------+

in company_groups table, each group_id has 1 or more company_ids.

+----------+------------+ | group_id | company_id | +----------+------------+ | 227      |     647552 | | 227      |     111743 | | 227      |     111842 | +----------+------------+

i want match company_name multiple group_ids, find company_ids associated group. new company_ids inserted in companies table this:

+--------------+------------+ | company_name | company_id | +--------------+------------+ | tesla        |     647552 | | tesla        |     927572 | | tesla        |     748563 | | tesla        |     111743 | | tesla        |     111842 | +--------------+------------+

you cannot insert table when same table name appear in clause.

you can use temporary third table job

at second thought, question either funny or not clear enough, please provide sample data, can update answer


Comments

Post a Comment

Popular posts from this blog

SVG stroke-linecap doesn't work for circles in Firefox? -

-
i've got problem svg stroke-linecap attribute. i've got circular progress bar in angularjs , set outer circle (blue one) have rounded "ends". @ fiddle . <svg ... height="130" width="130"> <!-- ngif: background --> <circle ... ng-if="background" fill="#fff" class="ng-scope" stroke-width="13" stroke="#cc3399" r="57.5" cy="65" cx="65" stroke-linecap="round" /> <!-- end ngif: background --> <circle ... fill="none" stroke-dashoffset="36.12831551628261" stroke-dasharray="361.28315516282623" stroke-width="13" stroke="#432db3" stroke-linecap="round" r="57.5" cy="65" cx="65" transform="rotate(-89.9, 65, 65)" /> </svg> how can that? ...
Read more

routes - Laravel 4 Wildcard Routing to Different Controllers -

-
realizing i'm going take beating this, have several questions "best practices" when constructing laravel route. do laravel routes run "first come first serve" top bottom? if route found, pass control controller (or perform action) , terminate? i have part of application acts url shortner. so, route looks this: route::get('/{id}', array('as' => 'home.text', 'uses' => 'homecontroller@text'), function($id){ //make sure id exists before pushing controller. if (storage::where('shortcode','=', $id)->count() > 0) { // route found } }); how can improved? one, i'm not sure how pass processing on controller conditionally.. sort of controller::make() ..? 3) there better way in laravel check if record exists versus doing mode::where('column','=','value')->count() 4) have legacy urls http://url.com/?...
Read more

cross browser - XSLT namespace-alias Not Working in Firefox or Chrome -

-
i transforming xhtml xhtml, need xslt stylesheet part of resulting document (the stylesheet contained in <script type"text/template"> element. using the xsl:namespace-alias instruction, works fine in ie, fails in both chrome , firefox. here relevant code: <xsl:output doctype-system="about:legacy-compat" omit-xml-declaration="yes" indent="yes" method="html" media-type="application/xhml" encoding="utf-8"/> <xsl:namespace-alias stylesheet-prefix="wxsl" result-prefix="xsl" /> <xsl:template match="head"> <!-- code omitted clarity --> <script type="text/template"> <wxsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/xsl/transform" xmlns="http://www.w3.org/1999/xhtml" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:eli="local"> ...
Read more