Search Results

Drop table Mysql bypass foreign key constraint

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

MySQL: List all foreign keys in a table

4 years ago by 1

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

  • 3
  • 1
  • 931

NodeJS Cannot enqueue Handshake after already enqueuing a Handshake

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

Copy data from one column to another in MySQL

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

MySQL php mysqli How to use the result of SELECT COUNT(*) mysqli_query

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

InterfaceError: SSL connection error: Failed to set ciphers to use

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

Count number of tables in GCP MySQL Instance

10 months ago by 1

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

  • 0
  • 0
  • 200