Getting started Mysql with JSON

-

Getting started Mysql with JSON

Let us create a table playes 


CREATE TABLE `players` (  
  `id` INT NOT NULL,
  `player_and_games` varchar(5000),
  PRIMARY KEY (`id`)
);
 
 
Insert JSON data into table 
 
INSERT INTO `players` (`id`, `player_and_games`) VALUES (1, '{  
    "name": "Sally",  
    "games_played":{    
       "Battlefield": "yes",                    
                                                                        
                              
       "Crazy Tennis": "yes",  
       "Puzzler": {                             
                                                                        
                                                                        
                                                                        
                                                                        
                                                                  
          "time": 7
        }
      }
   }'
)
 
INSERT INTO `players` (`id`, `player_and_games`) VALUES (2, '{  
    "name": "radhey",  
    "games_played":{    
       "Battlefield": "no",                    
                                                                        
                              
       "Crazy Tennis": "no",  
       "Puzzler": {                             
                                                                        
                                                                        
                                                                        
                                                                        
                                                                  
          "time": 7
        }
      }
   }'
) 

Comments

Post a Comment

Popular posts from this blog

MySQL event scheduler and how to create MySQL events to automate database tasks

-
Working with MySQL Scheduled Event  SET GLOBAL event_scheduler = OFF;  SET GLOBAL event_scheduler = ON; MySQL event scheduler and how to create MySQL events to automate database tasks. A MySQL event is a task that runs based on a predefined schedule therefore sometimes it is referred to as a scheduled event. MySQL event is also known as “temporal trigger” because it is triggered by time, not by table update like a trigger. A MySQL event is similar to a cron job in UNIX or a task scheduler in Windows. You can use MySQL events in many cases such as optimizing database tables, cleaning up logs, archiving data, or generate complex reports during off-peak time. MySQL event scheduler configuration MySQL uses a special thread called event schedule thread to execute all scheduled events. You can see the status of event scheduler thread by executing the following command: SHOW PROCESSLIST; By default, the event scheduler thread is not enabled. To enable and start the event scheduler t...
Read more

How to send Send Email with attached CSV file in codeigniter

-
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); class Home extends CI_Controller {     public function __construct() { parent::__construct(); $this->load->helper('url'); $this->load->library('email'); $this->load->helper('file'); $this->load->database(); } public function index() {     $data['rs'] =  $this->db->get('customer_profile');     $this->load->view('home', $data);    } // Download for CSV file. // http://localhost/codeigniterR/index.php/home/csv public function csv($query, $filename = 'CSV_Report.csv') { $this->load->dbutil(); $this->load->helper('download'); $delimiter = ","; $newline = "\r\n"; $enclosure = '"'; $query = $this->db->query("select customeremail as Radhey from customers"); $data = $this->dbutil->csv_from_result($query, $delimiter, $newline); // client ...
Read more

GIT create a new repository on the command line

-
create a new repository on the command line echo "# mynewrepository" >> README.md git init git add README.md git commit -m "first commit" git remote add origin https://github.com/radheymishra/mynewrepository.git git push -u origin master …or push an existing repository from the command line git remote add origin https://github.com/radheymishra/mynewrepository.git git push -u origin master user@user-HP-2000-Notebook-PC:~/Documents/devloper1$ ls user@user-HP-2000-Notebook-PC:~/Documents/devloper1$ git init Initialized empty Git repository in /home/user/Documents/devloper1/.git/ user@user-HP-2000-Notebook-PC:~/Documents/devloper1$ git clone https://github.com/radheymishra/mynewrepository.git Cloning into 'mynewrepository'... warning: You appear to have cloned an empty repository. Checking connectivity... done. user@user-HP-2000-Notebook-PC:~/Documents/devloper1$ git init Reinitialized existing Git repository in /home/user/Documents/devlope...
Read more