• Mysql database security 2016-07-31

    I'm developing web systems. Nowadays, the major problem is that, via the database I can make changes in the account of any user. Therefore, anyone, who gets access to the DB, can make changes in the accounts. How to prevent this issue?

    Tags: mysql, security
  • mysql rights for zabbix user 2016-07-31

    I am setting up zabbix agent to monitor the following commands. UserParameter=mysql.status[*],echo "show global status where Variable_name='$1';" | HOME=/var/lib/zabbix mysql -N | awk '{print $$2}' UserParameter=mysql.size[*],echo "select s

    Tags: mysql
  • Replace mysql user shell in /etc/passwd using sed 2016-07-31

    I am searching a way to replace the mysql user shell configuration in /etc/passwd from command line as there are multiple servers where I want to disable the shell for mysql user. Actual mysql:x:498:498:MySQL server:/var/lib/mysql:/bin/bash Desired m

    Tags: mysql, passwd
  • How to search in blob binary wise, and how to export data binary wise 2016-07-31

    I've a table with a blob field for each row. The blob contains binary data, which can be represented as bytes or text ( using mysql workbench - open value in viewer) 1.Does anybody know how can I search specific sequence of bytes in a given bytes chu

    Tags: blob, mysql, mysqldump, mysql workbench
  • PHPmyadmin don't loggin after I Change the machine time 2016-07-31

    I Have a machine with centos 6 and phpmyadmin, today I Changed the date/time of the machine and a little time after this my phpmyadmin stopped working, I Can't login in him, for example, when I use an aleatory user and password Him say the normal mes

    Tags: php, mysql, login, phpmyadmin, centos6
  • Slow Query With Subqueries 2016-07-30

    I'm still rather new to doing more than just simple selects in mysql and I'm trying to optimize a rather large query. I was wondering if anyone who's been doing this for a while has any guidance on how to make this query run faster as it presently ta

    Tags: mysql, optimization, subquery
  • mysql update sed: -e expression #1, char 17: unknown option to `s' 2016-07-30

    When running the mysql rpm mysql-community-server-5.7.14-1.sles12.x86_64.rpm I get this error: sed: -e expression #1, char 17: unknown option to `s' That far everything works but I noticed immediately after the update there were 712MB! less on the sy

    Tags: mysql
  • This simple, single table query does a filesort, why? 2016-07-30

    The table: CREATE TABLE `test` ( `status` tinyint(4) NOT NULL, `type` varchar(32) CHARACTER SET ascii NOT NULL COMMENT 'The ID of the target entity.', `created` int(11) NOT NULL, `title` varchar(255) CHARACTER SET utf8mb4 NOT NULL, KEY `status` (`sta

    Tags: mysql, optimization
  • Optimizing a slow query to better use indexing 2016-07-30

    I have a query that looks like the following: SELECT time_stop, some_count FROM foo WHERE user_id = 1 AND time_start >= '2016-07-27 00:00:00' AND time_stop <= '2016-07-27 23:59:59' AND some_count = ( SELECT MAX(some_count) FROM foo WHERE user_id = 1

    Tags: mysql, query performance
  • Database structure planning 2016-07-29

    I'm trying to plan a structure of a table that will contain different kinds of records. I have 3 different options for the records, the columns should look like this: id user_id amount type h1 h2 h3 id user_id amount type h1 h2 id user_id amount type

    Tags: mysql, normalization
  • INSERT INTO a large amount of data with many clients running SELECT 2016-07-29

    I need to run a query like this to insert a large amount of data (millions of rows) into a MySQL table (InnoDB, 5.6.10): INSERT INTO target_table SELECT a FROM source_table ON DUPLICATE KEY a=a; This usually takes around 200 seconds to run when no cl

    Tags: mysql, insert, locking, blocking, mysql 5.6
  • Unable to create Mysql TRIGGER with BEFORE UPDATE and set CURRENT_TIMESTAMP [on hold] 2016-07-29

    I want to create Mysql TRIGGER by setting CURRENT_TIMESTAMP to a column which is going for updated currently. It w CREATE TRIGGER before_booking_update BEFORE UPDATE ON booking FOR EACH ROW BEGIN SET NEW.lastchange = CURRENT_TIMESTAMP; END; MySQL sai

    Tags: mysql
  • Reuse mysql connection in scripts 2016-07-29

    When I use the libmysqlclient library I can use the same opened connection for multiple queries. Specifically, each next query can depend on results of the previous queries (e. g. find tables, then drop one by one). Are there any options to do like w

    Tags: mysql, scripting
  • Data too long for column MYSQL Error 2016-07-29

    I've been pouring over threads regarding this issue, but ours seems unique in that it's not an issue with the query but the row itself; or at least I couldn't find a similar topic addressing how to fix the row. A simple query like this: > update cust

    Tags: mysql, update, errors
  • How Update column based at other column value 2016-07-29

    I have a table with 4 column : postID - postREF - postValue - postimageID I want to do update at postVAlUE but under a condition that postimageID = 50; so now I use : update Mytable SET postValue = "test2" WHERE postID = 20; but I need to check

    Tags: mysql, phpmyadmin
  • mySQL query error in IPB 2016-07-29

    Im using Invision Power Board (IPB) and have some trouble accessing admin panel. From time to time I get this error and I need to login again to actually log in: Date: Fri, 29 Jul 2016 10:19:50 +0000 Error: 1054 - Unknown column 'time_spent' in 'fiel

    Tags: mysql, sql, query
  • The table mysql.proc is missing, corrupt, or contains bad data 2016-07-29

    In MySQL I'm getting the following error message when trying to call a stored procedure: The table mysql.proc is missing, corrupt, or contains bad data I've tried performing CHECK and REPAIR on the table, but it's not made any difference. How can I f

    Tags: mysql
  • Rows as columns in MYSQL

    Rows as columns in MYSQL 2016-07-29

    My table, t, has the following format: I would like to transform this table into: The COUNT_XXXXX columns are determined by counting the number of rows where CLICKSKEY is not NULL organised by SUBJECT_TYPE. The COUNT_CLICKED column counts the number

    Tags: mysql, pivot
  • Inserting 30k prices each minute, how can I skip an entry if the price did not change? 2016-07-29

    I receive around 30k price updates for various articles every minute and I need to write the new prices into our database (Which is a MySQL Database running InnoDB) The table containing the prices right now has only three columns: Article_id, InsertT

    Tags: mysql, database design, query performance
  • Computation from 2 Tables turns to be Negative

    Computation from 2 Tables turns to be Negative 2016-07-29

    Good Morning. I have some Question and I hope the Title fits to it. Here is my Problem, I have 2 Tables. Table Receiving Table receiving has 2 Important columns and that is QtyPack and QtyStan and Please take note that QtyPack is a whole number and Q

    Tags: mysql

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development


Front-end development


development tools

Open Platform

Javascript development

.NET development

cloud computing


Copyright (C), All Rights Reserved.

processed in 0.373 (s). 8 q(s)