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
answer148
viewsInstallation of Maverick causes the server to stop working
I’m novice with Apples and recently bought a mac book, with Lion operating system. I installed php, mysql, etc and everything worked perfectly. Now I’ve upgraded the system to Maverick and the…
-
1
votes4
answers1290
viewsHow to bring a specific result of an SQL query above the others?
I have the following SQL query: SELECT DISTINCT `user_id` AS `id`, `user_name` AS `name` FROM `users` ORDER BY `id` ASC; That generates the output: +----+--------+ | id | name | +----+--------+ | 1…
-
1
votes2
answers349
viewsDesign table of "workflow"
I’m doing an application in Cakephp and would like your help in what would be the best way to create my database and my relationship between models. It would be a "workflow". I would like it to work…
-
1
votes2
answers234
viewsAuto increment ID value
In my Mysql Workbench I have 4 tables with auto increment id. But when I fill out the form it adds values not followed. For example: I fill out a form for the first time and the ID it puts me is 3.…
-
1
votes3
answers485
viewsHow to select separate records on multiple pages of a PHP pagination?
How to select all records of a pagination? Similar to what gmail does where it always does , when marking checkbox which selects only the one of the current page, a text appears just above to select…
-
1
votes2
answers122
viewsChanges directly in the database reflect in the bean Managed?
I’m developing a simple web application, a form. I did the DAO’s, Facades and they are working correctly (at least I think they are) but I will also need to edit some values directly in the bank…
-
1
votes1
answer2000
viewsCount grouping by week
I have a table in Mysql and am trying to group it by week(it may be week of year) Select count(id),month(data_tarefa), year(data_tarefa) from tarefas group by mes, ano So it works cool, but I would…
-
1
votes2
answers13056
viewsChanging Mysql data in PHP
I have the Tb_workers where it is filled in by a form. And then I created another page to change this data. Altering.php $id = $exibe["id"]; $Nome = $exibe["Nome"]; $Morada = $exibe["Morada"]; $Tipo…
-
1
votes4
answers1855
viewsPHP/Codeigniter error "Array to string Conversion"
I did a foreach to go adding values to an Insert but suddenly an error appeared Array to string Conversion strange and have no idea what it is. public function distribuicaoprodutos(){…
-
1
votes2
answers601
viewsHow to change the location where MAMP creates the database?
I’d like to change the location where the Mamp creates the database. The pattern would be this: /Applications/MAMP/db/ And I would like to create by default the database on my server that would be:…
-
1
votes3
answers1619
viewsInsert data Database Related tables
I’m having trouble inserting data that has related tables. $sqlinsert2 = "INSERT INTO tb_detalhe_trabalhador VALUES(0,NULL,NULL,'".$MedicaValidade."',.. Currently the data that are as NULL are the…
-
1
votes3
answers1494
viewsFilter table before applying a LEFT JOIN
I have two tables and I want all the elements of the first - regardless of the condition of JOIN (which characterizes a LEFT JOIN) - but before that I want to filter the second table. For example:…
-
1
votes2
answers1120
viewsINNER JOIN does not return database result
I’m trying to use this code: SELECT * FROM tb_trabalhador INNER JOIN tb_detalhe_trabalhador ON Tb_trabalhador.id = tb_detalhe_trabalhador.tb_trabalhador_id And it returns the blank result. Is there…
-
1
votes2
answers3447
viewsPDF view in browser
I am searching a way to view PDF file in the browser and print everything through the web (This action will be done by the user). Someone knows a tool that works with it. I’m using PHP and Mysql in…
-
1
votes1
answer1089
viewsCreate 1:1 relation in Query Browser
I would like to know how to create 1:1 relations in Query Browser. I don’t know if I’m right, but he creates 1:n relationships by creating Foreign Keys.
-
1
votes3
answers554
viewsGet the structure of a table through a query
Through Phpmyadmin, accessing a table, we can see the structure of it in the tab structure listing the fields, the types of data each accepts, and other information. How can I obtain through a query…
-
1
votes1
answer164
views -
1
votes4
answers1172
viewsHow to get values separated by "<BR>" in Mysql?
The idea is simple...I need to get values from a table (by performing SELECT) that are separated by <BR> of a STRING field and then store in a table, inserting each separation, a record.…
-
1
votes2
answers10718
viewsSearch the entire database
Is it possible to query or is there a phpmyadmin tool that does this: Query the entire database for example: I have the value 23600 and I want him to find that value in the entire bank independent…
-
1
votes1
answer1026
viewsHow to exchange a charset from a table to utf8 in a latin1 database?
I am trying to change the charset of a table to utf8 in a BD that contains all other tables like latin1swedish. I ran several commands and says it changed, it shows that that table is the only one…
-
1
votes2
answers470
viewsAnalysis on AJAX code
I found this code, which is like a Long Polling, and wanted to know if I might have trouble using it. And I also wanted to know the cons of that code if I were to use it. pagina.html => page that…
-
1
votes1
answer364
viewsHow to get a Mysql output Parameter via C#
I researched and applied what I saw, but is giving error: MySqlConnection con = new MySqlConnection(banco.Conexao); MySqlCommand comando = new MySqlCommand("sp_venda", con); comando.CommandType =…
-
1
votes1
answer412
viewsLIKE query in related table
I have a query that searches for TECHNICAL CALLS and in this research I do some JOINS to bring related information. I need the LIKE to also work for the CLIENT name (which is in another table) The…
-
1
votes2
answers240
viewsQUERY with no expected result, what might be missing?
Complementing with current information, I understood the current result, and what it seems is duplicated information even, but in different tables, but this is not even with me because I already…
-
1
votes1
answer220
viewsCakephp Does Not Display Special Characters Present in Database Content
I get something like: Produ��es - Casamento Catarina & Lu�s _ Caves Taylor�s But the wait was to get : Produções - Casamento Catarina & Luís _ Caves Taylor's This only happens with database…
-
1
votes2
answers2979
viewsView column quantities in each table
How do I get phpmyadmin to show me this: --- tabelas --- usuarios(5) clientes(20) admins(2) for example using some mysql command or even some phpmyadmin functionality?…
-
1
votes2
answers277
viewsQuery using INNER JOIN with problem
I’m making an appointment using INNER JOIN, but when I do the JOIN on the table A with the B and there is no id in the table B, he returns me a array empty. I would like it if it did not find the id…
mysqlasked 10 years, 7 months ago Leandro Costa 2,172 -
1
votes1
answer158
viewsHow to record what is received on an Apache port directly in mysql?
Hello. I have a server Apache (XAMPP) and need to receive messages from a device that sends messages to a specific IP and port. I would like to configure the Apache to listen to a door (443, for…
-
1
votes1
answer84
viewsSUBSTRING_INDEX with REGEX
It has as I make a search of the last name of a people but with regular expression? Today I use the SUBSTRING_INDEX to catch the last name, the more I want to take parts of this last name, when I…
-
1
votes1
answer167
viewsFull query of data registered in a field
I have a table where a country field is defined. I want to know how I can develop a query that shows me how many records I have for each country. Example: Brazil: 10 registrations USA: 5 records…
-
1
votes1
answer1533
viewsList sub-query table with main query
SGDB: Mysql. PROBLEM: I need to somehow relate the subquery (being table and highlighted field Funcionario.codZona1) with the table "Zone", which is in the main query. Is there any way? Table…
-
1
votes1
answer6326
viewsHow to insert an image in Mysql?
I’d like to add images to the table, nothing too complex. I would like to add the directory if possible This bank will not have an interface I’d like to see the image by select, but I don’t think…
-
1
votes1
answer69
viewsHow to pass two tables to one and update codes
Long ago I created two tables, under different names, (for lack of experience), today I noticed that they had exactly the same fields. So I decided to unite them. However, I need to do this without…
-
1
votes3
answers1576
viewsAmazon Server Mysql Remote Access
I am unable to connect to a user for remote access in my database. I already created the user, gave permission to access any ip ( % ) - ja dei permissões em cima do ip que estou usando e mesmo…
-
1
votes2
answers326
viewsDatabase to work with nodejs
I’m developing an entire application with Nodejs. The main reasons for using Nodejs are financial/performance. I have not yet worked with database using Nodejs, but I have some doubts, since the…
-
1
votes1
answer1370
viewsReturn only one item related to the main table
I have two tables, respostas and respostas_log, where I store information of the answers in answers and some others that have to go logging in reply_log. I am needing in my SELECT to bring only the…
-
1
votes0
answers43
viewsDoubt about the use of JOIN...
I wonder if the field in which I should make the comparison, can only be the one that contains the key Primary, or can be any field... Let me give you an example: CREATE TABLE tabela1( idTabela1…
mysqlasked 10 years, 5 months ago Mr. Bownstone 11 -
1
votes1
answer347
viewsDirect sum by SQL query
I wonder if there is a way I can make a simple sum directly by the query, I have a table that contains a sub-table called VIEWS and I would like for each query that I run these VIEWS to increase +1…
-
1
votes3
answers407
viewsCompare form domain with database domain
I need to compare domain sent and processed by a form via $_POST with domains of the database because I can only enter one email from each domain in the database. For this first I took the email…
-
1
votes1
answer82
viewsCheck the tables that appear on my first Dbgrid
Follows the code: var i : integer; begin i := 0; DataModule1.ZConnection1.Database := edtDB.Text; DataModule1.ZConnection1.HostName := edtLocal.Text; DataModule1.ZConnection1.User := 'root';…
-
1
votes3
answers146
viewsHandle single while record
Considering that I am developing a small ranking of simple classification (photo), I need a solution to take the first 3 records of select and apply an individual formatting to them, the others…
-
1
votes1
answer1901
viewsShellrun using CMD to open mysql
Gentlemen, I’d like to ask you if you can use the command cmd to run mysql.exe on it, let me use a line of code: ShellExecute(Handle,'open',PChar('cmd.exe'),PWideChar('/k cd\mysql\bin &…
-
1
votes1
answer188
viewsAccess to Mysql database via the/net connection
I am developing a system that will access the Mysql database only to query data. I referenced the mysql.data.dll and I’m using access through Mysqlconnection. It turns out that the system is…
-
1
votes3
answers2710
viewsHow do I create a view in mysql by taking data from 4 or more different tables?
How can I create a view and show the data as below:…
-
1
votes1
answer76
viewsMysql order by field date original value
I’m doing a query and I’m transforming the data no formato and then I want to use the data_vencimento original in order by but it doesn’t work code: SELECT *,DATE_FORMAT(data_vencimento,'%d/%m/%Y')…
mysqlasked 10 years, 6 months ago Silvio Andorinha 8,394 -
1
votes2
answers1996
viewsQuery PHP data using the $.get json method and list data in an html
I can do data entry but have no idea how to do data selection on a HTML using $.get JSON. Php code public function Inserir($tabela,$sql){ ksort($sql); $Campos_nome= implode('`, `',…
-
1
votes2
answers459
viewsCreating Logs page
I created a table in my database usr_logs with the following columns: id email ip team date sucess These records alone are sufficient, or I need to add something else? How do I display all the data…
-
1
votes1
answer2118
viewsHow to fix the error: Schema specified is not Valid
I modified the BD of my project and performed 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…
-
1
votes1
answer204
viewsSlowness with group_concat in mysql
I am developing a system, that in some parts, when I will display the data to the client, I am using in my query group_concat, because I need to display for an item the items related to it in the…
mysqlasked 10 years, 4 months ago Marcelo Diniz 3,356 -
1
votes1
answer126
viewsReturning NULL
I am using this query: SELECT GROUP_CONCAT(coluna1) as valores FROM arquivos WHERE coluna2 IN (21, 22) It returns column1 values of lines whose column2 has one of the specified values. The problem…
mysqlasked 10 years, 4 months ago marcelo2605 790