CODEWITHSUNDEEP
sqldatabasesqlite
sam jackson
sam jackson

Reputation: 1

SQLITE3 query syntax error

I'm trying to update a table in my dataset. When I run the below query I get "near "FROM": syntax error:

I have tired and tired but no luck in figuring it out.

I'm using sqlite3 as a database and DB Browser to execute the query.

UPDATE movieDataset
SET budget=REPLACE(movie_info.info,',','')
FROM (
  SELECT
  movie_info.movie_id,
  movie_info.info
  FROM
  movie_info, movieDataset
  WHERE
  movieDataset.movie_id = movie_info.movie_id
  and movie_info.info_type_id=105
  )AS movie_info
  WHERE movieDataset.movie_id = movie_info.movie_id;

movieDataset column list: (movie_id integer, country, budget)

movie_info column list: (movie_id, info, movie_info_type_id)

Any suggestion???

Thank you

Upvotes: 0

Views: 616

Answers (1)

Serg
Serg

Reputation: 22811

Try this, update rows with movie_id which has info_type_id=105 in corresponding movie_inforow

UPDATE movieDataset
SET budget=REPLACE(movie_info.info,',','')
WHERE movieDataset.movie_id IN (
  SELECT movie_info.movie_id
  FROM movie_info
  WHERE movie_info.info_type_id=105
  )

Upvotes: 1

Related Questions