Questions tagged as 'mysql'

Tagged questions
1
answer

Error restoring database using mysql folder

Good morning,  I lost a hd where my databases were, plus I have the backup of the folders of the banks.  I grabbed the folder from one of the seats and put it in:    C: \ xampp \ mysql \ data And it usually appears in my phpmyadmin :...
asked by 24.07.2017 / 07:36
1
answer

What is the best way to update inputs alternately

I have some inputs, however I should only update the fields that have been filled: For example : Logo and Digital Certificate are blank. UPDATE should not for these fields. Logo and Password are left blank. UPDATE should not occ...
asked by 08.08.2017 / 22:52
1
answer

Error to popular SELECT - Warning: mysql_fetch_array () expects parameter 1 to be resource

I'm not able to select my popular. Below is my code: <select> <option>Selecione</option> <?php while($serv = mysql_fetch_array(getAllServicos())) { ?> <option value="<?php...
asked by 16.08.2017 / 20:11
1
answer

How to solve wrong spreadsheet export xml

I have a form that receives some registration and is transmitted to another page via ajax that does the insertion in the database. The problem is that at the time of receiving, if I do not use utf8-decode on the variable where it has accent will...
asked by 08.08.2017 / 19:38
1
answer

convert decimal and date in LOAD DATA INFILE

I am importing a CVS file for MySQL. I have two columns: one quantidade and the other as data . I am trying to convert to the MySQL default. In the database this column is as decimal and date . It is importing all the l...
asked by 09.08.2017 / 03:26
1
answer

INSERT insertion problems mysql

I am trying to insert data into my mysql database but the values do not appear in the table TABELA "users": id 'int','11', 'notnull','primarykey','auto increment' email 'varchar','11', 'notnull' senha 'varchar','11', 'notnull' <?php $ema...
asked by 14.07.2017 / 07:47
1
answer

SQL where is the error?

I've reviewed this query several times but I do not think it's a mistake. "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the rig...
asked by 15.07.2017 / 02:55
3
answers

Insert multiple php mysql records

I'm developing a car site and when the user makes the registration of the vehicle he has the option of inserting several images of the vehicle. I have the upload code, but I wanted to know how to insert more than one image in the image field of...
asked by 06.07.2017 / 03:57
3
answers

How to save the date in a table in mysql

I'm trying to insert the current date into a table, I'm using the following code: insert into testar (data,nome) VALUES (date("Y-m-d H:i:s"),'pedro'); But the error:    Column 'data' can not be null.     
asked by 03.07.2017 / 00:02
1
answer

Concatenate an SQL value

I have a trigger that updates a particular raw table, but it replaces the existing quantity and I need it to concatenate the new value with the existing value, could someone help me how to do this? create trigger trg_atualizaEstmatprim after u...
asked by 01.07.2017 / 23:22