Tag: query

Feed: Planet MySQL; Author: Hardik Savani; In this example, we will learn how to get current month data in codeigniter. we can get current month data using codeigniter query builder. we will use MONTH() and YEAR() mysql function for getting current month data.I will share with you simple example example of getting current month data in codeigniter 3 application. sometime it might be require to get and display only current month data in your php codeigniter 3 application.You can see bellow example database query to getting current month data from database items table.Example:$data['data'] = $this->db->select('*') ->where('MONTH(created_at)', date('m')) ->where('YEAR(created_at)', date('Y')) ->get("items") ... Read More

Feed: Planet PostgreSQL. proposed by PostgreSQL contributor Alvaro Herrera. BRIN stands for “Block Range INdex”. A block range is a group of pages adjacent to each other, where summary information about all those pages is stored in Index.  For example, Datatypes like integers – dates where sort order is linear – can be stored as min and max value in the range. Other database systems including Oracle announced similar features later. BRIN index often gives similar gains as Partitioning a table.BRIN usage will return all the tuples in all the pages in the particular range. So the index is lossy ... Read More

Feed: Redis Labs. Author: Chris Cheung. At RedisConf19, we officially released a new module called Redis Gears. You may have already seen some other modules by either Redis Labs or the community at large, but Gears will defy any expectations you have. It really pushes the limits of what is possible with modules. Gears scripts At first glance, Redis Gears looks like a general-purpose scripting language that can be used to query your data in Redis. Imagine having a few hashmaps in your Redis database with user-related information such as age and first/last name. Here is the execution breakdown for ... Read More

Feed: Cloud – Cloudera Engineering Blog. Author: Shelby Khan. Fig 1 – Architecture Introduction Many of Cloudera’s customers set up Cloudera Manager to collect their clusters’ diagnostic data on a regular schedule and automatically send that data to Cloudera. Cloudera analyzes this data, identifies potential problems in the customer’s environment, and alerts customers, requiring fewer back-and-forths with our customers when they file a support case and provides Cloudera with critical information to improve future versions of all of Cloudera’s software. If Cloudera discovers a serious issue, Cloudera searches this diagnostic data and proactively notifies Cloudera customers who might encounter problems ... Read More

Feed: Planet MySQL; Author: Continuent; Overview The Skinny Tungsten Clustering provides high availability, disaster recovery, and a host of other benefits for MySQL / MariaDB / Percona Server databases. In this blog post we will explore some of the shell aliases I use every day to administer various Tungsten Clusters. Shell Aliases: A Quick Review Quick and Easy A shell alias is simply a way to create a shortcut for frequently-used command sequences. For example, I like to shorten the command clear to cls, i.e. shell> alias cls=clear shell> cls shell> alias cls=clearshell> cls If you create an alias on ... Read More

Feed: Microsoft Azure Blog. Author: Krishna Mamidipaka. Azure Stream Analytics is a fully managed PaaS offering that enables real-time analytics and complex event processing on fast moving data streams. Thanks to zero-code integration with over 15 Azure services, developers and data engineers can easily build complex pipelines for hot-path analytics within a few minutes. Today, at Inspire, we are announcing various new innovations in Stream Analytics that help further reduce time to value for solutions that are powered by real-time insights. These are as follows: Bringing the power of real-time insights to Azure Event Hubs customers Today, we are announcing ... Read More

Feed: Planet MySQL; Author: Meenakshi Agarwal; This tutorial explains MySQL CONCAT() which is a built-in String function. It takes variable no. of strings as input and concatenates them together. We’ll describe the usages of this method with the help of simple examples.MySQL string concatenation is more user-friendly than other databases such as PostgreSQL or Oracle. They provide a string concatenation operator “||” instead of a proper function. However, MS SQL server does the same job using the addition arithmetic operator (+).1. CONCAT() Syntax2. CONCAT() Simple Examples4. CONCAT() with TablesLet’s now go through each of the section one by one.MySQL CONCAT() ... Read More

Feed: Planet MySQL; Author: Monyog; In week 5 of our Benefits of SQL Diagnostic Manager for MySQL (formerly Monyog) blog series, we detail MySQL and MariaDB monitoring features with SQL Diagnostic Manager for MySQL, including real-time monitoring and monitoring MySQL error logs. If you missed it, you can read our previous post on understanding database performance trends.Fast Startup Time to Start Monitoring Database administrators can start monitoring MySQL and MariaDB servers in less than a single minute. The unique architecture and low-footprint of SQL Diagnostic Manager for MySQL enable database administrators to install and configure all of the components that ... Read More

Feed: Mr. Fox SQL. [read this post on Mr. Fox SQL blog] The “modern data platform” architecture is becoming more and more popular as organisations shift towards identifying, collecting and centralising their data assets and driving towards embracing a “data driven culture“. Microsoft Azure has a suite of best-of-breed PaaS based services which can be plugged together by organisations wishing to create large scale Data Lake / Data Warehouse type platforms to host their critical corporate data. When working with customers going down the Modern Data Platform path I often hear very similar questions; What is the most suitable and ... Read More

Feed: Planet MySQL; Author: Meenakshi Agarwal; This tutorial explains the MySQL INSERT command to insert single and multiple rows in a table. Here, you’ll find some unique ways with different variations for adding records with fully working examples.1. INSERT Statement Syntax2. INSERT Single Row3. INSERT Default Values3. INSERT Date Columns4. INSERT Multiple RowsLet’s now read and understand each of the section one by one.MySQL INSERT statementAs stated initially, the INSERT command is a built-in MySQL statement which inserts the specified records into a given table. So, let’s first check the details and see how to use the INSERT command. But ... Read More