Questions tagged as 'phpmyadmin'

Tagged questions
1
answer

Problems with a trigger

Hi, I'm trying to make a trigger with a simple update. delimiter // CREATE TRIGGER 'reCalibrados' AFTER INSERT ON 'calibrationtbl' FOR EACH ROW BEGIN UPDATE calibrationtbl SET state='1' WHERE idInteva= (SELECT idInteva FROM...
asked by 17.02.2017 / 19:13
1
answer

Error: duplicate entry '0' for key 'primary' mysql

Good evening Update phpMyAdmin and when I export the database and import it into another server it sends me the following message:    duplicate entry '0' for key 'primary' mysql I know what it means and what causes it. But my questi...
asked by 21.11.2016 / 01:13
3
answers

Help with SQL statement to show in my SELECT that data does not exist

Greetings guys I need help with the following: I have a table with more data than 6000 data and I need to make a query in phpmyadmin where I will provide a data packet to look for and this will tell me what data I am looking for do not exist...
asked by 19.11.2018 / 14:30
1
answer

"Simplified" search of the same value in different fields (in the same table)

Currently for what I mention I use something similar to this: SELECT * FROM 'tabla1' WHERE 'c2' LIKE 'leonidas' OR 'c1' LIKE 'leonidas' OR 'c0' LIKE 'leonidas' What I am interested in knowing is, if I can do some sort of grouping of all th...
asked by 23.08.2018 / 16:14
0
answers

enable PDO module mysql and php in godaddy

I have a windows classic hosting with iis and php 5.3 in godaddy there my website connects to a mysql database this is my connection <?php $dsn = 'mysql:host=dbgts.db.2365702.3ed.hostedresource.net;dbname=dbase'; $username = 'user'; $pa...
asked by 14.09.2017 / 15:55
2
answers

Count positions of an SQL field

How do I manage to count each position in this array? I was working with SQL queries what happens is that I can not get the positions .     
asked by 22.12.2016 / 21:37
1
answer

Referential integrity problems and how to restore migrations in Laravel 5

Hi, I had some referential integrity problems making a model. Basically I had an article with a category and tags For tags create another table that has the id of the article and the tag, since it may contain more than one. Here I had the fir...
asked by 15.09.2016 / 17:33
3
answers

Migrate my database from mysql to laravel

I am new with Laravel and I am seeing if there is a way to pass the database that I have in mysql, to laravel to be able to work with them. I've already tried: Modify the .env. Modify config/database.php . But what I find is th...
asked by 18.11.2016 / 15:55
2
answers

Search and Delete duplicate MYSQL records

Well, my situation is as follows, I have a rather large database, and there are a lot of duplicate records (there are actually many that are repeated more than twice but I do not know how to call that). What I'm looking for is a query to h...
asked by 20.03.2018 / 00:41
3
answers

SQL query to two tables

Good morning everyone! I want to do an SQL query that retrieves all the fields from the PRODUCT table whose id field is found in the SALES table, the SALES table has the following fields: ProductID, idVenta, Observation and the table PRODUCT...
asked by 23.02.2017 / 14:48