Questions tagged as 'sql'

Tagged questions
1
answer

I can not insert simple text into mysql with column text [duplicate]

I'm not able to do a simple update to a table that contains a TEXT column. I put a simple Spanish text however the sql returns me error saying that line is too large. But it is a very small phrase. Here is the error code: SQL query error...
asked by 17.06.2014 / 13:51
0
answers

Error in a Trigger involving Linked Server

I created a Trigger that fetches data from a SQL Server table and writes or updates data from another table in Oracle if there is a change. All this via LinkedServer. But running it generates the following error:    The OLE DB provider "OraOL...
asked by 02.06.2014 / 16:52
0
answers

Creating a Network Panel in PHP

I have the following question I have an oracle database with all the names and ip of the users. I would like to use this database in this code instead of using this array would like? <!-- painel.php --> <html> <head> <ME...
asked by 18.12.2014 / 13:25
1
answer

How to transform an output from an already xml query into Informix?

It is possible to take any exit from a query directly from the bank and to bring the result already formatted into XML text? This using IBM Informix v11.50 database and native mode in the database. Where instead of the database returning...
asked by 03.04.2014 / 01:46
1
answer

XML import for Oracle tables

. Hello, I need to import an XML file into an oracle table. There are several examples on the internet, but none of them worked for me. In general, I'm having the error: LPX-00210: expected '<' instead of '�' ORA-06512: at "SYSTEM.LOAD_XM...
asked by 30.06.2014 / 00:32
1
answer

Select Format yyyy-MM-dd HH: mm: ss in MYSQL table column

Date 2014-12-01 10:52:38 2014-12-01 10:52:14 2014-12-01 10:51:57 2014-12-01 10:35:34 2014-12-01 10:23:17 2014-12-01 10:22:18 2014-12-01 09:03:49 2014-12-01 08:53:51 I have this column with these dates and I need to do a select that filters...
asked by 26.01.2015 / 17:30
0
answers

Add line automatically

I wanted a sql script or excel function that runs the line and when I find "Out of Compliance" add me a new line Name Food from Approved Source (C) Food Protected from Contamination (C) 16 HANDLES Out of Compliance...
asked by 26.01.2015 / 02:29
1
answer

Restore a PostGis dump 2

I'm trying to restore a dump from a postgresql database with postgis template. When I try to restore the dump by terminal, I have a series of errors. Terminal used command:    psql archeology -U cc1295225 -h 127.0.0.1 -p 45432 < exits_o...
asked by 11.02.2014 / 21:14
1
answer

How to make a query in the database 10 days ahead and 10 days behind the current date?

Today I can do the query 10 days ago as shown in the query below, I just can not deploy the 10 days ahead of the current date. SELECT 'vw_saldobancario'.'contaApelido', 'vw_saldobancario'.'tipoMovimento', 'vw_saldobancario'.'hist...
asked by 29.11.2018 / 15:09
1
answer

Select records between two dates with pre-established minute intervals

I have a table that stores data collected at 5-minute intervals. I would like to select the records between a start date / time and end date / time. Until then I can do it. But I would like to include a third parameter in the query that would be...
asked by 30.01.2018 / 14:41