P

Old Import database table Data Issue

  • Thread starter Thread starter puertoblack2003
  • Start date Start date

Visitor Greeting

Welcome to NullWarehouse.com... We are currently seeking Mod's and Contributors. If you wish to apply for a Mod position then please click on Members dropdown arrow, then click on Staff App and fill it out completely and submit it. If you want to be a Contributor then start contributing and we will have our eye on you and take notice, something great could come of it.

  • We have redone the forum. If you notice any issues or errors please open a Support Ticket under the Members dropdown and let us know.
P

puertoblack2003

Guest

I need a sample database query line
SQL:
( UPDATE tablename SET settings = REPLACE(value,' sample',' sample2'); )
something similar to this. I need to change from "0" in user_id column to actual username id example "14326". The problem with this is columns. it needs to pull column from username to user_id to change from "0" to actual Id number. Is there a better solution?

database.webp

Continue reading...
 
Similar content Most view View more
Back
Top Bottom