How can I reset the AUTO_INCREMENT of a field? I want it to start counting from 1 again. 2 25 You can reset the counter with: ALTER TABLE tablename AUTO_INCREMENT = 1 For InnoDB you cannot set the auto_increment value lower or equal to the highest current index. (quote from ViralPatel): Note that you cannot … Read more
Want to improve this post? Provide detailed answers to this question, including citations and an explanation of why your answer is correct. without enough detail may be edited or deleted. This question already has answers here: Retrieving the last record in each group – MySQL (32 answers) Closed 3 years ago. I have this table … Read more
This question already has answers here: What is the difference between “INNER JOIN” and “OUTER JOIN”? (27 answers) Closed 6 years ago. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN in MySQL? 3 Reading this original article on The Code Project will help you a lot: Visual Representation of SQL … Read more
I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and I tried this command database_name < file.sql It is not working. I get syntax … Read more
Would you recommend using a datetime or a timestamp field, and why (using MySQL)? I’m working with PHP on the server side. 40 40
WordPress Editor not updating files: Unable to communicate back with site to check for fatal errors Now, this technically didn’t fix the issue at hand. But I just added a WordPress plugin called Insert Headers and Footers and I added the header script and it worked successfully.
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 site? If they don’t work on my site, why do I get errors like Warning: mysql_connect(): No such file or directory Best Answer The MySQL extension: Is not under active development Is officially deprecated as … Read more
In my database I have a table Employee that has recursive association (an employee can be boss of other employee): [php]create table if not exists `employee` ( `SSN` varchar(64) not null, `name` varchar(64) default null, `designation` varchar(128) not null, `MSSN` varchar(64) default null, primary key (`ssn`), constraint `fk_manager_employee` foreign key (`mssn`) references employee(ssn) ) engine=innodb default charset=latin1;[/php] … Read more
