👻 Ghost Records 👻

« first day (299 days earlier) ← previous day next day → last day (1275 days later) »

6:51 AM

-2

Q: what is the use of having 1 = 0 in where clause

what does will be the output if keep 1=0 in where clause. select columns from my_table where 1 = 0 and column_a = 'value' and column_b = 'value';

Paul White

7:06 AM

← 1 message moved from DROP QUESTION queue;

← 2 messages moved from DROP QUESTION queue;

3 hours later…

Paul White

10:35 AM

Q: After restoring, mysql databases not in /var/lib/mysql but can query

I restored a database from a mysqldump and the database restored and the data is there. Unfortunately the database files are missing from /var/lib/mysql. The /etc/my.conf shows this to be the directory. This is causing issues because remote queries are getting database not found. Is there any way...

mysql mariadb

Q: MySQL queries not being executed for certain DB

I have a server that running multiple DBs, one of these DB just imported via mysqldump (.sql file). But the issue is I can't run any query on this DB, Also I can't even select it in normal mode. I have to run mysql -A just to select this DB and show its tables. However, any other type of que...