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
answer113
viewsPHP & Mysql on AWS
Hello, I am new to the issue of AWS and would like to acquire a machine there so that it works basically as a localhost server (MAMP, WAMP, XAMPP) so that it works as a website, only with everything…
-
0
votes1
answer112
viewsDynamic Select with query
I want to make a dynamic form like this: https://www.w3.org/WAI/WCAG20/Techniques/working-examples/SCR19/dynselect.html I am having difficulties in connecting mysql, php and javascript to the…
-
0
votes0
answers124
viewsHow to set time_zone using PDO
I have a connection using PDO what arrow the SET NAMES UTF8: $options = [ PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES UTF8" ]; But I’d like to add the SET time_zone='America/Sao_Paulo'.But in…
-
0
votes0
answers234
viewsHow can I apply bank information to modal?
Well, I’m working on my computer CBT, and its purpose is to control the output of students. I managed to make registration system, deletion, I am already working on the edition, however I would like…
-
0
votes1
answer777
viewsInstall Mysql to use with Python
I’m first in python and I want to know how to install mysql to store terminal information. I use wamp/mysql to develop in php, is it possible to make some relationship between them? (use wamp mysql…
-
0
votes1
answer119
viewsgroup per SQL query
I have a table post with a field category, each post that is inserted may receive more than one category: post1 categoria1, categoria2 post2 categoria1, categoria3 how can I perform an sql query to…
-
0
votes2
answers1310
viewshow to check the time of a select in mysql with php
Well I do a select, Insert in mysql with php that way: $consulta = $mysqli->query(" SELECT id, nome FROM produtos "); // Verifica erro if (!$consulta) { echo "ocorreu um erro";} How can I check…
-
0
votes1
answer244
viewsError when displaying image inside a php <td>
I’m creating a panel I make a calculation of the time a OS ta open and depending on the result shows in the table a colored ball... only it’s not working out,: Parse error: syntax error, Unexpected…
-
0
votes0
answers80
viewsQuery by table text using PDO
My seemingly simple problem has given me headaches. I have a table that contains three columns: id, idpergunta, resposta. When a reply is sent to be inserted in this table I check if it already…
-
0
votes2
answers79
viewsrecover BD name of a mysql and php connection
Good make the connection in my mysql so: $mysqli = mysqli_connect('127.0.0.1', 'root', '123', 'teste'); I want to know how I can recover the name of the database through the variable that receives…
-
0
votes1
answer1082
viewsSelect the previous 3 months
Hello, I have the following table: ---------------------- downloads | data ---------------------- 10 | 2016-12-01 15 | 2016-12-02 20 | 2017-01-01 30 | 2017-02-01 40 | 2017-03-01 This way I can add…
-
0
votes1
answer388
viewsPHP; Mysql; calculate/ insert data automatically according to certain parameters
Good afternoon, I have 3 tables. I want to calculate and automatically insert the schedules in the scales table according to some parameters. ex: 4 days working mornings, 2 days off, 4 days working…
-
0
votes1
answer2503
viewsWebsite in two languages
I will have to develop a website in two languages, Portuguese and English. Nothing complex, but I am in doubt on how to organize the structure, so I would like the opinion of someone who has already…
-
0
votes2
answers5148
viewsHow to remove value accentuation in Mysql
How can I remove the accentuation of all values of a(a) column/field using Mysql commands? Trying: UPDATE tabela SET campo = REPLACE(campo ,'Á','A'), campo = REPLACE(campo ,'À','A'), . . . campo =…
mysqlasked 7 years, 8 months ago lucasbento 856 -
0
votes1
answer46
viewsHow to add many customers at once in a database table?
I need to add Name, Phone and Address of many clients who are in excel and pass this to the database. What would be the fastest way to do that ?
-
0
votes2
answers87
viewsNew schedule scheme - Database
I have an order system, where the delivery time of the product is selected in a normal input of the type='time', and stored in the database in time type as well. Everything is working perfectly, but…
-
0
votes1
answer70
viewsCorrectly insert data into table
I’m in serious trouble with the INSERT of PDO, I am unable to add the values correctly to the banco de dados, how to proceed in this situation? Picture of the problem: I’m waiting for help. <?php…
-
0
votes0
answers133
viewsError importing Wordpress database database
I’m having trouble importing the Wordpress database. On my local physical server, with Ubuntu server 16.04 is running, but when I played on my Ubuntu 16.04 desktop, it does not work. The procedures…
-
0
votes2
answers103
viewsDo you doubt the mysql database query?
How to create a code to check if there is a new record in the database? EX: id = 2 has been entered, I need to create a code that will generate a notification every time a new id appears.…
-
0
votes2
answers479
viewslast Mysql record
How to know the last ID record in the table and play the number in a textblock? using (_connection = new MySqlConnection("Database=test;Data Source=localhost;User…
-
0
votes5
answers325
viewsPhp View Columns
I have two columns A and B with mixed words, I want to remove, the whole row of A and B that in column B has less than 8 characters. how do I do this in php?
-
0
votes0
answers56
viewsPDO mysql and PHP error
I already 'decoded' the php.ini file for the PDO to work, restarted several times apache, mysql, notebook, but I can’t connect to Mysql database. Use Windows 7. Worst I installed a virtual machine…
-
0
votes1
answer49
viewsCheck value textbox x mysql (universal app win 10)
I have a textbox where I save a value. I wonder if this value is the same as the last id in my mysql database table. How do I do this?
-
0
votes0
answers251
viewsCalculating date value for input fields
Guys I know nothing of java and I believe that is what I will need. Next situation: Below the script to generate the value with interest and fine the value between maturity date and payment date and…
-
0
votes1
answer118
viewsRetrieve records created in a Mysql date range
Dear friends, I have a mysql table that receives manpower effective data in a client of my company. Each DB record has a start date (When this service began to be provided in this client) and a end…
-
0
votes2
answers102
viewsSQL - Use of Distinct
Friends need a Select that loads: (all portals linked to a user and an additional column informing which portals were selected in a given news) So far my SQL is like this...: select distinct case…
-
0
votes1
answer51
viewsSelect only items that contain the number in their value
I have a table conversas: STRUCTURE +--------+---------+ | Nome | Tipo | +--------+---------+ | id | int | | users | text | | titulo | varchar | +--------+---------+ I need to select items that…
-
0
votes1
answer541
viewssend rfid data to Mysql
How do I make sure that when the tag goes through the rfid reader the following information is sent to the mysql database: "Salvador", "Bahia" ?
-
0
votes1
answer127
viewsMysql Relationships: Query Problem
I have the following scenario I need to get all the consulta_tipos with consulta_itens aligned and mark those that are in cliente_consulta_tipo and cliente_consulta_itens, also need to seek the…
-
0
votes0
answers30
viewsHow to insert default values into the table along with a variable value?
Setting: I have a database with 2 tables, table A has the screens of an app, and screen B records the activity on each screen, getting this way: ____________________ | Tabela A | -------------------…
-
0
votes1
answer146
viewsMerge between multiple Databases
I have a canteen system that performs sales in different schools. This system only works online, saving the sales movements on the matrix server (MS SQL). To optimize the system, I would like to…
-
0
votes0
answers189
viewsWideimage and Mysql and PHP
Good morning! So I’ve got a boring problem here. $nome_produto = $_POST['nome']; $valor_produto = moeda_mysql($_POST['valor']); $categoria_produto = $_POST['categoria']; $descricao_produto =…
-
0
votes1
answer68
viewsVariable error
I have tried to find a mistake that is happening to me and I could not, Error: Notice: Undefined variable: st in /var/www/html/questions/chk-manager.php on line 143 The line he’s pointing at is…
-
0
votes1
answer94
viewsProblems deleting data from table with ::PDO
Can anyone explain to me what the error or if there is a flaw in the script?? As far as I know this is correct, but it doesn’t work. In the script it takes the ID of who followed and the ID of who…
-
0
votes1
answer707
viewsif () syntax in a Trigger
I’m having difficulties with the if() syntax in phpmyadmin. I have to create a TRIGGER to insert information in a log when the name of an animal table animals is changed. But there is a syntax error…
-
0
votes1
answer66
viewsIF Mariadb phpmyadmin
I’m trying to create a Rigger using phpmyadmin with Mariadb bank but when it gets on the line if it gives a message: unrecognized statement type. (near IF) Trigger is the one: SET @TOTAL = (SELECT…
-
0
votes1
answer117
viewsError installing Mariadb
I am trying to install mariadb and the system returns the following error My question is the following, how to install in a directory other than the /var/cache...…
-
0
votes3
answers2083
viewsAttach href to a button
In a locker I have this link: <a href="chk-gerente.php?nro_pergunta=<?php echo $nro_pergunta; ?>">Próximo</a> And that button: <button type="submit" class="btn btn-default"…
-
0
votes2
answers75
viewsQuery is not running, inserts nothing
What could be wrong? Inserts nothing into the bank. Form: <form class="form-horizontal" action="chk-gerente.php?nro_pergunta=<?php echo $nro_pergunta; ?>" method="GET"> <fieldset>…
-
0
votes1
answer11482
viewsSQLSTATE[42000]: Syntax error or access Violation: 1064
I’m having trouble visualizing and entering the data in the database, is giving this error: SQLSTATE[42000]: Syntax error or access Violation: 1064 You have an error in your SQL syntax; check the…
-
0
votes1
answer37
viewsIdentify cities or other subjects
Good afternoon, my friends. I’m creating a website for a company and I’m having a little doubt. Can anyone tell me how do I get the site to "auto complete" user cities? EX: in the state I select…
-
0
votes1
answer78
viewsConvert JSON to 2 string in php
Boas. I have a json file that I wanted to convert into 2 string in php and then write to the database; my json at the moment comes like this: [ [ 1455628560, 2340 ], [ 1455628620, 2340 ], ] My…
-
0
votes1
answer948
viewsSQL the longest date records of an attribute
I have a table called kanban_card_journals which has the following attributes: id kanban_card_id issue_journal_id created_at Where the first three are numbers and the last date and time. This table…
-
0
votes0
answers50
viewsProject using Laravel and Mysql
Hello, I’m doing a registration project and I’m stuck in a business. I have a Users table in Mysql where I have a column called 'Status' (default), that is, an administrator can 'enable' or…
-
0
votes1
answer53
viewsData Base in Excel?
Guys, I have a question. I Googled and found nothing related, but there could be someone who knows. You can put a Database () in the Excel ? I wanted to export a list of Clients I have in Mysql to…
-
0
votes0
answers28
viewsAdd digits to auto increment database field
I need to add in the Mysql database id field, which is auto increment, the value 0 up to 4 digits - will serve as invoice number. In the form I do not handle this item, it has to be directly in the…
mysqlasked 7 years, 8 months ago Philipe Said 138 -
0
votes1
answer852
viewsSelect to sort by hour
Guys, I need to make a select that organizes by date and time. By date it is already working, but if I put an "and" "hour" after the date, it messes up all the records. See my select: $dados =…
-
0
votes1
answer1447
viewsHow to create an installer (setup) for tables and connection to the database?
I would like to thank you in advance for your cooperation. I know it’s possible, but I still have no idea how to do that. I have a script but it will be used for sale, however I would like in the…
-
0
votes1
answer42
viewsLogin page using mysqli_fetch_row
I am creating a very simple login page where the user type his name and password, the system scans the database(mysql) and validates its entry, however, when I enter the values correctly the system…
-
0
votes1
answer32
viewsDoubt in SQL Table
I created a table: Tabela Curso: Id int auto_increment nome varchar; Insert: Default, Arquitetura; Architecture has the ID 1 in the table. I delete the course Architecture. When I add any other…