Questions tagged as 'mysql'

Tagged questions
2
answers

INNER JOIN skips a record

I would like to know what I am doing wrong, I have consulted with inner joins that should show 11 records and only show me 10, the tenth record is skipped, I do not know if I am doing wrong join or I have passed some field, I attach images and m...
asked by 28.09.2018 / 18:17
1
answer

Increase memory for virtual tables in mysql

I'm doing a massive insert to a virtual table in mysql my application falls down because of problems on the server so t 1: it is the connection time 2: memory in the cache is a dedicated server of 1 tera and 8 gb in ram so I want to increase...
asked by 28.09.2018 / 19:07
1
answer

Insert a combobox with the upload files button

Hello good afternoon I have a code that I use to upload files but I need to not only upload files but also upload the combobox because the image goes according to the selection of the combobox someone could help me I have two fields image and im...
asked by 20.09.2018 / 21:43
1
answer

Datatables shows last record of a timer countdown

I have the following problem that I have not been able to solve. I have a timer (countdown) that is generated by each row of the datatables, which come from a database. This works well, the problem is that in all the rows, it shows me the last r...
asked by 21.09.2018 / 18:36
0
answers

Error JIT vs2013

Hello everyone, I have a giant problem, trying to run my application, c # and mysql, made with vs2013 on another computer, it throws me an error window (exception not controlled), in my pc it works fine but in the other two nothing ... I tried i...
asked by 21.09.2018 / 11:52
0
answers

does anyone know how to execute deferred MYSQL queries in PHP?

I have two related tables (Employees with primary key AI and Role with primary key AI and foreign referenced to the primary Employees) and not to generate inconsistencies in the data or in the autoincrementable key I want to do in the same PHP:...
asked by 23.09.2018 / 03:00
0
answers

I want to work with this type of field and what I need to be able to work for a JSON

My connection file is like this: conect.php <?php // Connect PHP PDO $connect = 'mysql:host=localhost;dbname=comidas'; try { $db = new PDO($connect,'root',''); $db->setattribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);...
asked by 21.09.2018 / 01:33
0
answers

Error in new connection to MySQL

Currently I have an application in Visual Basic .NET 2.0 developed in VS 2005, this application attacks a MySQL using the MySQL.Data.dll 6.3.0.4 connector. I have created a new MSSQL Server 2012 virtual machine with MySQL 8.0.12.0. where data...
asked by 21.09.2018 / 09:54
0
answers

error in mysql collation_name

I have an error in MySQL:    error code: 1267 illegal mix of   collations (latin1_swedish_ci.IMPLICIT) and   (latin1_spanish_ci.implicit) for operation '=' I have made a query to show me the tables where collation_name sea = latin1_swe...
asked by 21.09.2018 / 13:22
1
answer

Export query data to CSV format from the MySQL console

I have the following query in MySQL , with which I get the posts associated with the users who created them SELECT users.nameUser, posts.namePost FROM users JOIN posts ON users.id = posts.user_id; However, I need to work directly from...
asked by 21.09.2018 / 15:02