Tag: INSERT

Feed: Planet MySQL; Author: Vitess; Previously posted on link at Nov 3, 2020.Traditionally, MySQL has been used to power most of the backend services at Bolt. We’ve designed our schemas in a way that they’re sharded into different MySQL clusters. Each MySQL cluster contains a subset of data and consists of one primary and multiple replication nodes.Once data is persisted to the database, we use the Debezium MySQL Connector to capture data change events and send them to Kafka. This gives us an easy and reliable way to communicate changes between back-end microservices.Vitess at BoltBolt has grown considerably over the ... Read More

Feed: Recent Announcements. You now can use PartiQL (a SQL-compatible query language)—in addition to already-available DynamoDB operations—to query, insert, update, and delete table data in Amazon DynamoDB. PartiQL makes it easier to interact with DynamoDB and run queries in the AWS Management Console. Because PartiQL is supported for all DynamoDB data-plane operations, it can help improve the productivity of developers by enabling them to use a familiar, structured query language to perform these operations.  ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Overview MindsDB is a third-party application that interfaces with MariaDB Server to provide Machine Learning capabilities through SQL. The interface is done via the Connect Storage Engine. Installation To get a functional MariaDB - MindsDB installation, one needs to install the following components: MindsDB connects to MariaDB Server via a regular user to setup a dedicated database called mindsdb. Which user will be used is specified within MindsDB's configuration file. For example, if MindsDB is installed locally, one can create a user called mindsdb@localhost. MindsDB only authenticates via the mysql_native_password plugin, hence ... Read More

Feed: Neo4j Graph Database Platform. Author: David Penick. More people than ever have important data in a graph. So how can they view that data in their favorite BI tools?The Neo4j BI Connector delivers direct access to Neo4j graph data from business intelligence (BI) tools such as Tableau, Looker, TIBCO Spotfire Server and Microstrategy. It’s the first enterprise-ready, supported product to deliver connected data results to BI users avoiding coding, custom scripting and ungoverned access.In this second blog of our five-part series on the BI Connector, we cover how it can assist you in rooting out money laundering, aiding in ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; All together now Let’s now put together all that we’ve learned in InnoDB Data Locking – Part 2 “Locks” about table and record locks to understand following situation: mysql> BEGIN; Query OK, 0 rows affected (0.00 sec) mysql> SELECT * FROM t FOR SHARE; +----+ | id | +----+ | 5 | | 10 | | 42 | +----+ 3 rows in set (0.00 sec) mysql> DELETE FROM t WHERE id=10; Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t VALUES (4); ... Read More

Feed: Planet MySQL; Author: Michael McLaughlin; -- Use sakila database. USE sakila;   -- Add a prequel_id column to the sakila.film table. ALTER TABLE film ADD (series_name varchar(20)), ADD (series_number int unsigned), ADD (prequel_id int unsigned);   -- ALTER TABLE film   -- Set primary to foreign key local variable. SET @sv_film_id = 0;   -- Insert Harry Potter films in sakila.film table with classic values clause. INSERT INTO film ( title , description , release_year , language_id , original_language_id , rental_duration , rental_rate , length , replacement_cost , rating , special_features , last_update , series_name , series_number , prequel_id ... Read More

Feed: Planet PostgreSQL. Well, we've already discussed isolation and made a digression regarding the low-level data structure. And we've finally reached the most fascinating thing, that is, row versions (tuples).Tuple headerAs already mentioned, several versions of each row can be simultaneously available in the database. And we need to somehow distinguish one version from another one. To this end, each version is labeled with its effective "time" (xmin) and expiration "time" (xmax). Quotation marks denote that a special incrementing counter is used rather than the time itself. And this counter is the transaction identifier.(As usual, in reality this is more ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Syntax CAST(expr AS type) Description The CAST() function takes a value of one type and produces a value of another type, similar to the CONVERT() function. The type can be one of the following values: The main difference between CAST and CONVERT() is that CONVERT(expr,type) is ODBC syntax while CAST(expr as type) and CONVERT(... USING ...) are SQL92 syntax. In MariaDB 10.4 and later, you can use the CAST() function with the INTERVAL keyword. MariaDB starting with 5.5.31Until MariaDB 5.5.31, X'HHHH', the standard SQL syntax for binary string literals, erroneously worked in ... Read More

Feed: Planet MySQL; Author: Johannes Schlüter; Recently the MySQL Database Service (MDS) was launched in Oracle Cloud Infrastructure (OCI). As Cloud is about automation you don't have to use the Web Console to configure your instances, but can do it via API, for instance with the oci command line tool or your favorite programming language. However often it is nice to define the world in a declarative way ("I want a network, like this, and a MySQL database like that") and let the tool figure out how to align the reality in the cloud with your wish. A tool doing ... Read More

Feed: AWS Architecture Blog. Enterprise AWS customers are often managing many accounts under a payer account, and sometimes accounts are closed before Reserved Instances (RI) or Savings Plans (SP) are fully used. Manually tracking account closures and requesting RI and SP migration from the closed accounts can become complex and error prone. This blog post describes a solution for automating the process of requesting migration of unused RI and SP from closed accounts that are linked to a payer account. The solution helps reduce manual work and loss of unused RI and SP due to human error. The solution automatically detects newly ... Read More