mySQL

MySQL shutdown unexpectedly

Error: MySQL shutdown unexpectedly. This may be due to a blocked port, missing dependencies, The rest of the log: InnoDB: Error: could not open single-table tablespace file .xatpayments.ibd InnoDB: We do not continue the crash recovery, because the table may become InnoDB: corrupt if we cannot apply the log records in the InnoDB log to …

MySQL shutdown unexpectedly Selengkapnya »

mySQL Count Table

$result = mysqli_query($con,”SELECT COUNT(*) FROM TABLE WHERE FIELD LIKE ‘Domain%’;”); $data = mysqli_fetch_array($result); echo $data[0];

Duplicate Database

CREATE TABLE AND STRUCTURE CREATE TABLE NEWTABLE LIKE OLDTABLE; INSERT ALL DATA TO NEW TABLE INSERT NEWTABLE SELECT * FROM OLDTABLE`NEWTABLE `;

×