Tag - MySQL Database

Ezeelive Technologies provided all types mysql database solutions in india, we are expert in database migration, opmisation for speedup websites or applications.

JSON versus XML - json web service php

JSON – its advantages and disadvantages

JSON (JavaScript Object Notation) stands for Javascript Object Notation which is light-weighted designed such that humans can easily read data interchange and its execution. The JSON format was originally specified and developed by Douglas Crockford, and is described in RFC 4627 license. The JSON filename extension is .json. JSON is based on the object notation of the JAVASCRIPT language and its standard only. However, it does not require JavaScript to read or write because it is made in text format which [...]

Ezeelive Technologies - MySQL versus MongoDB database

MySQL versus MongoDB Database – Which one is winner and looser based on performance

When MongoDB comes in mind then everyone start thinking that it’s just a NoSQL database but no one think that why it was developed and what its benefits over the MySQL. In this Article we will first demonstrate that what these both things are i.e MySql and MongoDB because MongoDB is little new so we have first read about its definition. MySQL Database: MySQL is a open source relational database management system (RDBMS) which is based on Structured Query Language (SQL). [...]

PHP MySQL Web Development India - Ezeelive Technologies

MySQL – finding values in comma seperated string

MySQL is very strong, popular database stytem using for mainly in PHP MySQL web development solution. In web application development sometime developer store data in comma(,) or pipe (|) etc formats. Finding value(s) from comma seperate MySQl has REGEXP (Regular Express) function. Use this function developer can search or filer one or multiple string value in your field data. Given below example to understand in detail how to use finding value(s) from comma seperate in MySQL Database field. MySQL database [...]

sqlserv extenstion in phpinfo magento developer in mumbai - ezeelive

Install Microsoft SQL Server Driver with WAMP

Install Microsoft SQL Server Driver with WAMP - Most of PHP developer very much familiar with MySQL Database but We talk about Microsoft SQL Server we find lack for knowledge on PHP with SQL Server even on the google and php.net official website. Even the hosting company provide Pre-installed PHP and MySQL on the Server. Here some explicit instructions for install Microsoft SQLServ Driver in WAMP 32bit with PHP 5.3 : 1. Open http://www.microsoft.com/en-us/download/details.aspx?id=20098 for Download Microsoft SQLServ PHP Driver 2. [...]

mysql database find replace - ezeelive technologies

Find and Replace Data in MySQL Database

Here the below examples To find a string in a certain field and replace it with another string in MySql Database Single Row : update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]'); Multiple Row : update [table_name] set [field_name_1] = replace([field_name_1],'[string_to_find_1]','[string_to_replace_1]'), [field_name_2] = replace([field_name_2],'[string_to_find_2]','[string_to_replace_2]') ....; Condition : update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]') WHERE [condition];