Questions tagged as 'mysql'

Tagged questions
1
answer

MySQL server can not start in CentOS

I can not perform any operations on MySQL because it gives error of:    Starting MySQLCouldn't find MySQL server root@server2 [~]# /etc/init.d/mysql status MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED] root@server2 [~...
asked by 29.08.2014 / 19:23
2
answers

Like button

I have the following button <a href='?area=ref&amp;acao=curtir&amp;noticia=$noticia->id&amp;perfil=$user'>Curtir </a>"; that calls the function that is in the action page that I like the related article, but it h...
asked by 07.06.2014 / 00:30
1
answer

Access datadir folder by VM

My scenario is as follows: / media / data / svr / mysql Where is my mysql datadir folder located. The development environment is running in vagrant (debian 6), with php 53 and mysql 5.5 I configured the VM to access the datadir folder...
asked by 14.04.2014 / 23:59
1
answer

Total sum of values for all dates

How do I add X values to a specific date and compare if the value added is greater than 100? /* Data das consultas, e para cada data o somatório total dos valores, desde que este total seja maior do que 100.00. */ SELECT c.data AS 'Data...
asked by 03.12.2014 / 19:03
1
answer

UPDATE and SELECT at the same time (locked)

Monitoring the database (MySQL) through MONyog I realize that when a very large query is executed (SELECT ) and, at the same time, an update query also runs, under the same table, the update is waiting for the SELECT to finish. The result o...
asked by 17.02.2014 / 18:16
1
answer

Login with Java levels MySQL

I am doing a login system, but I am in doubt as to how I can leave it with levels / types (admin, user, client). IMPORTANT: I'm making a method that uses Taglib - "C: if" to make a Switch Case. The idea is to make a redir for the admin a...
asked by 13.02.2014 / 19:17
1
answer

How to check if a transaction was started in Zend

I have a method where a BEGIN TRANSACTION is started in Zend 1.12. As it is used in many places, it has occurred that a method that calls it already starts a BEGIN TRANSACTION , thus generating Exception . I want to check b...
asked by 26.02.2014 / 21:51
1
answer

Problems with CONVERT_TZ and BETWEEN in Mysql 5.1.73

I'm trying to do this search with CONVERT_TZ and BETWEEN in MySQL 5.1.73 but always returns zero rows. Has anyone ever used BETWEEN in this way? SELECT x.UserName, x.StartDate , x.EndDate FROM tabela AS x WHERE (x....
asked by 26.02.2014 / 15:48
1
answer

How to import MySQL dumps into UTF-8?

I'm trying to import a dump from MySQL (UTF-8), generated in Windows by Navicat, on a CentOS 6.5 server with MySQL 5.5 . The problem generated with this is ... when executing the following command: mysql -uroot -p database < dump.sq...
asked by 30.01.2014 / 20:17
4
answers

How do I create a sql view with more than two tables?

How to create a view sql , I need to get the name and password in the Magento DB that are in different tables, to authenticate in Moodle.     
asked by 03.02.2014 / 13:28