Linked Questions

I try to increase John Smith salary by 10% and assume I don't know the emp_number for John Smith. update m set m.mon_hourly_pay_rate = m.mon_hourly_pay_rate*1.1 from monthly_pay m inner join ...

This is not a duplicate question. The previous question is nothing to do with PDO. I have two tables in mysql: USERS ------------------------------------- employeeid | name | saving | salary --------...

These are my tables: tbl_answers => aid qid answer uid dateposted emailnotify namedisplay status isbestanswer tbl_questions => qid question ...

I have a weather app, and I'm storing meteo data every hour in a database. Recently i discovered a tiny bug which lead to the writing of few hundreds faulty records. To fix the issue i decided to ...

I've got an error saying that" You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM table_A INNER JOIN table_B ON ...

I am currently doing some exercises to better understand how to use MYSQL. I am trying to update a table that from the select results from two other tables. The general idea is to have the table ...

I have a database table with thousands of products. Each product have various fields. There is a field (field1) on each product that contain a link, I need that link to be copied to another product ...

my DB has this structure: ID | text | time | valid This is my current code. I'm trying to find a way to do this as one query. rows = select * from table where ID=x order by time desc; n=0; foreach ...

My knowledge of SQL trully isn't so great to perform what I want. I have 2 tables: One is long data table with many columns, one of them TypeName, recently I've added new column to the table TypeID (...

I have a script which uploads a file and stores the details of the file name in the database. When a document gets uploaded I want to be able to update the name of the file in the database to be ...

I have a Picker, i want to apply different styles to all the items, also prefer if could do for IOS and Android at the same time. in custom.xaml: <ContentPage.Content> <StackLayout&...

I have the table TableName which contains approximately 5,000 rows. It consists of a product_id and a ScheduleTime. What I want to do with this table is replace each value of ScheduleTime, ...

I need to update over 4 million rows in my database. We are currently using mysql 5.1 and the updates are very slow. At the moment it is taking over 30 minutes for less than 100,000 rows, which is ...

I have a table called downloads which has records of files which have been downloaded from various URL's. There is a column downloads.created which is a DATETIME and a column downloads.master which is ...

Update multiple rows , is using a bulk update a good solution or something like the code below works ? . I supposed wanted to update all the records with the id and filename. I did try to update ...