Questions tagged as 'phpmyadmin'

Tagged questions
2
answers

Modify fields phpMyAdmin

I just started working with BDs , and I'm trying to update the value of a field in all rows. That is, in the table FRUITS I have the column color , and I want to put all the fruits have color rojo . The fact is that when trying...
asked by 14.05.2018 / 11:12
2
answers

what is happening?

I am doing a CRUD and when I finish filling out the form it appears that the "patient has registered", that is what I should say if the records are sent correctly to the table. BUT when going to the table there is nothing (records do not appear)...
asked by 17.04.2018 / 08:32
3
answers

Problem when creating MySQL tables with PhpMyadmin

Good afternoon, I have a problem creating tables with PhpMyadmin my sentence is this: CREATE TABLE 'prensacarv1'.'pr_clients' ( 'clientId' INT(10) NOT NULL AUTO_INCREMENT, 'firstName' VARCHAR(45) NOT NULL, 'lastName' VARCHAR(45)...
asked by 04.04.2017 / 15:06
1
answer

two-digit autoincrementable column

I have A tabla turns with a shift column that this car can be increased but I would like to place it with two digits. example: 01 02 03 ... 09 10 Any idea how to get there?     
asked by 24.07.2018 / 18:28
1
answer

Problems uploading files in Laravel 5.5 project in a hosting

I am uploading a Laravel 5.5 project to the free 000webhost hosting. A user can upload images to a post, when I try it on the computer without uploading it to a hosting it works perfectly. The image is uploaded to the public / image folder of th...
asked by 12.04.2018 / 03:26
1
answer

Problem with the DATETIME field in MySQL

In my MySQL database in phpMyAdmin I have a table in which when I enter a date in a field of the table I put the date in millisecond format. Clicking on the field to select a calendar date appears as follows: With the bar to select t...
asked by 16.05.2018 / 07:49
1
answer

How to incrementally increase the ID field in phpmyadmin

I'm trying to create a database but I can not find a way to make the ID field incremental.     
asked by 26.02.2018 / 08:42
1
answer

Sort by Mysql

Good day friends I have a doubt to the I do the following query As a result I get this Is there any way to bring the data in the order in which the query was made? That is first the data of Id 1, then those of 3, and finally those of...
asked by 20.12.2017 / 07:19
1
answer

error query php sql phpmyadmin in data type SET, does not return the data correctly (write error)

I have a conculta to my database function ticketsanulacionpendientesSISTEMAS($conexion){ $pendientes = (mysqli_query($conexion, "SELECT COUNT(*) AS conteo FROM ticket WHERE tipo_solicitud = 1 && status = 1 or status= 2 or stat...
asked by 19.04.2018 / 17:18
3
answers

Error increasing the value of the viable Php / sql

Good day, from a php form I am capturing the information in phpmyadmin. In the background is the realization of a purchase that when stored in the database increases the purchase number (purchase 1, 2, 3 etc.). I have reviewed the code sev...
asked by 15.06.2017 / 10:37