Questions tagged as 'mysql'

2
answers

Can I use blob data with Bundle on Android?

I have to upload images to a database (with blob ), but it receives the data from Bundle , I have tried several things and I get an error due to the type of file I try to upload and I would like to know if you can use Bundle i...
asked by 27.07.2017 / 13:48
2
answers

Problem with spaces in Android

I have a form in android which communicates with a WebService to fill a database of MySql , the problem is that when I run the app and write in the editText for example the name, if I write two words the data does not reach MySQ...
asked by 24.08.2017 / 03:13
2
answers

SQL syntax error in MySql [duplicated]

This is the error that presents me when I want to save my data now, sorry that I did not raise it.     
asked by 17.08.2017 / 18:05
2
answers

as I define field timestamp symfony 3 and easyadminbundle

How can I make an entity store a createdAt and updatedAt field with doctrine2 mapped by annotation? ... My entity is User. I'm using easyadminbundle to manage the backend.     
asked by 12.06.2017 / 15:10
2
answers

Get the total of all group by

Do you know how I can get the total of a GROUP BY ? Let me explain: a grouping is made per plan and each plan carries its total; I need to get the total of all that. An example is (plan) (cantidad usuarios no admin) costo plan total...
asked by 06.06.2017 / 06:21
3
answers

separate Date and Time

I have the following with the datetime format create table tabla ( f_inicial date not null , f_final date not null , c_almacen varchar (250), sw_costo smallint, sw_consulta smallint, usuario char(30) not null, sw_...
asked by 15.06.2017 / 23:27
2
answers

How to insert more than 100 thousand records in a table?

I have a ResultSet which brings more than 100 thousand data in total to be inserted, the problem is that my method inserts value by value in the query since there are fields that are empty, the method is as follows, only It's a portion: try...
asked by 18.11.2016 / 17:29
3
answers

Compare arrays in python

I have a problem when I want to compare two results obtained from two different sql queries; example queryUno[0] and queryDos[0] . It turns out that I tried to use list(set(list1).difference(list2)) and it did not work bec...
asked by 09.11.2016 / 21:26
3
answers

MySQL: Tables for user types

I need to implement a login, but I have several types of Users, so to know what kind of users they are, I must make 3 queries (because they are 3 types of users) since I have a Users table to which the 3 tables ( Professor, student and attorney)...
asked by 15.03.2017 / 22:55
3
answers

Show query by current date

I would like to show a query for the current date, because when I save in my table I have the field fecha and it is type date . The format to show and save the date is this: void cargar() { Calendar cal = new GregorianCale...
asked by 27.02.2017 / 05:26