Questions tagged as 'mysql'

Tagged questions
2
answers

How many tables does MySQL handle?

Well, what I want to do is create a table in my database for each user, now my question is: How many tables does MySQL handle? Is it possible to put a lot of tables on my server that does not crash or give a bug? My site has close to 1000...
asked by 04.11.2016 / 20:47
0
answers

MariaDB for when I have lots of accesses in wordpress [closed]

I have a site in Wordpress, used MySQL before in CentOS, I decided to migrate to a Debian 7 with MariaDB, but when I have more than 30 simultaneous accesses in the blog, Below is my my.cfg : # MariaDB database server configuration file...
asked by 10.01.2015 / 00:45
1
answer

Small Back Office [closed]

I am creating a small back office in PHP, MySQL and HTML and I have a small question. Table: IDNoticia Dia Mes Titulo Noticia Then in HTML / PHP I will echo to show the day, month, Title E Noticia but I have a doubt regarding t...
asked by 28.01.2015 / 12:46
0
answers

PHP Class PDO runs all CRUD on local server when over for web only works select [closed]

I have a problem that I could not resolve. I already researched here and found nothing like it. I have an application in PHP, using the class PDO to connect to the database. Then I have the CRUD: SELECT , INSERT , UPDATE E...
asked by 13.01.2015 / 17:59
2
answers

GROUP BY SQL error

I have the following exercise:    List department code and name, the earliest and oldest admission date of each   department, sort by department name.    I was able to do the following: select d.department_id, d.department_name, max(jh...
asked by 30.08.2017 / 20:15
3
answers

problems with distinct in mysql

I have a select where I have to sort it by field 'qtd' The problem is that I have this field different, and I need the products not to be repeated. The 'a.id' field stores the product code, ie it can not be repeated. Does anyone know how to s...
asked by 13.02.2017 / 18:35
1
answer

MYsql - ERROR! The server quit without updating PID file

I'm trying to run: mysql.server start and returns me    ERROR! The server quit without updating PID file   (/usr/local/var/mysql/user.pid). I tried to run: unset TMPDIR mysql_install_db but it returned me:  ...
asked by 21.12.2015 / 16:48
1
answer

Clear MySQL prompt screen

Does anyone know how to clear the MySQL prompt screen? After a while the screen becomes full and I want to clean. I do this at the Windows prompt but from MySQL I could not. I've tried:    \! cls , CLS , cls...
asked by 15.12.2015 / 19:30
0
answers

JointJS: Embed Parents and Children [closed]

Good, I'm working with JointJS but in a dynamic way. At this point I'm trying to embed the 'parent' and 'child' elements. After doing the select with the info of the child and parent, I make a get to go get this information: QUERY <...
asked by 04.12.2015 / 16:14
4
answers

Return multiple arrays using a buffer without overloading memory

I'm developing an application where, in a report, I need to print something around 50,000 lines. When executing SELECT the error occurs:    Fatal error: Allowed memory size of 134217728 bytes exhausted (tried   to allocate 24 bytes) in   C: \...
asked by 27.02.2014 / 21:24