Questions tagged as 'sql'

Tagged questions
1
answer

SWT using DATETIME with problem in saving SQL compatible format

The problem is this: I have a personal finance program that will record some important data, including the date of registration and expiration date. The program interfaces are done in Eclipse in SWT , and I'm using the DateTime widg...
asked by 29.05.2015 / 22:18
2
answers

Query to get text after a certain character

Good morning, I need a way to get all the rest of a string after a given character, for example, I have the following database Ineedtoalwayssearchfortheremainderofthestringafterthelast"" " ie for the first line I needed to get all " System acce...
asked by 11.11.2015 / 15:04
1
answer

"complex"

Hello. I'm learning procedures and I have a question: DELIMITER $$ CREATE PROCEDURE 'atualiza_telefone' (IN telefone INT) BEGIN IF (telefone IS NULL) THEN SELECT * FROM cliente; ELSE UPDATE cliente SET telefone = "4444-4444" WHERE seg...
asked by 28.03.2016 / 20:52
3
answers

How to save a base64 image in SQL and save it locally as PNG

I need to know if it's possible to save a base64 image in SQL so I can then retrieve it and save it locally as PNG or JPEG. I already know how to convert to base64, but to download in all browsers this is difficult so I wonder if it is possible...
asked by 01.03.2016 / 15:29
1
answer

Spring MVC getJdbcTemplate insert in Oracle return column value

I have a project in Spring MVC, I'm using getJdbcTemplate to do insert's. I just do not enter the primary key in Oracle from a sequence and need that value to re-insert into another table where that value is a foreign key. For examp...
asked by 21.02.2016 / 13:15
1
answer

Best DB structure with large number of data and filterable columns

I have a Mysql database with a table that is taking a long time to complete a query. I would like to know what would be the best database structure indicated for a table with many fields that are filterable, have more than 5 million records and...
asked by 14.11.2016 / 12:46
0
answers

Service returns cast error when consumed

I decided to make another post, since the subject is another, although in the original post, in the comments we get to touch on the subject, but without depth. I have this error:    System.InvalidOperationException: 'The specified cast from a...
asked by 25.08.2017 / 15:14
3
answers

DELETE FROM users WHERE user_id = $ id

I have a script of simple PHP + MySQL query: <table > <tr> <td ><h2>GERENCIAR ANUNCIOS </h2></td> </tr> <tr> <td > <table > <tr> <th >ID</th>...
asked by 30.01.2015 / 13:02
3
answers

Error creating a MySQL database via PHP in WampServer

I have a problem when creating the database, on the net I found little content about, only meeting how to mount database by phpMyAdmin, but it is via script that I want to create. > I have the following code: <?php $mysqli = new mysqli...
asked by 28.09.2014 / 14:52
3
answers

Problems with SELECT with 2 WHEREs

I have a somewhat amateurish problem here. I can not do this SELECT from 2 CONDITIONS, and I can not find the ERROR! Someone please give me a light there! Follow the Code: OleDbConnection Con = new OleDbConnection(); Con.ConnectionSt...
asked by 26.07.2016 / 22:53