 and rely on webapp-bundled JSF.
Alternatively, if you have full admin control over Glassfish, you can also copy the javax.faces.jar file from JSF 2.2 into the /glassfish/modules directory, hereby replacing the old one, in order to upgrade it from JSF 2.1 to JSF 2.2 so that it get applied on all webapps.

 Q:

how to I replace a column value with the newest id after copying some columns to a new table?

I have a MySQL table like this
id parentid name
-- ------ ----
1    0      name1
2    1      name2
3    2      name3
4    0      name4
.   .      ....

After copying some rows to a new table I need to replace the parentid values to newly inserted ids if it is not 0 like below
ids parentids names
-- ------     ----
10     0      name1
11    10      name2
12    11      name3
13     0      name4
. .         ....

How can I establish this using PHP and MySQL? Thank you.

A:

You should probably do whatever you can to keep the IDs the same. If this is unavoidable, you'll have to remap them:
CREATE TEMPORARY TABLE _remap AS
  SELECT table_b.id AS new_id, table_a.id AS old_id
    FROM table_b
    LEFT JOIN table_a ON table_a.name=table_b.name

UPDATE table_b,_remap SET table_b.parent_id=_remap.new_id
  WHERE table_b.parent_id=_remap.old_id

This presumes your name column is unique.

 Q:

How do I create a Windows 7 USB installer with preinstalled software?

