New answers tagged

0

If I understand this correctly, you want to exclude (from your PHP "table") those columns where the header value (column name) is '--HIDE--'. You could do this with looping constructs in your PHP code, parsing each row in turn, looping through each field in that row and matching the corresponding value in the header values. Possible, but messy. BY far ...


0

Yes you can. In phpMyAdmin go to table structure. On bottom you can press option "Move columns" There you can rearange tables as you see fit.


0

Thank god,Finally it worked out. first I created a file named as mysql-init.txt in c drive.The file contains update mysql.user set Select_priv='Y', Insert_priv='Y', Update_priv='Y', Delete_priv='Y', Create_priv='Y', Drop_priv='Y', Reload_priv='Y', Shutdown_priv='Y', Process_priv='Y', File_priv='Y', Grant_priv='Y', ...


0

Check the WP plugins. Some of them create thousands of "options" and fail to clean up after themselves.


0

As per suggested by Mr. Barmar it was causing due to --skip-grant-tables in MySQL. To disable this option just run FLUSH PRIVILEGES; command in your MySQL CLI and this will solve the issue.


0

Use common string functions and extract the value you need. SELECT id, SUBSTRING_INDEX(SUBSTRING_INDEX(amount_detail, '"date":"', -1), '"', 1) AS date_from_JSON FROM sourcetable


0

Native JSON support wasn't introduced until MySQL 5.7 so you're out of luck if you're still running [the six-year-old] version 5.6. I have to question why this is being stored as JSON in the first place. This looks to me like perfectly normal, relational-style Data that could be stored in a conventional table structure: create table table1 ( id int ...


Top 50 recent answers are included