Questions tagged as 'mysql'

Tagged questions
1
answer

Query Mysql in Visual Studio does not return all data

I have a problem in Visual Studio, where in my database access class, I have a query that does a query in my Mysql database, and returns only the last result. So, how much do I test this same query directly in the Mysql database, using tools lik...
asked by 30.08.2014 / 15:44
1
answer

How to create columns dynamically with SQL?

I'm running a script that returns me 250 values that will be the columns of a database. I need to create the database if it does not exist or simply truncate it and recreate all tables to update columns that will be added in the future. I t...
asked by 26.12.2014 / 15:45
2
answers

Remove duplicate rows in a MySQL query

I need to do a SQL query where I return the last messages exchanged between users (my account for example) and who I talked to ... regardless of whether the last conversation was sent or received. The code that I am using sends the sent and r...
asked by 13.09.2014 / 15:56
2
answers

How to display two different database tables in php

>     
asked by 09.08.2014 / 16:52
1
answer

Mysql error 1049 how to solve

I had just installed mysql on ubuntu, then rebooted my computer, when I tried to log in mysql gave this error. Can anyone help me? root@wladi-Dell-System-Vostro-3450:/# mysql -r root -p Enter password: ERROR 1049 (42000): Unknown database...
asked by 11.08.2014 / 21:17
2
answers

How to query DB without refresh and write the returned data?

I need to query my database with something like AJAX / JSON I'm not sure and return the result inside a div next to this # . div is already on the side to receive the result of the query. I'm not sure how I can start doing th...
asked by 28.10.2014 / 22:06
2
answers

Great texts in database or just a path to a txt file (Mysql) [closed]

My question is this: Is it better to put huge amounts of text in a database or create a code that works with a txt? (open / save / modify) I've already said code in PhP and I've been using this to prevent the database from getting too large w...
asked by 15.07.2014 / 15:26
1
answer

Changes a relationship between two mysql fields

I have my event table ( tbl_eventos ), where I'm going to fetch the contact_id field from the contacts table ( tbl_contactos ). To go create this link, I used the following: ALTER TABLE 'tbl_eventos' ADD CONSTRAINT 'tbl_eventos_i...
asked by 15.07.2014 / 20:30
2
answers

RAD Studio XE6 does not connect to any database!

Program used: RAD Studio XE6 (32bits). Problem: When creating a new Desktop or Mobile project, when trying to configure the connection to any database, either by FireDAC or dbExpress, the following error occurs: "DBX Error: Driver could no...
asked by 15.08.2014 / 16:10
1
answer

When repairing cause error - 'Lost connection to MySQL server during query' - Aguma Idea?

Follow the code: ZQuery1.Close; ZQuery1.SQL.Clear; ZQuery1.SQL.Add('SHOW TABLES FROM '+zConnRepara.Database); ZQuery1.Open; ZQuery1.First; Progressbar1.Max := ZQuery1.RecordCount; lTemp := ''; Paramet...
asked by 13.08.2014 / 13:41