Questions tagged as 'mysql'

Tagged questions
1
answer

Remove a foreign key from a server in production?

I have a cad_address table with my users' address record. I also have another request table mov_order that has a foreign key address_id for the address table, responsible for the relationship. The problem is that when the...
asked by 15.09.2016 / 00:50
1
answer

Record selection rule based on date and time

I am developing an online betting system and when selecting the games registered in the system I need to select only the games from the current day onwards, additionally I need to make sure not to select the games that have already started, ie t...
asked by 21.01.2017 / 17:59
1
answer

move_uploaded_file does not move files

I have a form (in php, I wanted to ask if it works without problem?) to insert images (the path of them) and when I enter the inserted in the database but the image does not move to the folder I'm requesting. Here is the code I downloaded...
asked by 06.10.2016 / 10:37
0
answers

How to do a Delete trigger with validations

I have the following problem, I want it after I delete a lease from the leases table I go in the table in the movies and make the situation column stay as available, but in case if I have the movie code in the leases table in another record, I s...
asked by 08.10.2016 / 22:37
0
answers

The loaded screen is correct but the data is saved in another DB table [closed]

On the company website, we're doing some scheduling testing. Problem is that although you are loading the correct screen on the site (the scheduling form), the data that the customer types is being saved in the budget table. Making it clear that...
asked by 19.08.2016 / 02:22
2
answers

Load BLOB for Image C # MySQL

I am trying to load a saved image into MySQL, however still unsuccessful. With the code below I can display all the other fields. Every time I try to add some method to display the image, an error occurs that does not display any search informat...
asked by 03.12.2018 / 01:24
1
answer

View Record of one column in several other columns

I have the following tables:    aud_agendas    users In the aud_agendas table, the condutor and aprovador_lancador columns exist. In the usuarios table, the id and usuario columns exist. I need...
asked by 05.12.2018 / 19:53
3
answers

How to convert a MySQL connection to MySQL? [duplicate]

I decided to listen to some users to make the conversion but I need your help because I have done a lot of research and nothing works. The first file is: <?php include_once("/pasta/connectserver.php"); $table = "rjpsync_tag, rjpsync_i...
asked by 17.09.2014 / 13:47
1
answer

Error reading Like with Timestampdiff

Good People Visual Studio can not read the column Days to do a search with like and gives error! I believe he reads the code at once and does not find Dias created with TIMESTAMPDIFF (DAY, Date_date, Date_of_promise). How could I organize the a...
asked by 14.07.2016 / 13:05
0
answers

Efficient search with phrase and keywords

I'm using the following syntax in SQL for searches: SELECT * FROM exemplo WHERE MATCH(title,content,tag) AGAINST(?) Regarding LIKE I had a better result, but it's still not 100%. For testing purposes, I have a title-only record with the...
asked by 23.07.2016 / 01:32