Most voted "mysql" questions
Mysql is a relational database management system (RDBMS) that functions as a server, and provides access to multiple users simultaneously. Your source code is available under the GNU General Public License.
Learn more…10,264 questions
Sort by count of
-
1
votes1
answer45
viewsSubmit form and update content from div
I have two select option with districts and counties. Through JSON I can filter the districts with the counties only that now I want to search the database. I want to submit the form with the two…
-
1
votes1
answer3970
viewsPopular table with PHP and JSON
I am developing a system that has a client table, this table was not developed by me, so I am having some problems to popular. Visually the table works perfectly, but when I try to popular with…
-
1
votes1
answer340
viewsWeb Service returning invalid value
Good people, recently I asked a question with the title: Application displaying this error: Error Parsing data org.json.Jsonexception But by researching I came to a different conclusion in which I…
-
1
votes2
answers96
viewsInsert into multiple tables
I am wanting to do the following Insert in Mysql CREATE PROCEDURE cadastroLocal (var_localNome varchar(80), var_horainicial TIME, var_horafinal TIME, var_periodoemminutos INTEGER, var_diasdasemana…
mysqlasked 10 years, 1 month ago Jessé Filho 23 -
1
votes0
answers44
viewsStrip_tags + htmlentities - No connection to the variable
I have the following problem. I have a database connection, which uses a function called $FLD to bring the fields I want: $FLD="idfca, dtafca, solfca"; After that I am publishing the $FLD for a…
-
1
votes1
answer250
viewsHow to use Foreign key in SQL statements?
I’m wanting to use Foreign key but I’m not getting it. This instruction SQL will create a table called tbl_estado with 4 columns id, nome, uf, pais and in the column pais will enter the key Foreign…
-
1
votes3
answers211
viewsHow to go through the tuples for an ID and check their values?
In a table where I record the amount of plots and the situation of each of them, I need to go through it and find the sales orders where all plots are paid. Ex: SELECT * FROM tabela_parcelas WHERE…
-
1
votes2
answers421
viewsMore than one table in the query - LEFT JOIN SQL
Help with SQL: Query: SELECT * FROM concursos LEFT JOIN concursos_categorias ON concursos.id = concursos_categorias.idConcurso LEFT JOIN categorias_concursos ON concursos_categorias.idCategoria =…
-
1
votes1
answer105
viewsReplace String in Mysql
I’m doing a query in a table. The field filiais returns the following value ["005","001"] I wanted to directly in the query turn this string(varchar) into: ['005','001'] With the simple quotes My…
mysqlasked 9 years, 9 months ago Silvio Andorinha 8,394 -
1
votes1
answer1769
viewsHow to insert UUID automatically into a Mysql Database?
Is there any way to insert a UUID automatically in a table field, in the same way as with a field of the type AUTO_INCREMENT? In a framework for PHP, Cakephp, when defining the primary key as…
-
1
votes1
answer50
viewsMysql - Reading data in a string
There is a Cost Center table called "ccusto", in it, contains Ids ("code" field) that would like to be returned in a SELECT. However, the data needs to be compared to a string with comma separation,…
-
1
votes2
answers1599
viewsUpdate Mysql data with Ajax
I have an ads table with a field called highlight, by default its value is 0. I list all the ads on a table in HTML. I wanted to make when the user click on "Enable highlight" it send an update in…
-
1
votes2
answers219
viewsTool to debug a stored Procedure on linux
would like to know if anyone knows or even used any tool to realize a debug in stored procedures in linux. I am currently using the Mysql Workbench and the Dbvisualizer, but as far as I know none of…
-
1
votes1
answer300
viewsHow to compare post time interval since it was published ?
Good staff, I have a table where I create the posts in which each and added the date it was published, now I need to create a system for the post to appear how long it was published like facebook I…
-
1
votes2
answers1049
viewsSmart session with Codeigniter
I have an application developed with Codeigniter, PHP and Mysql. The user’s session has always been treated according to the Codeigniter standard, but now I need the session to be more restrictive,…
-
1
votes0
answers49
viewsBackup System in Php and Mysql (with Codeigniter)
Intending to put in my software a database backup system, where the user will perform this backup manually. Only I have never done this procedure, and I am using the Codeigniter framework. Could…
-
1
votes2
answers142
viewsInsert time function value in mysql
I think my problem is simple, I’m trying to insert into the database through the function time() but does not insert values. Code $time = time(); mysql_query("INSERT INTO posts (user_id,…
-
1
votes1
answer601
viewsMysql - How to Enable Federated?
How can I enable Federated in mysql on windows and how to use?
mysqlasked 9 years, 8 months ago Mauricio Ferraz 2,074 -
1
votes1
answer51
viewsSeveral cities in one project
Good Afternoon! I wanted some tips. I am developing a project of a classified site, I want to use it with several cities here in the region, as I can do so that on the same site the user select his…
-
1
votes1
answer43
viewsHow to insert into bank with Prepared statements? Problem with ID
I’m having trouble counting columns because I don’t know how to input the data by PDO when you have a id AUTO_INCREMENT that comes before the variable nome. I don’t know exactly how to insert the id…
-
1
votes1
answer112
viewsData grid with function 0 in the rest PHP or PHP+Ajax
I’m an Intermediate Programmer, and I’m at an impasse, I need to display some items and what’s missing I need you to fill out with a mayor model. Let’s explain the logic ok? In My Table (I will use…
-
1
votes2
answers14029
viewsMysql - Create temporary table according to dynamic SELECT
Is there any way to create a temporary table according to a select with columns created dynamically, as shown in the examples below? ex: SELECT idCentroCusto, 'Dez/14', 'Jan/15', 'Fev/15', 'Mar/15',…
-
1
votes1
answer238
viewsRelationship Tables
I have a table Endereco which serves as much to Funcionario how much for Supplier: 1 Funcionario possui 1 Endereco 1 Fornecedor possui 1 Endereco How I create this relationship without having…
-
1
votes1
answer89
viewsPython - Convert mysql datatime
I am trying to compare the current date with the date of the last entry of my mysql database: sql2 = "SELECT created_at FROM tempaverage WHERE created_at IN (SELECT max(created_at) FROM…
-
1
votes1
answer3146
viewsPopular table with HTML table data
I have a table with 4 columns (name, prova1, prova2, simulated). Suppose you are a teacher, and you wish to post student grades. I return to you the following: // $l representará o número de linhas…
-
1
votes2
answers20410
viewsIssue with Discontinued Mysql for Mysqli
I’m having a problem on my site, it all started after I received a discontinuation message from Mysql, and asked me to change to Mysqli, after I change a series of codes appeared on my page, what I…
-
1
votes1
answer681
viewsLoop for adding Mysql fields
Dear, I have two tables, where Tabela1 has columns from A1 to A4, B1 to B4, C1 to C4 and D1 to D4, all of the decimal type (4,2) and with n rows; and the table2 has 3 columns being Total1, Total2…
-
1
votes1
answer571
viewsProblem with cursor in Mysql
Good afternoon! I am successfully creating the following cursor: declare v_cursor cursor for select idCliente, max(dataVenda) from Cliente left join Venda on idCliente = cliente_idCliente group by…
-
1
votes1
answer1795
viewsPDO mysql php accentuation problem
I am using this class to manipulate records in Mysql using PDO http://www.imavex.com/php-pdo-wrapper-class/ But I suggest ééé and inserts me éé at the bank the database is uft8 the script header…
-
1
votes2
answers122
views -
1
votes1
answer582
viewsBackup the database by clicking on a link
I need a superuser of my system to export the database by clicking "backup", and force the download of its script by PHP, as does phpMyAdmin. Is that possible? If so, how? If not, is there any way I…
-
1
votes1
answer221
viewsC# and mysql paging
I have a form and a datagrid, in this form I am using a timer to do a search in mysql that fills the datagrid datasouce, so far everything right. Now I need to limit the amount of research. Ex:…
-
1
votes1
answer1100
viewsSelect with value lookup in another table
I have a table with foreign key fields, and would like to return in a select the value of the item for the key. For example, I have the following table formed with the query: SELECT cod_produto,…
-
1
votes1
answer154
viewsReference the same table twice in another table
My question is this: I have to design a system for a healthcare institution that has internal doctors. There are users, and each user has an internal doctor. Each user also has family doctor of the…
-
1
votes1
answer69
viewskey from the same table
Talk about beauty? I’m doing an infinite category system, so the table has the code and code of the parent category. I wanted to relate these two fields for when I delete a category the child is…
mysqlasked 9 years, 8 months ago Angelo V. Merlo 117 -
1
votes1
answer1126
viewsPrevious registry Mysql
Hello I am trying to see the previous record in relation to the current record. I am using the following Cód. SELECT * FROM Tabela WHERE compoid <"Contraband" ORDER BY compoid DESC LIMIT 1; But…
-
1
votes2
answers1775
viewsbatch file to create mysql database
I’m trying to create a batch file. bat to create the database and then recover formations via sql file, follows file procedure . bat: @echo off cls @echo. @echo Instalando DB cd C:\Program…
mysqlasked 9 years, 8 months ago Artur_Indio 1,093 -
1
votes2
answers2131
viewsSearch between two dates in my database
I was wondering if you could help me solve a problem that I’m having some difficulty solving. The problem is this: I have a database with a table of values in which I store: date: datetime value:…
-
1
votes0
answers506
viewsDbdesigner 4 + Mysql connection problem
I can’t connect the tool DBDesigner with the MySQL. When I try to connect the message appears: dbExpress: Invalid Username/password I found in some forums the suggestion to type in the Mysql prompt…
-
1
votes1
answer255
viewsEquivalent of mysql_result in PDO
I’m trying to move from mysql to Pdo but do not understand how to step that mysql_result to Pdo, I appreciate any help made available $limite = 10; $SQL_COUNT = mysql_query("SElECT COUNT('id') FROM…
-
1
votes2
answers372
viewsPHP in_array() function
I’m developing a system that takes the ID’s from categories that are stored in the database, separated by ,, am using explode, turning them into a arrayand soon after I’m using the function…
-
1
votes1
answer222
viewsDatabase with problems for accentuation
The Mysql database did not have accentuation support, I changed the encoding to the utf8_general_ci standard and now started to display the data correctly in the client, but still the words get…
-
1
votes1
answer94
viewsResult Mysql query different localhost and production
I have a problem in which the same query executed on the local server and production, return a different result. The production version is coming incomplete in the EVALUATIONS field. I checked the…
-
1
votes1
answer1827
viewsHow to create a set of tables in the database via PHP
I’m having problems while creating the database automatically via PHP. I am developing a college MVC project and wanted to import the sql file and through a query create the tables. In the previous…
-
1
votes1
answer445
viewsHow to pass a stored parameter with escaped characters?
I am using php and mysql and would like to pass the following parameter to a stored Procedure $param = "col = '{"video":"<iframe width=\'480\' height=\'600\' src=\'www.qualquercoisa.com\´"}'";…
-
1
votes1
answer1082
viewsPassword check with bcrypt in Session and mysql
I have a user and password that is being saved in a Session, only the password is being encrypted by the bcrypt function. How do I check if the password that is saved in Sesssion is equal to the…
-
1
votes1
answer97
viewsFlash->php->Mysql
Here I am with one more question of actionscript, I’m going to be very objective. In the flash I drew an automobile, the 2 wheels are 1 button, which when clicked performs an sql query to a table…
-
1
votes3
answers98
viewsHow to consult and return all product information?
I have the following problem and I will ask a question in a didactic way so that it can be useful to all users who may need it. I want to conduct a consultation SQL that meets all requirements and…
-
1
votes2
answers582
viewsHow to create a function that returns the lowest expiration date between batches of a given product?
How I create a function that returns the shortest expiration date between batches of a particular product? Dry my SQL code: create database Exemplo; use Exemplo; create table produto (codProduto…
-
1
votes1
answer96
viewsCharset conversion
I have a site to develop for a client and his Mysql database is like this: Database Properties: Character set: latin1-cp1252 West European; Collation: latin1_general_ci The tables are all like this:…
mysqlasked 9 years, 7 months ago Joao Nivaldo 1,229