Questions tagged as 'mysql'

Tagged questions
1
answer

Error connecting to MySql using EF6

I'm getting the error    'System.Data.StrongTypingException: The value for column' IsPrimaryKey 'in table' TableDetails' is DBNull Whenever I try to connect to a MySql database using Entity Framework 6. Any tips to fix?     
asked by 07.04.2017 / 01:56
1
answer

Connection Entity Framework with Mysql

I have done the procedures pointed out in these questions: Entity Framework - Bank Compatibility MySQL Connection Error asp.net MVC I installed MySQL.Data.Entities. My web.config looks like this: <connectionStrings>...
asked by 07.11.2014 / 02:54
1
answer

Duplicate Mass Records - Run a query for each displayed Record

I have a table where only accounts with their type = 'fixed' are displayed WhatIwouldliketoaccomplishistorunaqueryandduplicateallrecordsinthetableatonce.AtthemomentIonlymanagedtoduplicatetheaccountsonebyoneandnotallresultsdisplayed,whichalre...
asked by 17.04.2017 / 21:24
2
answers

Does not connect to the database and does not return any errors

Hello, I made my site through xampp on windows, when I migrated to the ubunto I realized that mysql simply did not work, and did not return any error, for example, on the home page of the site I already use mysqli_connect even with the wro...
asked by 30.03.2017 / 17:10
1
answer

Adding decimal values mysql

I made a query that adds a decimal field, but I'm having a problem, because when I put the group by t1.id_sell clause it lists the sales but no longer adds correctly and without the correct sum clause but only returns one line. query:...
asked by 30.03.2017 / 18:09
1
answer

Show the lowest value in MySQL

I'm doing a DB that shows the smallest value among three options, each option represents a column. I want to get the lowest value of a row where it contains these three values.     
asked by 04.04.2017 / 16:42
0
answers

PDO run () with connections not working

PHP Version: 5.6 Framework: PDO I have the following database query: $cIndus = array("ex1", "ex2"); $query = "SELECT 'nome_agr_corr' AS 'brita', CASE WHEN ? = 'usd' AND ? = 'externos' AND...
asked by 28.03.2017 / 18:53
1
answer

Change String color upon Mysql return

I have the code below, if the score column has a field with "LOW" the color of only the LOW has to be (# FFFF00) and if the field is HIGHT, only HIGHT must have the color (# FF0000): <?php while($row = $stm->fetch()) { $col...
asked by 28.03.2017 / 19:51
1
answer

Use CONCAT to adjust the amount of php mysql numbers

I need to complete the amount of numbers to display on the screen, what would that be. the quantity that would be an example: 20 need to enter 15 characters with 0, Example: 000000000000020 . A friend of mine showed me in Excel a way he...
asked by 03.05.2016 / 20:45
1
answer

Database in Excel?

Well, I have a question. I searched around on Google and did not find anything related, but may have someone who knows. Can you put a Database (MySQL) in Excel ? I wanted to export a list of Customers I have in MySQL to a table in Excel, a...
asked by 29.03.2017 / 04:00