Database Archives - Page 44 of 44

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 ...

April 13, 2022
0 Comments

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 ...

April 13, 2022
0 Comments

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 ...

April 12, 2022
0 Comments

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 ...

April 10, 2022
0 Comments

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. ...

April 10, 2022
0 Comments

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 ...

April 10, 2022
0 Comments

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 ...

March 6, 2022
0 Comments

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 ...

March 4, 2022
0 Comments

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 ...

March 1, 2022
0 Comments