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
-
0
votes1
answer5107
viewsHow to average a mysql query result?
How do I get the "Count(t2.id_atend) TOTAL_ATENDIMENTO field " and calculate his PHP media? SELECT t3.desc_serv, t3.nm_serv, t1.nm_usu, count(t2.id_atend) TOTAL_ATENDIMENTO FROM usuarios t1 INNER…
-
0
votes1
answer564
viewsI cannot run DELETE in SQL when submitting form via POST in PHP
I have this code and would like to delete a list of users when the form was submitted, but it is not working: Any hints? if (!empty($_POST['username']) && !empty($_POST['email'])) { $query =…
-
0
votes1
answer786
viewsHighcharts library does not show data
I have the following code in PHP, this code causes you to search the Mysql data and show in a graph in the HTML view. The problem is that the data is not shown on the screen for viewing the end…
-
0
votes1
answer116
viewsMysql connection to Roundcube
Roundcube is a free software Webmail. I need to implement an HTML class for connecting Roundcube to a Mysql database. I have a file that is on the skin/Larry/template/login.html, the idea was to…
-
0
votes4
answers145
viewsHow to define database tables?
I need to compute X hours worked for an X employee in month X. For example, John worked 20 days in January, 12 in February, and so on. To lost in relation to table, create a table only for dates? Or…
-
0
votes0
answers28
viewsDifferent Mysql server error than I configured
I am using PHP and tried to connect to a different server than the one the site is running, using the function: $servidor = "example.com"; $usuario = "meu_usuario"; $senha = "senha"; $conecta =…
-
0
votes1
answer215
viewsmysql connection error with c. Unknown type name 'SOCKET'
I have this code and is generating error. #include <stdio.h> #include <mysql.h> #include <windows.h> #include <sys\socket.h> void main(void) { //parâmetros para Conexão char…
-
0
votes1
answer694
viewsLoad data from a field after pressing a button
I need to load data from a table field. Example: Table (Template), the person is filling out the form and wants to use this template in the Text field, and with this he would click on a button (Load…
-
0
votes1
answer1733
viewsEmoji insertion problems in mysql
I’m having trouble inserting EMOJI emoticons into mysql, it inserts "????" for each Emoticon. My table is already as utf8mb4_bin how do I insert correctly? It will be PHP?
-
0
votes1
answer1195
viewsField 'lastiplog' doesn’t have a default value
I’m experiencing this error when registering Field 'lastiplog' doesn’t have a default value: Code Register.php <? ob_start(); session_start(); ?>…
-
0
votes1
answer335
viewsWhat causes "Call to a Member Function fetchAll() on a non-object in..."?
I made a class for connection to the database using PDO and at the time I will get the data from my table it gives this error. This is the code: require_once('../class/connection.class.php'); $db =…
-
0
votes1
answer674
viewsProblem inserting php mysql ID data
I have a problem entering data in mysql due to table id. Tb_details_worker: id, Name, Function $sqlinsert = "INSERT INTO tb_detalhe_trabalhador VALUES ('','".$Nome1."','".$Funcao1."') Error: Column…
-
0
votes1
answer47
viewsRepair in Checkadas tables
Follows the code: status := DataModule1.ZQuery2.FieldByName('Msg_text').AsString; while not DataModule1.ZQuery1.Eof do begin if status <> 'OK' then begin DataModule1.ZQuery3.Close;…
-
0
votes1
answer391
viewsError 1118: Row size Too large. The Maximum Row size for the used table type, not Counting Blobs, is 8126
I have this error adding tables to my database. Does anyone know how to help me in this situation? For the dice are already as Barracuda. The fields I’m adding are Type: Text, Varchar(20), Longblob.…
-
0
votes2
answers695
viewsJava - Mysql Export and Import DB
Good afternoon. I created a DB in Mysql named Pizzeria. I have tried various means of creating DB backup but haven’t had success. The last code I tried was: try { File file = new File("Backup");…
-
0
votes1
answer414
viewsAbout Crystal Reports, Visual Basic 2010 and Mysql
I have a dental clinic project, which has a form of treatment form. This form has 160 buttons representing the 32 teeth of a patient (each tooth is represented by a set of 5 buttons); Buttons may…
-
0
votes1
answer1327
views -
0
votes1
answer1481
viewsHow do I get foreign key values on a Jframe form
I am creating a form in Jframe to insert data into a table that contains two foreign keys (since these keys are not generated automatically). What I have to put on Insert to get foreign keys? public…
-
0
votes1
answer100
viewsAm I trying to connect mysql in php?
Good afternoon I’m trying to connect mysql to php, because it’s generating the following error " Call to Undefined Function mysql_conect()", someone please help me
-
0
votes1
answer263
viewsPHP + mysql - insert mysql basedata all file name and path
I am working on a php on localhost where from the root folder will be to read all files and folders and insert into a MYSQL database but I’m having a hard time Can someone help us? obrgd ;)…
-
0
votes1
answer664
viewsHow to know if a file has been viewed
I’m making a system in php where the counter sends a file to the client (using database). My question is the following, how to do when the client accesses this file, is sent to the database the time…
-
0
votes1
answer1367
viewsHow to create mysql.socket file
I’m using the phpmyadmin because, it is returning me an error that refers to the missing file mysql.sock, there is a possibility to install this file? Error reported below: error 2002 : file not…
-
0
votes2
answers234
viewsInput point location error in MYSQL
What could be this mistake? I tried everything and I couldn’t fix it...
mysqlasked 10 years, 4 months ago Ramon Ruan 1,018 -
0
votes2
answers1024
viewsCreate links with a mysql table name and display its contents on another page. Is it possible?
I’m trying to create a php page that fetches the name of several tables from a database, displays table names and creates a link to each table. Once the user clicks on the link, it is taken to…
-
0
votes1
answer556
viewsHow to sort by date when day, month and year are each in a column?
Hello, I am with the following situation, I have to sort a table by date, but for some particular reason the programmer decided to save the day, month and year in separate columns, Obs the database…
-
0
votes2
answers987
viewsLarge database text or just a path to a txt(Mysql) file
My question is this: Is it better to put huge amounts of text into a database or create code that works with a separate txt? (open/save/modify) I have already said code in Php and have been using it…
-
0
votes1
answer1069
viewsSend by php mail function data from a table
Hi Dev I am there some three days trying to work out a way to send data from a table by function mail php. Sending data from just one column is basically easy, but it gets complicated when I want to…
-
0
votes1
answer39
viewsChange a relation between two mysql fields
I have my event schedule (tbl_eventos), where I am going to find the id_contact field of the contacts table (tbl_contactos). To create this link, I used the following: ALTER TABLE `tbl_eventos` ADD…
-
0
votes1
answer5030
viewsJava check, show values recorded in Mysql database
I need help I’m making a game in java and I need all records and files and player etc in my table but I can not connect with the database and much less check and display values Ps: sun.java tutorial…
-
0
votes2
answers1251
viewsForm Filters - PHP
I am developing a search in php for the database and I am having difficulties, the search is based on filters, for example: state, city, rooms, rooms .... *IMAGE OF THE FORM * I wanted to insert…
-
0
votes2
answers51
viewsFilter Useagent Via Database
I created a table that receives some visitor information, ID, Useagent, Address and proxy. I am making a chart type those pie (Chart pie) and would like to show the amount of visits of Y browsers…
-
0
votes1
answer12979
viewsError Code: 1406. Data Too long for column 'txtContability' at Row 1
In Mysql.. I am wanting to do UPDATE in a text field, the same has about 300 characters and does not allow to do it, informed that it is too long. I’ve tried changing the field type up to…
-
0
votes1
answer50
views -
0
votes2
answers1524
viewsHow to display two different database tables in php
Hello personal is the following, I have 2 separate tables, and can not do Inner Join, because they have no data in common, I wonder if it is possible to display these two tables in a single page.…
-
0
votes1
answer2672
viewsMysql Error 1049 How to Solve
had just installed mysql in Ubuntu, then restarted my computer, when I tried to log into mysql gave this error. someone can help me? root@wladi-Dell-System-Vostro-3450:/# mysql -r root -p Enter…
-
0
votes0
answers62
viewsDetecting Slow Queries in Rackspace’s Mysql
There is an easy way to see the slow queries in Mysql from Rackspace? I tried to those instructions, but they’re very complicated... Original post in English…
-
0
votes1
answer268
viewsSave php Mysql data in a single table
I have a small question about saving a form in mysql that is. I have a form that is divided into 2 and I want it to be stored in the same table. When I save only make save the second part of mysql…
-
0
votes2
answers2020
viewsRAD 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, whether by Firedac or dbExpress, the following…
-
0
votes1
answer411
viewsI cannot insert plain text in mysql with text column
I’m not getting a simple update on a table that contains a column TEXT. I put a simple Spanish text but sql returns me error saying that line is too big. However it is a very small sentence. Follow…
-
0
votes1
answer174
viewsSend select to print with php
I need to dynamically create a table with "n" lines and then send this table to print, but not succeeding, the construction of the table is like this: // laço para buscar e-mail e efetuar envio…
-
0
votes1
answer84
viewsUse different domains within a main website (city guide)
I wanted a light for the following situation: I have a main website (online guide) www.siteprincipal.com.br. In this site I have a table of cities where I register each one and I show the content as…
-
0
votes1
answer3036
viewsDisplaying dynamically created table records
I set up a dynamic table with data from a query to Mysql, when I show all the records the table is displayed correctly, but when I request only one record the table does not display any record, see…
-
0
votes1
answer234
viewsC# Mysql Connection thread-safe
I have a server that receives hundreds of asynchronous connections and I need to implement Mysql access from different threads. In fact, how I use the Async Socket Begin/End standard. Net, there is…
-
0
votes1
answer112
viewsRelationship of products in models and bank
I’ll try to be brief in my doubt. How can I model a class scheme that gives me some questions: This I will do in Rails 4.1, using Activerecord as ORM acting in Mysql. I’ll have an entity Person…
mysql ruby-on-rails modeling active-record abstractionasked 10 years, 4 months ago Bruno Casali 566 -
0
votes1
answer61
viewsDoubt about MYSQL Code + Delphi
Follows the code: DModuleGrid.qtudo.close; DModuleGrid.qtudo.sql.clear; DModuleGrid.qtudo.sql.add('select numcupom from tabc460 where cderr <:mc'); DModuleGrid.qtudo.parambyname('mc').asinteger…
-
0
votes1
answer75
viewsUPDATE only fields that are more than 0 characters long
Hi, I have a table with several inputs and I need you to update the fields with more than 0 characters, the ones with 0 or blank are the same as this! There’s some way to do it ? follows my code:…
-
0
votes1
answer233
viewsWrong parameter type error in mysql_fetch_assoc()
Warning: mysql_fetch_assoc() expects Parameter 1 to be Resource, Boolean Given in C: xampp htdocs NEW admin alterarfotos.php on line 16 $id_imagem = trim($_GET['id_imagem']); $dados =…
-
0
votes3
answers1199
viewsSelection of fields that repeat in the Mysql database
I have a table in the database, with columns id, assunto, mensagem, id_replicante I want to select all records from this table. But in the field assunto has several repeating values, and I would…
-
0
votes1
answer576
viewsDynamic site with multiple pages of results
I am doing a project of a dynamic website in college and wanted to know how to assemble those result pages with first, second pages and so on without creating new files .php . For example: I have a…
-
0
votes0
answers44
viewsSend e-mail with PHP, without human intervention
I have a doubt of PHP, but I do not even know the terms that I should research. There goes. I’m starting in PHP now, and I’ve come up with a problem I can’t solve. I need to send an email when…