Questions tagged as 'mysql'

Tagged questions
1
answer

Return amount of dependents per employee

I need to select the Plaque, Employee Name, and Dependent Amount for each Employee, but the result of that query is showing the number of dependents for the first Employee only, / p> Note: If you remove the WHERE clause, the query shows...
asked by 03.11.2018 / 20:36
1
answer

How to change data types in fields in a table in mysql at once

I have the following table: create table pessoas( id tinyint, nome char, peso float, altura float(3), sexo int(1), nacionalidade varchar (20) ); But I want to change all fields at once alter table pessoas modify nome varchar (20)...
asked by 25.11.2018 / 21:34
1
answer

MySQL Error 1064

In the insert below I get the following error. INSERT INTO dump1090 ('hex','squawk','flight','lat','lon','validposition','altitude','vert_rate','track','validtrack','speed','messages','seen') VALUES ('e4827e','3670','TAM3754 ','-22.850818','-4...
asked by 28.11.2018 / 17:30
1
answer

AUTO_INCREMENT MySQL problem

I had a problem that from ID 35218, the accounts started to be inserted from ID 400000, but I do not remember having tampered with the value of AUTO_INCREMENT. What can I do to get the accounts back to the lowest empty ID?     
asked by 09.10.2018 / 02:43
1
answer

Insert into with waiting time

I have a form that its action sends to a .php file that makes an insert in the database with the information passed by the form, and I already noticed that if I click twice as fast on the submit button it sends two records identical to the datab...
asked by 05.11.2015 / 03:42
1
answer

Error starting spring boot

The console displays the following error message:    Exception in thread "main" java.lang.NoClassDefFoundError: org / springframework / boot / SpringApplication       at com.example.demo.AppApplication.main (ManageAppApplication.java:10)   Ca...
asked by 15.09.2018 / 23:07
4
answers

How do I insert this into the database through the form?

Hello, I can not connect to the database. The following error is appearing:    Fatal error: Uncaught Error: Call to undefined function msqli_query ()   in C: \ xampp \ htdocs \ Clients \ data.php: 15 Stack trace: # 0   {main} thrown in C:...
asked by 13.09.2018 / 16:26
2
answers

Add in MYSQL query in varchar field by removing Strings

asked by 19.09.2018 / 21:23
1
answer

Change colors on google charts

I'm using google charts to generate 4 pizzas.  How do I change the colors that appear? Follow my code: <?php include("conn_user.php"); include("conn_sys.php"); if (!isset($_SESSION)) session_start(); if (!isset($_SESSION['usu_login'])) {...
asked by 05.08.2016 / 15:29
2
answers

Problem with function that generates friendly url

Good I have a function that generates the name for friendly urls but I am having a problem that when the function generates the name if that name contains accents it does not put the same word but without accent it puts another character F...
asked by 14.02.2015 / 19:15