Questions tagged as 'mysql'

Tagged questions
1
answer

Slowdown with group_concat in mysql

I'm developing a system, which in some parts, when I'm going to display the data to the client, I'm using in my query the group_concat since I need to display for an item the items related to it on the same line. This worked very well in that it...
asked by 15.07.2014 / 17:35
1
answer

Inserting data with PHP OO (Similar to EntityManager.persist (Object) java manager)

I would like a hint of how to loop to insert an object into the mysql / postgres database ... Example class User { // PRIMARY KEY public $id; public $login; // PRIMARY FOIREIGN KEY public $people; __construc...
asked by 11.06.2014 / 14:16
1
answer

Insert data from a TXT into a DB

While doing all these conditions, my database is responding in a strange way because literally what I'm selecting is in every line of my .txt file, returns everything, including spaces empty, which was not to occur. Follow the code:  //wh...
asked by 04.06.2014 / 03:53
1
answer

How to correct the error: Schema specified is not valid

I modified the DB for my project and did the update of my edmx file, but now when I try to compile the error is appearing:    No Entity Framework provider found for the   ADO.NET provider with invariant name 'MySql.Data.MySqlClient'.   Make s...
asked by 31.05.2014 / 23:44
1
answer

How do I know if the client is already open on another computer?

I'm making a system that can and will open on possibly 2 to 7 computers. There is concern in the following case: PC1 opened the client's account and started editing. PC4 has opened the client account John just to see some data. PC1 has f...
asked by 23.07.2014 / 16:15
3
answers

Remote Access Mysql Amazon Server

I am not able to connect to a user for remote access in my database. I have already created the user, I gave permission to access any ip (%) - I already gave permissions on the ip that I am using and even then, only the error: (2003) - Can't con...
asked by 29.05.2014 / 22:35
1
answer

Check in the tables that appear in my first DBGrid

Follow the code: var i : integer; begin i := 0; DataModule1.ZConnection1.Database := edtDB.Text; DataModule1.ZConnection1.HostName := edtLocal.Text; DataModule1.ZConnection1.User := 'root'; DataModule1.ZQuery1.Close; DataModul...
asked by 21.05.2014 / 14:01
1
answer

Relate sub query table with main query

SGDB: MySql. PROBLEM: I need to somehow relate the subquery (being table and field highlighted in Functional.codZone1) to the table "Zone", which is in the main query. Is there any way? "ZONE" table: Contains all Zones of the city. Tab...
asked by 15.04.2014 / 17:01
1
answer

SUBSTRING_INDEX with REGEX

How can I do a search for the last name of a people but with a regular expression? Today I use SUBSTRING_INDEX to get the last name , but I want to get parts of this last name when I search by name or fragments of people I am using...
asked by 11.04.2014 / 16:44
1
answer

Retrieve parameter sent to a modal and perform MySQL query

I need to retrieve parameter sent to a modal bootstrap, perform a query in the database and show result in a text field for the user, what I have is this: Sending the parameter to the modal <i class="icon-large icon-book" onclick="VerCo...
asked by 09.06.2014 / 23:58