Questions tagged as 'mysql'

1
answer

Why can not I insert more than 253 records in mysql?

Hello friends I am trying to insert several records at the same time but when generating this script it only allows me to insert a maximum of 253, where I send by means of POST the amount of 500, which I can be doing wrong? if(isset($_POST["id...
asked by 03.06.2016 / 21:47
2
answers

Obtain the list of patients that have been dealt with by a doctor, contanto the total number of appointments previously made in MySql

I need to obtain the list of patients from a doctor, and in that list totalize the times that patient has been treated with that doctor (status = 4), but there are patients who have not yet been seen by the doctor because they have the time in t...
asked by 23.09.2018 / 17:57
3
answers

codeigniter: change from one view to another

I have a question, I am using codeigniter and I want to do the following, in the model I make a query which I charge in array in the index of my controller, which later I show it in a table through a foreach in the vi...
asked by 20.12.2016 / 02:28
3
answers

Local Database in Java

I want to develop a website that works with MySQL, but at the same time I want that platform to be used from a desktop software. I'm doing it with java, and I'm new to that, I want to know how I could use a fully local database with java, whic...
asked by 21.09.2016 / 18:31
2
answers

How to execute a Mysql Script from java in linux?

I'm trying to execute a script .sql generated with MySQL from a java application, I have read and researched different ways to do it and I have found several options (none of which had worked for me) and I found the following block of code : p...
asked by 14.01.2018 / 07:21
2
answers

Problem in query mysql php pdo the data is repeated

Companions of StackOverFlow, I have the following question, I am trying to make a simple system of test or evaluation in php and create my database in the following way: +----------------+ | Tables_in_game | +----------------+ | answers...
asked by 24.04.2018 / 20:37
1
answer

Is it possible for a stored procedure to work with two databases?

I've been searching but I have not found exactly what I'm looking for. I have two databases, let's call them Base1 and base 2 and a stored procedure that executes in base 1 , this base has a series of mirror tables that lo...
asked by 24.04.2018 / 12:23
4
answers

Select two columns with the same name from two different tables

If I have two tables that have a column called direccion , and I want to take only one of them as I do?    Client table: ID, address, level, mail, password, name       Company table: EID, address, name What I want to do is: SELEC...
asked by 12.01.2017 / 17:13
3
answers

How is the usign (MySqlConnection) C # used?

Hi, I want to know the correct way to implement the using (MySqlConnection cn = new MySqlConnection() It is assumed that when creating a connection within this using when I finish executing what is inside the block I will release...
asked by 28.11.2016 / 21:06
4
answers

How to make a query WHERE NOT EXIST after an INSERT in SQL

I have problems with the following query: INSERT INTO 'pasajeros' ( 'nombre','apellidos','email','password','telefono') VALUES ('Alexandra','Gonzalez','[email protected]','1234567!','04242344556' ) WHERE NOT EXISTS ( SELECT * FROM 'transportista...
asked by 16.03.2017 / 21:04