Lab Sql

I've been using Cordova and the storage adapter for SQLite. When I store objects using JSON.str… Read more Issue Storing Arrays In Sqlite Using Javascript

Essentially my problem is that I am returning a resultset from a jdbc query and i want to store eac… Read more Store Each Row In A Resultset As An Object In An Array

I have this array from a json object: [1, 9, 12] Since it uses the square bracket notation because … Read more How To Turn A Simple Json(b) Int Array Into An Integer[] In Postgresql 9.4+

I'm working on a PHP app which requires various settings to be stored in a database. The clien… Read more Php/mysql - Storing Array In Database

I have a column with numeric[] values which all have the same size. I'd like to take their elem… Read more Vector (array) Addition In Postgres

Hi this is my code List listA = new ArrayList (0); String[] arrA = new String[100]; listA.add('… Read more Java.sql.sqlexception: Fail To Convert To Internal Representation: While Passing Arraylist To Oracle.sql.array

I'm trying to show demand for exams of different levels in different locations. I have some co… Read more Loop Through Nested Array To Generate Tables Of Different Lengths

I have a table that contains JSON objects. Each JSON object contains an array in square brackets, s… Read more Sql: Explode An Array

SELECT query I am using: SELECT ARRAY[table_name,pg_size_pretty(table_size)] FROM ( SELECT … Read more Array Not Being Returned By Select Query Inside Plpgsql Test Case

I have the following values ​​inside a cell of a json column in MySql: { 'produttori': … Read more Check If An Element Is Contained In The Values ​(array) Of A Json Column In Mysql

cant fine the error,can some one help me? $sql_project_material = 'SELECT * FROM project_materi… Read more Fatal Error: Call To A Member Function Fetch_array() On A Non-object In

How can I handle an array in a prepared statement? i.e, I want to do a query and one of the paramet… Read more Java - Prepared Statements And Arrays

I am trying to iterate an dynamic array as input for select query. The select query is not firing f… Read more Issue With Loop The Select Query In Sqlite?

I am working with T-SQL and I have a table that looks like Matrix (8x8). My objective is to make th… Read more Sql Matrix To Array

Is it possible to do something like the following in PHO I return an array from my DB that looks li… Read more Php Rotate And Adding To An Array

I have a table in hive , with 2 columns as col1 array and col2 array . Output is as shown below co… Read more Hive Sort Array Column With Respect To Other Array Column In Same Table

I have documents with a simple (string-)array property. { 'id': 'one', &#… Read more Documentdb Queries With Arrays

I have the following query: select * from cars where make in ('BMW', 'Toyota', &#… Read more Sql Server Store Multiple Values In Sql Variable

Following tables: CREATE TEMPORARY TABLE guys ( guy_id integer primary key, guy text ); CREATE TEMP… Read more Distinct Values From An Array?

I have a VARCHAR of numbers inside my stored procedure, these numbers are organized as arrays, I wi… Read more Iterating On Each Element From An Array Of Arrays On Postgresql