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
votes2
answers144
viewsGroup in mysql together with Join
I have a class table and a table of parents. A student may be associated with up to three parents. SELECT a.idAluno, a.matriculaAluno, a.nomeAluno, a.sexoAluno, a.dataNascAluno, b.id, b.matricula,…
-
0
votes1
answer196
viewsReturn value generated from foreach
Basically, I have this foreach to dynamically create the selection text: foreach ($table['exists'] as $item) { switch ($i) { case 0: echo($item.' = "'.$_POST[$item].'" AND'); break; case $len - 1:…
-
0
votes1
answer1423
viewsWarning: mysqli_fetch_object() expects Parameter 1 to be mysqli_result, Boolean Given in /home/omeganim/public_html/index.php on line 39
I am in need of help to resolve this error!!! Warning: mysqli_fetch_object() expects Parameter 1 to be mysqli_result, Boolean Given in /home/omeganim/public_html/index.php on line 39 The code is…
-
0
votes1
answer31
viewsReturn last value of each day in mysql
Hello, I have following values in the database: data - valor 2019-06-03 7:00 9 2019-06-03 12:00 21 2019-06-03 20:00 28 2019-06-02 8:00 11 2019-06-02 12:30 21 2019-06-02 19:50 27 2019-06-01 8:30 10…
-
0
votes1
answer261
viewsUpdate an sql column of all records
I will try to be as specific as possible, if anyone can help me I really appreciate. I need to know how to change information in a column of all database records. For example: I have the database…
-
0
votes1
answer526
viewsPHP PDO - Mysql query data does not appear in table
What I’m doing wrong in this script? I make a query in the database to return all table data curso and show their names in the table, but it’s not working. Also this part of the code is being shown…
-
0
votes0
answers106
viewsHow to update a table with multiple fields
Next, I have a form, inside this Form several Input with vectors, example <tr> <td style="vertical-align:middle"> <input type="checkbox" name="Checks[]"…
-
0
votes0
answers202
viewsHow to WRITE android data to Mysql using webservices (Asynctask)?
I have an android application that has several buttons on different screens, I must join the buttons clicked and send to Mysql. I read about webservices (http://www.androidpro.com.br/webservice/)…
-
0
votes0
answers366
viewsPHP form data does not enter the database
Hello, I’m new in PHP and I’m doing a small scheduling page but I stuck in the input part of the data inside the database, below my codes: Index.php <html> <head> <title> Controle…
-
0
votes1
answer211
viewsSlow Ajax and Login Validation without running right
Good night, I have a form where I before accessing I do the validation with an ajax, php and mysql, this validation checks the access attempts, and if the user put 5 times the wrong password, it…
-
0
votes1
answer31
viewsWhy don’t you create Foreign Key?
I ran the commands in Mysql Workbench, but did not create the Foreign Key connection, which is wrong in querys? create table Computador ( ID int NOT NULL primary key AUTO_INCREMENT, Nome varchar(45)…
mysql database mysql-workbench foreign-key primary-keyasked 5 years, 5 months ago Felippe Jaqson Chemello 3 -
0
votes2
answers76
viewsThe form is not being saved in the comic
Controller public function cadastro() { return View('/cadastro'); } public function novo() { $user = \App\User::where('User',"=", Input::get("User"))->first(); $user->name =…
-
0
votes2
answers244
viewsquery sql does not work
My system is generating a query from a filter. All query that I use in a given field do not find anything, as simple as the query down. select * from prt_license WHERE organization_type =…
-
0
votes1
answer20
viewsHandle object in Node via bank return
I’m assembling an object according to the values returned by the database. Actually, I’m doing it this way: let games; execSQLQuery(query, form_values) .then(dbResponse => { if (dbResponse != "")…
-
0
votes1
answer120
viewsDelete button function does not work
I’m developing a software for tcc I have already created the connection to the database and the function of entering data into the database when programming the following code to delete button, it…
-
0
votes1
answer329
viewsError importing data from an Excel spreadsheet to mysql directly on the server
I am trying to import data from an Excel csv spreadsheet, however the following error appears: Invalid column count in CSV input on line 1. I imported directly to the root of the database (created…
-
0
votes0
answers319
viewsTable does not display name relative to PHP Foreign Key Table
I need to make a query in the table and return to Date in first column, Name (FK) in the second column, and other FK-dependent data in their respective columns. I have tried the various forms of…
-
0
votes1
answer45
viewsBring all necessary results in a query - Mariadb
I need to reformulate a small system, which today, works but opening multiple connections to the database, and when there are too many records, the database falls, or when that doesn’t happen, the…
-
0
votes2
answers739
viewsCheck if the user is active in the database
I need to make a query if the user is active. Ex. I client log in to the panel, if my status is disabled, shows me a message, if my status is active log in to the page. follows my code <?php //…
-
0
votes1
answer124
viewsfilter data of a query in minuscule and without spaces
How to query the database that ignores accents and other special characters? I have the products table that has the name field with the following values: "shoes", "Tennis", "Karaoke and Video",…
-
0
votes1
answer28
viewsProtect Mysql table against drop
I have a Wordpress module (Cerber) that for some obscure reason, is deleting a table (cerber_files). The developer does not manifest. I wonder if there are any commands that prevent a mysql table…
mysqlasked 5 years, 5 months ago Rogério Dec 1,511 -
0
votes1
answer23
viewsTriggers for date verification
I’m having a question! I have a schedule of contracts and wanted to update the field of data_exclusao for the current date each time the field data_inicio is possible through triggers? I’m a…
-
0
votes1
answer82
viewsProblem while doing update
I have on the site the system to register, list and edit users. Registering and listing are ok, however, when trying to update a record, it is not changed on DB and also does not return any error. I…
-
0
votes1
answer40
viewsQuery where result equals any of the values in the list
I have a table of Duplicates that has the month reference as string,(ex: 01/2012, 05/2016 and etc) And I need to perform a query between a date range, if the field was Datetime I know it would be…
-
0
votes0
answers53
viewsCreate Timezone function for PHP and Mysql UTC
I am migrating to a Cloud hosting where Mysql is with Timezone UTC, I could not execute the commands to switch to GMT -3 and support does not give me another option. Today my requests are saved in…
-
0
votes1
answer52
viewsHide "PROFILE" in the Phpmyadmin view tab
Does anyone know how to hide this Profile part in Phpmyadmin? I’ve touched everything here, tried to reset the default settings and nothing!…
-
0
votes1
answer77
viewsReturn results in different inputs
Guys, here’s my code. My query is returning the results I want, but it’s only returning in an input. How do I return the name_id in one input and Location in another? <?php $nome =…
-
0
votes1
answer94
viewsHow to add and store what were the added id?
Good afternoon, would like to know if it is possible to perform a query summing some values and create a column with the ids in which the values were summed. -- table 'value' | id | value | status |…
-
0
votes2
answers48
viewsProblems in consulting with NOT IN
I have 3 users in the database, and I want to search for all users, except the user 2, then have to return user 1 and 3. In the database returns perfectly, but on the web always returns user 1, and…
-
0
votes2
answers115
viewsLogic for consultation in subscription system
Hello, I’m developing a system of online plan subscriptions for one client, and I’ve encountered a number of difficulties. I’ll explain a little bit about how the system works and what difficulties…
mysqlasked 7 years, 7 months ago Maykel Esser 598 -
0
votes2
answers150
viewsMysql problems connecting to a python database
Good morning, When I try to connect python to a database I get the following error MySQLdb._exceptions.OperationalError: (1045, "Access denied for user 'k4os'@'localhost' (using password: YES)") I’m…
-
0
votes2
answers36
viewsPick up the value opened
This is my table, I want to get the value abertoCaixa of the greatest idCaixa. CREATE TABLE tblcaixa ( idcaixa INT NOT NULL PRIMARY KEY auto_increment, aberturacaixa DOUBLE(200, 2), abertocaixa INT,…
-
0
votes2
answers82
viewsAdd decimal values in Mysql
I have the following query: SELECT SUM('ValorTotal') AS Pagos,StatusCadastros FROM pe_cadastros WHERE StatusCadastros = 'A'; On the field ValorTotal, who’s with the guy Decimal(7,2) has 02 values:…
-
0
votes1
answer73
viewsRemove last comma from pagination
I created a pagination, which is displayed like this 1,2,3, I wonder how I can remove the last comma from the last page? And another, the first pages show 1,2,3, and when step 3, shows 1,2,3,4, can…
-
0
votes0
answers436
viewsSelect with data from associative tables
I am creating a small database to store the books I own at home, but I came across the following situation: I have two associative tables, a call self-published, that allows the same book to have…
-
0
votes1
answer62
viewsHow do I show a php error in jQuery?
I have one (.html), one (.php) and my jQuery. In my jQuery( I am sending the information to (.php) do CRUD and etc. Transactions are occurring smoothly, but are not displaying error messages of the…
-
0
votes1
answer28
viewsworking with dates
Could you help me please, I have a column service date that based on it brings me the last day of that month and I calculate that data_final_month + payment deadline and from there I can know what…
-
0
votes4
answers44
viewsCopy multiple records to the same table with change of values
I have the following query: INSERT INTO tags group_tags, title, active SELECT group_tags, title, active FROM tags WHERE group_tags = 2; First How to run this query for each table record that…
-
0
votes1
answer383
viewsSum of Records per group
I need to add the field value from the table I’m working on, but the sum is done by blocks where the user id is the same. Exemplifying: It is a shopping cart, each registration is a product in the…
-
0
votes0
answers34
viewsI cannot add values with Procedure in Mysql
I’m doing a job with Mysql database and I’m having difficulties in Procedure maid: DELIMITER $$ drop Procedure if exists cad_cat$$ CREATE PROCEDURE cad_cat(pnomeCat varchar(60)) BEGIN INSERT INTO…
mysqlasked 5 years, 4 months ago Ronaldo Ávila De Arruda Junior 1 -
0
votes2
answers55
views -
0
votes1
answer29
viewsmy html page gets ? (but I’m sending things via post). http://localhost/Systeemaaline/formulario.html?
My page loads like this (below) http://localhost/Systeemaaline/formulario.html after sending data to php and returning them to the same page using jquery, it comes back with ?…
-
0
votes0
answers478
viewsDoubt: Connection and query with PHP, PDO and MYSQL
Good afternoon! I have a mistake I can’t identify at all. I need to perform more than one query in different classes on a screen. My problem is happening when the second query is run Php is…
-
0
votes1
answer39
viewsReturn query without record in the database
Hello. I have a PHP system with Mysql from a truck fleet company. In this system each user performs a Checklist of the vehicle before using it. This Checklist is registered in a table in the…
-
0
votes1
answer29
viewsSearches in mysql - Accented letters
Currently I do my search as follows: SELECT * FROM cadastro WHERE nome LIKE '%são%' This way does not return me a result, however, when I put only the ã capitalized à I get the result. That’s how it…
-
0
votes2
answers64
viewsDifficulty adding data to db using PHP and MYSQL
Well, I’m starting my studies in php and mysql, and I’m having a hard time doing something theoretically simple, which would be a form that sends the information provided to a local db. By pressing…
-
0
votes1
answer147
viewsHybrid deployments with PHP Laravel Mysql + Mongodb
I’m developing a system with PHP Laravel + MongoDB. The login and password part will be modeled using MySQL and use MongoDB to make a quiz. I was thinking of putting together a Schema in MongoDB of…
-
0
votes2
answers1088
viewsDelete in more than one table with an SQL?
I’m trying to apply a DELETE in more than one table, tables have a column (not of the same name) with the same attributes. I want to delete through ID. But I have the table usuario with column id…
-
0
votes1
answer29
viewsIncorrect Collum for a specifier for Collum 'code'
Good morning, I recently started on mysql server and is giving an error q for more q look for no solution arrangement: My code is: CREATE TABLE usuarios( codigo VARCHAR(30) NOT NULL AUTO_INCREMENT,…
mysqlasked 5 years, 4 months ago user147847 -
0
votes3
answers34
viewsHow do I filter a time coming through a select
$query = "SELECT horario FROM tempo WHERE teste = $teste"; Way it returns: 2019-07-26 19:24:17 Way I want it to return:19:24:17