How can I get a list of user accounts using the command line in MySQL?
I’m using the MySQL command-line utility and can navigate through a database. Now I need to see a list of user accounts. How … Read more
Database
Can I concatenate multiple MySQL rows into one field?
Using MySQL, I can do something like: SELECT hobbies FROM peoples_hobbies WHERE person_id = 5; My Output: shopping fishing coding but instead I … Read more
How to reset AUTO_INCREMENT in MySQL
How can I reset the AUTO_INCREMENT of a field? I want it to start counting from 1 again. 2 25 You can reset … Read more
SQL select only rows with max value on a column [duplicate]
Want to improve this post? Provide detailed answers to this question, including citations and an explanation of why your answer is correct. without … Read more
What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
This question already has answers here: What is the difference between “INNER JOIN” and “OUTER JOIN”? (27 answers) Closed 6 years ago. What’s … Read more
How do I import an SQL file using the command line in MySQL?
I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. … Read more
Should I use the datetime or timestamp data type in MySQL?
Would you recommend using a datetime or a timestamp field, and why (using MySQL)? I’m working with PHP on the server side. 40 … Read more
WordPress Editor not updating files
WordPress Editor not updating files: Unable to communicate back with site to check for fatal errors Now, this technically didn’t fix the issue … Read more
Why shouldn’t Use mysql_* functions in PHP
What are the technical reasons for why one shouldn’t use mysql_* functions? (e.g. mysql_query(), mysql_connect() or mysql_real_escape_string())? Why should I use something else even if they work on my … Read more
How to Update same table on deletion in MYSQL
In my database I have a table Employee that has recursive association (an employee can be boss of other employee): Then inserts: Now I … Read more