Click here to Skip to main content
15,797,600 members
Home / Discussions / Database
   

Database

 
GeneralRe: cannot use "dynamic" Connection String with Excel? Pin
Richard MacCutchan24-Jul-16 21:54
mveRichard MacCutchan24-Jul-16 21:54 
QuestionEncrypt email address to 6-8 digit alphanumeric Pin
sumit703418-Jul-16 23:55
sumit703418-Jul-16 23:55 
AnswerRe: Encrypt email address to 6-8 digit alphanumeric Pin
Richard MacCutchan19-Jul-16 4:14
mveRichard MacCutchan19-Jul-16 4:14 
Generalmovement of foreign key Pin
Member 1141876917-Jul-16 13:56
Member 1141876917-Jul-16 13:56 
GeneralRe: movement of foreign key Pin
User 1106097918-Jul-16 0:10
User 1106097918-Jul-16 0:10 
QuestionRestore CDC Data Pin
maryam.saboor16-Jul-16 20:39
professionalmaryam.saboor16-Jul-16 20:39 
AnswerRe: Restore CDC Data Pin
maryam.saboor18-Jul-16 19:54
professionalmaryam.saboor18-Jul-16 19:54 
QuestionMySQL - Update a table from same table using SELECT Pin
Jassim Rahma16-Jul-16 12:54
Jassim Rahma16-Jul-16 12:54 
Hi,

I am trying to update the customers MySQL table using SELECT from the same table but getting:
[Err] 1064 - 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 '(destination_table.title) =
here is the SQL statement:
SQL
UPDATE customers destination_table

SET (destination_table.title) =
(

   SELECT source_table.title

   FROM customers source_table

   WHERE source_table.customer_id = 18

)

WHERE destination_table.customer_id = 14;

Thanks,
Jassim[^]

Technology News @ www.JassimRahma.com

AnswerRe: MySQL - Update a table from same table using SELECT Pin
Mycroft Holmes16-Jul-16 14:38
professionalMycroft Holmes16-Jul-16 14:38 
AnswerRe: MySQL - Update a table from same table using SELECT Pin
User 1106097917-Jul-16 2:37
User 1106097917-Jul-16 2:37 
GeneralRe: MySQL - Update a table from same table using SELECT Pin
Jassim Rahma17-Jul-16 4:00
Jassim Rahma17-Jul-16 4:00 
GeneralRe: MySQL - Update a table from same table using SELECT Pin
User 1106097917-Jul-16 4:11
User 1106097917-Jul-16 4:11 
AnswerRe: MySQL - Update a table from same table using SELECT Pin
Bernhard Hiller18-Jul-16 22:18
Bernhard Hiller18-Jul-16 22:18 
GeneralRe: MySQL - Update a table from same table using SELECT Pin
Mycroft Holmes18-Jul-16 23:05
professionalMycroft Holmes18-Jul-16 23:05 
QuestionError: Conversion failed when converting the varchar value Pin
Richard Andrew x648-Jul-16 11:39
professionalRichard Andrew x648-Jul-16 11:39 
AnswerRe: Error: Conversion failed when converting the varchar value Pin
Jörgen Andersson8-Jul-16 13:37
professionalJörgen Andersson8-Jul-16 13:37 
GeneralRe: Error: Conversion failed when converting the varchar value Pin
Richard Andrew x648-Jul-16 13:44
professionalRichard Andrew x648-Jul-16 13:44 
AnswerRe: Error: Conversion failed when converting the varchar value Pin
Mycroft Holmes8-Jul-16 14:54
professionalMycroft Holmes8-Jul-16 14:54 
GeneralRe: Error: Conversion failed when converting the varchar value Pin
Richard Andrew x648-Jul-16 15:22
professionalRichard Andrew x648-Jul-16 15:22 
GeneralRe: Error: Conversion failed when converting the varchar value Pin
Mycroft Holmes8-Jul-16 22:21
professionalMycroft Holmes8-Jul-16 22:21 
GeneralRe: Error: Conversion failed when converting the varchar value Pin
Richard Andrew x649-Jul-16 5:27
professionalRichard Andrew x649-Jul-16 5:27 
GeneralRe: Error: Conversion failed when converting the varchar value Pin
Mycroft Holmes9-Jul-16 12:31
professionalMycroft Holmes9-Jul-16 12:31 
GeneralRe: Error: Conversion failed when converting the varchar value Pin
Richard MacCutchan8-Jul-16 23:50
mveRichard MacCutchan8-Jul-16 23:50 
GeneralRe: Error: Conversion failed when converting the varchar value Pin
Richard Andrew x649-Jul-16 5:28
professionalRichard Andrew x649-Jul-16 5:28 
Questionsql linq, data duplication on 1 particular record Pin
jkirkerx7-Jul-16 15:06
professionaljkirkerx7-Jul-16 15:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.