storing negative value in mysql?

How can I store negative value in mysql decimal? I have data from DMS to Decimal having negative values, so it is de...

How can I simulate an array variable in MySQL??

It appears that MySQL doesn't have array variables. What should I use instead? There seem to be two alternatives...

How and when to use SLEEP() correctly in MySQL??

In relation to my other question today I am wondering how to use MySQL's SLEEP(duration) correctly. From what I gat...

MySQL: how to do row-level security (like Oracle's Virtual Private Database)??

Say that I have vendors selling various products. So, at a basic level, I will have the following tables: vendor, pr...

Count with IF condition in MySQL query?

I have two tables, one is for news and the other one is for comments and I want to get the count of the comments who...

How to use `bcrypt` algorithm within `encrypt` function in MySQL for verifying password??

I have bcrypted value($2y$10$zQaDT8hXM4pLmBdwN0xEseda/oKJAQKMKMzUrV8jbs6Epz28BXzBS) of password (qwe). But when I am...

PHP mysql search multiple tables using a keyword?

I have three tables in my database which are: messages topics comments Each of these tables has two fields called...

How to enable INNODB in mysql?

When I execute a query in MySQL it returns an error saying that InnoDB is not enabled. When I clicked the storage en...

How can VBA connect to MySQL database in Excel??

Dim oConn As ADODB.Connection Private Sub ConnectDB() Set oConn = New ADODB.Connection Dim str As String str = "DRIV...

How can I edit a view using phpMyAdmin 3.2.4??

I need to simply edit a very complicated view in phpMyAdmin 3.2.4 but I cannot figure how to do that. Any suggestion...

MySQL bulk drop table where table like??

DROP TABLE ( SELECT table_name FROM information_schema.`TABLES` WHERE table_schema = 'myDatabase' AND table_name LIK...

check if column exists before ALTER TABLE — mysql?

Is there a way to check if a column exists in a mySQL DB prior to (or as) the ALTER TABLE ADD coumn_name statement r...