Top "Mysql" questions

MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).

Cannot change column used in a foreign key constraint

I got this error when i was trying to alter my table. Error Code: 1833. Cannot change column 'person_id': used …

mysql
Can't drop table: A foreign key constraint fails

In MySQL I want to drop a table. I tried a lot things but I keep getting the error that …

mysql sql drop-table
How to get primary key of table?

Is there a way to get the name of primary key field from mysql-database? For example: I have a table …

php mysql primary-key
Default password of mysql in ubuntu server 16.04

I have installed ubuntu 16.04 server. Mysql server was installed by default in it. When I am trying to access the …

mysql ubuntu passwords ubuntu-16.04 ubuntu-server
Common MySQL fields and their appropriate data types

I am setting up a very small MySQL database that stores, first name, last name, email and phone number and …

mysql database types
Storing and displaying unicode string (हिन्दी) using PHP and MySQL

I have to store hindi text in a MySQL database, fetch it using a PHP script and display it on …

php mysql unicode utf-8 internationalization
Replace Default Null Values Returned From Left Outer Join

I have a Microsoft SQL Server 2008 query that returns data from three tables using a left outer join. Many times, …

mysql sql sql-server tsql sql-server-2008
java.sql.SQLException: Incorrect string value: '\xF0\x9F\x91\xBD\xF0\x9F...'

I have the following string value: "walmart obama 👽💔" I am using MySQL and Java. I am getting the following exception: `…

java mysql encoding character-encoding sqlexception
sql - insert into multiple tables in one query

assuming that i have two tables, names and phones and i want to insert data from some input to the …

sql mysql multiple-tables insert-into
Preserve Line Breaks From TextArea When Writing To MySQL

I'm using a textarea to enable users to input comments. However, if the users enters new lines, the new lines …

php mysql html