Questions tagged as 'mysql'

Tagged questions
1
answer

How to create a sequence in varchar in the Postgres database?

I have the following table in the Postgres database: CREATE TABLE customer ( userid character varying(30) NOT NULL, firstname character varying(30) NOT NULL, lastname character varying(30) NOT NULL, balance double precision NOT NULL,...
asked by 21.09.2015 / 20:56
1
answer

MySQL falling for lack of memory

I have a dedicated Linux Ubuntu 12.04 LTS server with MySQL / Apache / Wordpress , but since it only has 1Gb of RAM, sometimes it drops out of memory . In the syslog mark with the message    Out of memory: Kill process XXXXX (mysqld) score...
asked by 13.02.2014 / 20:00
1
answer

How to fix the error Attribute 'name' not recognized in Webconfig?

I'm developing a web project in VS 2012, this application connects to a MySQL database developed in MySQLWorkbench 60 CE with the MySQL 5.6 server, I have referenced in the project the EntityFramework version 6.1, MySql.ConnectorNET.Data 6.8.3.2...
asked by 29.05.2014 / 00:47
1
answer

Use missing ids

After viewing this question I remembered of a problem that I have come across many times: Let's suppose that the following table exists: Fruta ----------- 1 | Maça 2 | Banana 3 | Pêra If I delete Banana and add Pêssego an...
asked by 20.04.2018 / 16:08
1
answer

How to filter separated dates by day, month and year in MySQL

Hello, I have a table "Meetings" in MySQL with the following structure:    id: Int (11), subject: String (40), day: String (2), month: String (2),   year: String (4), active: String (2) Save in the field day the day of the meeting, mes th...
asked by 23.03.2016 / 04:22
1
answer

Search in two tables MySQL

Is it possible to give a "select" by merging two tables in MySQL? for example: I have a table named favorites that saves id and strong id . the idea is to go through the favorites table merged with the posts table, (where title, cont...
asked by 10.10.2016 / 17:40
1
answer

What are "columns generated" in MySQL and what would your applications be?

I downloaded the new version of the MySQL workbench and when I was creating a table, I noticed a new field property called Generated Column . On the MySQL site, this is a new implementation of MySQL 5.7.5 , but it has not been very clear to...
asked by 28.05.2016 / 17:18
2
answers

SQL Query Optimization in MySQL and Index

I have a performance problem with a query with SQL on MySQL that is using my server a lot, I have done index and even then the consumption does not decrease. The query I'm using is: SELECT CONCAT( '2015-10-14 '...
asked by 14.10.2015 / 15:52
1
answer

Dynamic Bind with prepare ()

I'm doing a function using the PDO, when I try to use the PREPARE method the function does not finish successfully, it replaces PREPARE with QUERY by changing some arguments and it worked. But my question is the following because what with PR...
asked by 23.09.2014 / 05:23
1
answer

select like in more than 3 million rows

I have a Maxmind table, with more than 3 million cities. I created the index for a simple select and it is performing satisfactorily. The problem is that I am using an autocomplete and for this my select uses like , but always returns...
asked by 20.04.2015 / 20:17