Tag: INSERT

Feed: Planet MySQL; Author: Dave Stokes; JSON has become the standard document interchange format over the last several years.  MySQL 5.7 added a native JSON data type and it has been  greatly enhanced with version 8.0.  But many in the relational world have complained the the NoSQL approach does not allow you to have rigor on your data. That is to make sure an integer value is really an integer and within specified ranges or string of the proper length. And there was no way to make sure that email addresses are not listed under a combination of E-mail, e-mail, ... Read More

Feed: Planet MySQL; Author: Geir Hoydalsvik; The MySQL Development team is very happy to announce that MySQL 8.0.17 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release.  Please download 8.0.17 from dev.mysql.com or from the MySQL  Yum,  APT, or SUSE repositories. The source code is available at GitHub. You can find the full list of changes and bug fixes in the 8.0.17 Release Notes. Here are the highlights. Enjoy! Provisioning by Cloning We have implemented native provisioning in the server. For example, a newly created, thus empty ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Timestamps in Oracle can have one of three configurations: timestamp, timestamp with timezone and timestamp with local timezone. At first glance timestamp with timezone and timestamp with local timezone would seem to be the same, and they can be. They can also be different based on what timezone the current session is set to use. Basically, timestamp with timezone uses the timesone or timezone offset of the server where the database is running, and timestamp with local timezone uses the session timezone or timezone offset. For local sessions the timestamp values for ... Read More

Feed: SAS Blogs. Author: Kathryn McLawhorn. View more Problem Solvers postsThe RANK procedure (PROC RANK) is useful for ranking numeric variables in a data set across observations. You often see PROC RANK used to rank data into quartiles, deciles, or percentiles. This action requires that you use the GROUPS= option in the PROC RANK statement. This blog answers three questions related to using PROC RANK with groups and ties. Note that question two actually provide an alternative for using the DATA step when PROC RANK cannot provide what you need. What does PROC RANK do behind the code when you ... Read More

Feed: Planet MySQL; Author: Krunal Lathiya; SQL Injection Example | What Is SQL Injection is today’s topic. An SQL injection is a code injection technique that may lead to destroying your database. It is one of the most common web hacking techniques. It can also be defined as placement of malicious code in SQL statements from a web page input. Attackers can use the SQL Injection vulnerabilities to bypass the application security measures. Content Overview #What Is SQL Injection(S.I.) SQL Injection (SQLi) is the type of injection attack that makes it possible to execute the malicious SQL statements. These statements ... Read More

Feed: Planet PostgreSQL. Personally I’m a big fan of email, just like blogging. To me a good email thread can be like a good novel where you’re following along always curious for what comes next. And no, I don’t mean the ones where there is an email to [email protected] and someone replies all, to only receive reply-all’s to not reply-all. I mean ones like started last week internally among the Azure Postgres team. The first email was titled: Random Citus development and psql tips, and from there it piled on to be more and more tips and power user suggestions ... 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: 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: 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

Feed: Planet PostgreSQL. Declarative partitioning got some attention in the PostgreSQL 12 release, with some very handy features. There has been some pretty dramatic improvement in partition selection (especially when selecting from a few partitions out of a large set), referential integrity improvements, and introspection.In this article, we’re going to tackle the referential integrity improvement first. This will provide some sample data to use later for the other explanations. And the feature is just amazingly cool, so it goes first anyway. This example builds on the example given for the Generated columns in PostgreSQL 12 article, where we built a ... Read More