SQL

Featured
SQL
Technology

Tutorial SQL: Select, Insert, Update, Delete

The following tutorial can be used as dictionary for beginner on SQL syntax. SQL syntaxes are used to manipulate data which are select, insert, update, and delete on database. 1. Select Select command is used to get rows of data from table. Syntax: Example: 2. Insert Insert command is used to insert row to table. […]

Read More
Featured
SQL
Technology

How to Insert Data Using Select Query in SQL Server 2005

This guide can be used to insert data into database using select query. Using above syntax, all data in second_table will be copied into first_table. You can also add where keyword. Keywords:sql server 2005

Read More
mysql replace
Featured
SQL
Technology
Wordpress

How to Replace Old Domain URL in wp_posts Table

I migrated my WordPress website to new domain, so I need to update all image URLs in wp_posts, wp_postmeta, and wp_options table which are still pointing to old domain. These are the SQL syntaxs to update the tables:

Read More
Open Source
Programming
SQL
Tips and Tricks

Select Case Sensitive in MySQL

Today I found bug on my website while using MySQL query. I just realized that the search function works in case insensitive. If I execute this query: SELECT filename FROM data_ebook WHERE filename = ‘Manasik_Haji_dan_Umroh.pdf’ the results will be: — Manasik_Haji_dan_Umroh.pdf Manasik_Haji_Dan_Umroh.pdf — By using keyword ‘LIKE BINARY’ it can make the result case sensitive: […]

Read More