Tags » Mysql

mysql bagaimana query mengambil tiga kata pertama dari string

Bagaimana ya, cara mengambil tiga kata pertama dari sebuah field yang bertime string ?

Bismillah

q> tadi ada yang tanya di forum mysql Indonesia (fb),

57 more words
Database

continuous scrolling. AJAX, PHP, JAVASCRIPT, MYSQL

I am actually creating a forum. So, there would be a “order by” dropdown box i.e a select tag in html. Where the user selects any order like by time or like, etc. 371 more words

Recent Questions - Stack Overflow

Standardizing Database Interactions Using ORM

One of the many obstacles that data driven software engineers face during their career is interacting with a database.  In today’s hyper evolving technology cosmos you may have missed the memo – ORM’s ROCK!   632 more words

Coding

Plain code answers: How to write MySQL connections and queries using PHP's PDO class

You’ve probably heard that the best way to prevent SQL injections is to use prepared statements and PDO. But if you’ve been trying to find a straightforward answer on exactly HOW to do that, you may (like me) have gotten confused by the tutorials online. 491 more words

Code

Ubuntu Basic Commands [Various Setups]

This post is for all developers who switch from Windows to ubuntuThat time set up of various software becomes tough. You will search many sites and get information. 569 more words

Java

Introduction

Greetings! Welcome to Construe IT Solutions (CITS) Private Limited.

CITS consults in Business Process Management, Automation of Business Processes and Process Optimization Procedures.

CITS was founded with an objective to provide the… 170 more words

Business Applicaitons

MySQL, split column data and get result by splitted data

i have a MySQL table data like below

+--------------------------+
| period                   |
+--------------------------+
| 2014-11-27 to 2014-11-28 |
| 2014-11-09 to 2014-11-09 |
| 2014-11-07 to 2014-11-07 |
| 2014-11-06 to 2014-11-06 |
| 2014-11-04 to 2014-11-04 |
| 2014-11-02 to 2014-11-02 |
| 2014-11-01 to 2014-11-02 |
| 2014-10-24 to 2014-10-24 |
| 2014-10-23 to 2014-10-24 |
| 2014-10-23 to 2014-10-24 |
| 2014-10-23 to 2014-10-23 |
| 2014-10-23 to 2014-10-23 |
| 2014-10-20 to 2014-10-20 |
| 2014-10-18 to 2014-10-18 |
| 2014-10-17 to 2014-10-17 |
| 2014-10-13 to 2014-10-13 |
| 2014-10-13 to 2014-10-13 |
| 2014-10-09 to 2014-10-10 |
| 2014-10-06 to 2014-10-07 |
| 2014-10-01 to 2014-10-10 |
| 2014-09-30 to 2014-09-30 |
| 2014-09-24 to 2014-09-24 |
| 2014-09-12 to 2014-09-12 |
| 2014-09-12 to 2014-09-12 |
| 2014-09-08 to 2014-09-09 |
| 2014-09-08 to 2014-09-08 |
| 2014-09-08 to 2014-09-08 |
| 2014-09-01 to 2014-09-01 |
| 2014-09-01 to 2014-09-01 |
+--------------------------+
… 57 more words
Recent Questions - Stack Overflow