Showing posts with the label MySQL - (en)Show all
3/20/2014
MySQL: Insert... on Duplicate Key Update
English Tutorial

MySQL: Insert... on Duplicate Key Update

rani

Continue from Insert Ignore . Insert ignore check based on unique or primary key. We need syntax …

Read more
3/20/2014
MySQL Insert Ignore
English Tutorial

MySQL Insert Ignore

rani

Have you ever heard? If not, Me neither... hehe... I just found out when there was user request t…

Read more
3/20/2014
MySQL Table Join with Different Databases
English Tutorial

MySQL Table Join with Different Databases

rani

I'm trying to give an example how to join 2 tables from different database using MySQL. Here i…

Read more
3/19/2014
SQL SELECT RANDOM ROW
English Tutorial

SQL SELECT RANDOM ROW

rani

This sample is query to randomly select a row of data on a MySQL table: SELECT column FROM tab…

Read more
3/19/2014
MySQL: Update Value from Another table
English Tutorial

MySQL: Update Value from Another table

rani

Sometimes we need to update value from value of another table. For detail explanation I'll sho…

Read more
3/18/2014
Error MySQL: Table marked as crashed and should be repaired
English Tutorial

Error MySQL: Table marked as crashed and should be repaired

rani

Have you ever had an error with the following error message ? #1194 - Table 'nama_tabel&…

Read more