Search Results


2 years ago by mohlal

How to get around foreign key constraint check while dropping tables? mysql> drop table users; ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails mysql> . . .

  • 2
  • 1
  • 747

2 years ago by Fischer

How do i list all the foreign keys in a MySQL table?   . . .

  • 3
  • 1
  • 650

2 years ago by noddy

I am trying to insert into MYSQL table some data recieved from AJAX post. Error: Cannot enqueue Handshake after already enqueuing a Handshake.     at Protocol._validateEnqueue (C:\nodejs\n . . .

  • 2
  • 0
  • 7106

2 years ago by Binoy

I have a table with 3 columns, say col1, col2, col3 I want to copy all the data from col2 to col3, how can i do that? . . .

  • 0
  • 0
  • 457

1 year ago by dig_abacus

Hi, I am using $result = mysqli_query($conn,"SELECT COUNT(*) FROM prod_catalogue WHERE cat_id ='".$catid."' " ) or die(mysqli_error($this->dblink)); How do i get the actual count from result beca . . .

  • 4
  • 2
  • 5456