Questions tagged as 'mysql'

Tagged questions
0
answers

Error updating MySQL.Data

I made the update of MySQL.Data and MySQL.Data.Entity from version 6.9.9 to version 6.10.4 and started to get the error below:    Inheritance security rules were violated by type: 'MySql.Data.MySqlClient.MySqlProviderServices'. Derived types...
asked by 07.11.2017 / 15:43
1
answer

How can I relate tables with return in json with php?

Please help me, I'm new to programming and I need to do a MySQL table relationship, with return in JSON , I tried the following code but it is with errors. I've done a lot of research on Google and Youtube , but I could not find anything lik...
asked by 06.11.2017 / 02:19
1
answer

Error: 1215 can not add foreign key constraint -MySQL 5.7

I'm trying to create a table, but I have a problem with a foreign key, at least it's what it looks like and that's what I can understand in my searches. Look at the code, the error occurs in the last table. (I found several similar posts but...
asked by 06.11.2017 / 21:18
1
answer

Paging of records

I'm trying to create a table inside a modal window that is triggered / opened as the user clicks a button, but due to having too many records it's slow to open so I thought about paging. Could someone show me some example? <!-- INICIO D...
asked by 07.11.2017 / 17:35
0
answers

Redundancy with codeigniter + mysql

I have a question, let's start in a system the question of database redundancy, but how will codeigniter know that there is another base if the main one is inactive? Is there anything appropriate for the codeigniter to identify this second ba...
asked by 27.04.2018 / 19:23
0
answers

Laravel multitenancy with a BD only for users

I've been searching for Saas and Multi-tenancy but have little material in Portuguese. I saw that it is possible to do a database for each company, but my question is: Make a single web system for all clients (using PHP + Laravel + MySQL)...
asked by 26.04.2018 / 15:32
2
answers

Filling Radio Required html

How do I fill in this required field: <p><h5><strong>Estado</strong></h5> <p>&nbsp;&nbsp;&nbsp; <input type="radio" name="Estado" value="Concluído">Concluído     
asked by 09.01.2018 / 18:33
2
answers

Difficulty in returning the result in a query without duplicating

I am trying to set up a query (MYSQL) to return all the clients that a particular vendor can view. The rules for showing the list of customers for this seller are: - Clients with overdue contracts or without contracts. - Customers with bids or n...
asked by 24.10.2017 / 15:17
1
answer

Is a "Group by" possible for column content?

I was wondering if it was possible to use GROUP BY based on the date of a column, in this case the ANALYSIS column that creates groups whenever it finds 0, instead of the column. DIA MES YEAR TODAY TOMORROW ANALY...
asked by 25.10.2017 / 00:30
0
answers

What is the best architecture? Mysql multi BD or single?

We are currently working with web software that is going to market with great acceptance. It receives many partner interfaces and generates a lot of content for each table. In the past we chose to create a database for each client, and a central...
asked by 25.10.2017 / 20:50