Search Results


4 years ago by 1

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
  • 1202

4 years ago by 1

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

  • 3
  • 1
  • 952

4 years ago by 1

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
  • 12241

4 years ago by 1

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
  • 758

3 years ago by 1

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
  • 10697

1 year ago by 1

I am trying to connect to a MySQL database from a Python script which looks like this: import mysql.connector mydb = mysql.connector.connect(   host="localhost",   user="root",   p . . .

  • 0
  • 0
  • 865

1 year ago by 1

What is the command for counting number of tables in all the databases ?   . . .

  • 0
  • 0
  • 224