Tagged: mysql

0

Codeigniter insert if not exist and update if not

  First you need to check whether the user or data is exits or not. then you can perform the update and insert operation. $this->db->where(‘user_id’,$id); $q = $this->db->get(‘profile’); if ( $q->num_rows() > 0 )...

Configure ejabberd xmpp on ubuntu server part-2 0

Configure ejabberd xmpp on ubuntu server part-2

configure ejabberd xmpp ubuntu server part 2 In First Tutorial we have configure ejabberd XMPP with default menisa database . now in this tutorial i will explain how to configure ejabberd with MySql ....

Configure ejabberd xmpp on ubuntu server Part-1 0

Configure ejabberd xmpp on ubuntu server Part-1

Configure ejabberd xmpp ubuntu server     After facing so many issues and investing so many hours I write below steps for configure ejabberd. In first tourial we learn how to configure ejabbere on...

Joomla Last Database Query 2

Joomla Last Database Query

Joomla Last Database Query     Joomla last database query.As we all know it is a bit difficult to find last executed query in CMS. because there are lots of internal trigger and threads...

recursive function getting parent child 28

recursive function getting parent child

recursive function getting parent child A recursive function is a function that calls itself during its execution. This enables the function to repeat itself several times, outputting the result and the end of each...

mysql queries 0

mysql queries

mysql queries 1. Add column age and desg in emp_prof table. Mysql> use profile; Mysql>alter table emp_prof add column age int; Mysql> alter table emp_prof add column desg char(10); 2. Update all records of...

select a field which contain multiple value 0

select a field which contain multiple value

select a field which contain multiple value ,mysql query for searching a field that contain multiple value seprated by comma id name colors 1 kapil 1,2,3 2 mohit 2,1 3 deepak 1,3 [crayon-5ba30dec4bf14165046624/]