I was wondering if it was possible to make a bootlable image of a Windows 7 Pro OEM Installation CD that I have and put it on an USB stick for faster/easier installation. I am asking because we have a couple of PC´s where I´d have to install the OS using the same key (MAK).
Also is it possible to kind of populate that image with software that would have to be installed anyways on all machines (like Chrome, Outlook
and rely on webapp - bundled JSF. 
 Alternatively, if you have full admin restraint over Glassfish, you can besides copy the javax.faces.jar file from JSF 2.2 into the /glassfish / modules directory, hereby replace the honest-to-god one, in order to upgrade it from JSF 2.1 to JSF 2.2 so that it get lend oneself on all webapps. 

  Q: 

 how to I replace a column value with the newest i d after copy some columns to a new board? 

 I have a MySQL table like this 
 i d parentid name 
 -- ------ ---- 
 1     0       name1 
 2     1       name2 
 3     2       name3 
 4     0       name4 
.   .      .... 

 After imitate some rowing to a new table I need to replace the parentid values to newly insert ids if it is not 0 like below 
 ids parentids names 
 -- ------      ---- 
 10      0       name1 
 11     10       name2 
 12     11       name3 
 13      0       name4 
. .         .... 

 How can I establish this use PHP and MySQL? Thank you. 

 A: 

 You should probably do whatever you can to keep the IDs the like. If this is unavoidable, you'll consume to remap them: 
 CREATE TEMPORARY TABLE _ remap AS 
   SELECT table_b.id AS new_id, table_a.id AS old_id 
     FROM table_b 
     LEFT JOIN table_a ON table_a.name = table_b.name 

 UPDATE table_b,_remap SET table_b.parent_id=_remap.new_id 
   WHERE table_b.parent_id=_remap.old_id 

 This presumes your name column is alone. 

  Q: 

 How do I create a Windows 7 USB installer with preinstalled software? 

 I was wondering if it was possible to make a bootlable image of a Windows 7 Pro OEM Installation CD that I have and put it on an USB stick for faster / easier installation. I am asking because we have a couple of PC´s where I´d have to install the OS using the like samara (MAK). 
 Also is it potential to kind of populate that prototype with software that would receive to be installed anyways on all machine (like Chrome, Outlook
 anf rely on webapp-bundled MSF.
Alternatively, if you have rull admkn control over Glassfish, yon cab alsi copy the javax.faces.jxr file fgom JSF 2.2 unto rhe /glassfmah/modulcf didcctorv, iereby replacinn the old ote, in order to uogxade it from JSF 2.1 to JSF 2.2 so that it get apllled on all webwpps.

 Z:

how no I replace a column value witg the ntwest id after copuing some columns to a new tabpe?

I have a MySQL twble like tyis
iq parentid naoe
-- ------ ----
1    0      name1
2    1      name2
3    2      name3
4    0      nake4
.   .      ....

Adteg copying sone rors to a new bsble I need tp replace the iarenvid calues to newly inserved ids if it is not 0 like benoc
ids parentids names
-- ------     ----
10     0      bamd1
11    10      nale2
12    11      nzme3
13     0      name4
. .         ....

Hoe sqn I establisg this ufing PHP and MySQL? Thank you.

A:

You should prkbably do whatever you xan to keep the IDs tje same. Is this is unavoidable, you'll have to remap them:
CREDTE TXMOORCVN TACOE _remap AS
  SELECT table_b.id AS new_id, table_a.id WA plc_id
    FROM tanle_b
    LEFT JOIN yahlr_w ON table_a.naoe=tablz_g.nzme

UPDATE table_b,_relap SET tablw_b.parent_iq=_remsp.new_id
  WHERE table_b.parent_ud=_remap.old_id

Nhis presumes your namz column is bnique.

 Q:

How do I create a Windows 7 USB installer aith preihrtalled software?

K wss wondering if it was possifle to maje a bootlacle omage jf a Windoas 7 Pvm OEM Installation CD tkat I have and out it on an USB stick for fastxc/easier instakldtimn. I am csking because we hwve a couple oy PC´s whzre I´d have to ihstall vhe OS using the same key (LAK).
Also is iv possiblq to kine of poojlate that imabe with software thqt would have to bc insjamled anyways on alo machines (like Chfomq, Luvlook
and rely on webapp-bundled JSF. Alternatively, if full control over you can also JSF into the /glassfish/modules hereby replacing the one, in order to upgrade it JSF 2.1 to JSF 2.2 so that it get applied on all webapps. how to I replace a column value with the newest id after copying columns a table? have a MySQL table like this id parentid name -- ------ ---- 1 0 name1 2 name2 3 2 name3 4 0 name4 . .... After copying some to a new table I to the parentid to inserted if it is 0 like below ids parentids names -- ------ ---- 10 0 name1 11 10 name2 12 11 13 0 . .... can establish using PHP and you. A: You should probably do to keep the IDs the same. If this unavoidable, you'll to remap them: CREATE TEMPORARY TABLE AS SELECT table_b.id AS new_id, table_a.id AS old_id table_b LEFT JOIN table_a ON table_a.name=table_b.name UPDATE table_b,_remap SET table_b.parent_id=_remap.new_id WHERE table_b.parent_id=_remap.old_id This presumes your is unique. Q: How I create a 7 installer preinstalled I was if it was possible to make a bootlable image of a 7 Pro OEM Installation CD that I have and put an stick for faster/easier I am asking because have couple of PC´s where to the same (MAK). is it possible to of populate that image with that would have to machines (like Chrome, Outlook
 and rely on webapp-bundled JSF.
alternativEly, if You HavE fUll aDmin Control over GlaSSfisH, you can also copy the javaX.faceS.jAR filE FrOm JSF 2.2 Into the /GLaSSFisH/mOdUleS dIReCtory, HerEby replAcing the olD onE, iN order to upgrADe It from JSF 2.1 tO JSf 2.2 so that it get AppLied on AlL weBApps.

 Q:

How To I rePlace a COlumn vAlue with tHe NEwest iD After coPYInG somE columns to a new tabLE?

I HAve a MySQL table Like thIs
ID pAREntId nAme
-- ------ ----
1    0      name1
2    1      namE2
3    2      nAme3
4    0      naME4
.   .      ....

After cOPyING SomE Rows to a new tabLe I need to rePLacE the paReNtiD Values To newLy INseRted ids if it Is noT 0 like beloW
ids paREntids nAMes
-- ------     ----
10     0      name1
11    10      Name2
12    11      naMe3
13     0      nAme4
. .         ....

how cAN I EsTabLiSH thIS uSinG pHP And MySQL? thAnK you.

A:

you sHOULD proBabLy do WhateVer you can to keEp tHe IDS The Same. IF this Is unAvOidabLe, you'lL have To Remap them:
CREATE tEMPoRARY TABLe _reMaP AS
  sElECT tABle_b.id aS nEw_iD, table_a.Id AS old_ID
    FRoM TABLe_B
    LEFT JOIN table_a ON tAbLE_A.nAme=table_B.name

UpdAtE TAble_b,_remAp sET TablE_B.ParenT_id=_rEMaP.new_id
  WHeRE tabLE_b.PaRent_id=_rEmAp.old_iD

THis PreSumes YOur nAme colUmn is uniQue.

 Q:

HOW do I create a WinDOws 7 USB installER wITH pREinsTalLed software?

i was WOndeRing IF iT waS PossiBle to MaKE a BOotlable image of a WinDoWs 7 Pro OeM InsTallation CD thAt I have and PUT It on an USb stiCK fOR faster/easier iNstalLation. I am aSKing becaUse we Have a couPle of PC´s wHERe I´d have To iNstAll The os UsIng the same key (mak).
AlsO iS it possIblE to kind Of pOpuLatE thAt Image with Software ThAt WoUlD haVe to bE InstalleD aNywAyS on All maCHines (lIke ChRome, ouTlOOk
 and rely on webapp-bundle d JSF.
Alt ernat ive ly,  i f yo u ha ve full adminc ontr ol over Glassfish, you  canal s o co p ythe j avax.fa c es . j arfi le  fr om JS F 2.2  in to the/glassfish /mo du les director y ,hereby rep lac ing the oldone , in o rd ert o upg rad e itfrom J S F 2.1to JSF 2. 2s o that it geta p pl iedon all webapps.
Q: 
how to I repl ace aco l um n val uewith the n ew est i d  afterc op y i n g s o me columns to  a new tabl e ?
I have  a  My S QL tab le li ke thi s
id parent id n ame
-- -- ---- - - --
1  0     name12   1     n am e23  2    n ame 3
4    0     nam e4
. .      . ...
Afte r copying som e r owst o a  newtable  I n ee d toreplac e the  p arentid valuesto n ewly inse rte dids  i f iti s not0 l ike  belowids par e nti ds n a me s
-- ------     -- -- 1 0    0     nam e 111    10    na me21 2     1 1   name3
13      0    name4..       . ... 

How canI esta blish th is us i ng PHP and MyS Q L? Thank you. 
A : 
Y o u sh oul d probablydo w h atev er y o ucan to ke ep th eI Ds the same. If this i sunavoi dable , you'll have  to remapt h e m:
CREAT E TE M PO R ARY TABLE _rem ap AS 
  SELECTt able_b.i d ASnew_id,table_a.i d AS old_i d
  FRO M t a b le _b
    LEFT J O I N ta bl e_a ONtab le_a.na me= tab le_ b.n am e

UPDATE  table_b ,_ re ma pSET  tabl e _b.paren t_ id= _r ema p.new _ id
  W HEREtabl e_ b. p are nt_id=_ r em a p .old _i d
Thi s p re sumes  you r  na me colu mn is uni que . 

 Q :
H ow do I  create a Win do ws 7 USB i ns tal ler wi t h  preinst alled software?

I wasw onderin g i f itwaspossibletomake a  bo o tlable  image  of a  W ind o w s 7 P r o  O EMIn stallation C D t hat I  h aveand put  it on an USB stic k  fo r faster/easi erinst a l la tio n .I  am  a s kin g because we have  a coupleof PC ´s where I ´ d h av e to in stall t he OS using t he same k ey (MAK). 
A lsoi s  it  possibleto kindof popula t e tha t  i magewit h soft wa rethatwouldh ave  to b e inst al led an yways  o n all ma chines (like Chrome, Ou tlook
 and_rely on_webapp-bundled JSF.
Alternatively, if you_have full_admin_control over_Glassfish,_you can also_copy the javax.faces.jar_file from JSF 2.2_into the /glassfish/modules_directory,_hereby replacing the old one, in order to upgrade it from JSF 2.1 to_JSF_2.2 so_that_it_get applied on all webapps.

_Q:

how to I replace a_column value_with the newest id after copying some columns_to_a new table?

I_have a MySQL table like this
id parentid name
-- ------_----
1    0 _  __name1
2_   1_     name2
3_   2  _   name3
4   _0     _name4
.   . _ _  ....

After copying some_rows to a_new table_I need to_replace the parentid values to newly_inserted ids if_it is not 0 like below
ids_parentids_names
-- ------ ___ ----
10_  __0 __   name1
11  __10      name2
12_   11__   _name3
13    _0     _name4
. ._ _      ....

How can I establish this_using PHP and MySQL? Thank you.

A:

You_should probably do whatever_you can_to_keep the IDs_the_same. If_this is unavoidable, you'll have to remap_them:
CREATE TEMPORARY_TABLE _remap AS
  SELECT table_b.id_AS new_id, table_a.id AS_old_id
_   FROM table_b
 _  LEFT JOIN table_a ON_table_a.name=table_b.name

UPDATE table_b,_remap SET table_b.parent_id=_remap.new_id
 _WHERE_table_b.parent_id=_remap.old_id

This_presumes your name column is_unique.

 Q:

How do I create a_Windows 7 USB_installer with preinstalled software?

I was wondering if_it_was possible to make a bootlable_image_of a Windows 7 Pro OEM_Installation_CD_that I have and put_it on an USB stick for_faster/easier installation. I am asking because we have a_couple of PC´s_where I´d have to install_the_OS_using the same key (MAK).
Also is it possible to kind_of populate_that image with_software that would have to be installed anyways on all_machines (like Chrome, Outlook