Top "Mysql" questions

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

How to take MySQL database backup using MySQL Workbench?

How to take database backup using MySQL Workbench? Can we take backup in the following ways- Backup file(.sql) contains …

mysql database mysql-workbench database-backups
MySQL Database won't start in XAMPP Manager-osx

I downloaded XAMPP about a month ago and it was working just fine. Today I installed a voice recognition software …

php mysql macos xampp
Does MySQL foreign_key_checks affect the entire database?

When I execute this command in MySQL: SET FOREIGN_KEY_CHECKS=0; Does it affect the whole engine or it is …

mysql
How to display errors for my MySQLi query?

I am using the following script to process a form to add info to my website. The problem I am …

php mysql mysqli
Escaping single quote in PHP when inserting into MySQL

I have a perplexing issue that I can't seem to comprehend... I have two SQL statements: The first enters information …

php mysql insert escaping
How to best display in Terminal a MySQL SELECT returning too many fields?

I'm using PuTTY to run: mysql> SELECT * FROM sometable; sometable has many fields and this results in many columns …

mysql command-line select putty
Equivalent of varchar(max) in MySQL?

What is the equivalent of varchar(max) in MySQL?

mysql varchar
How to Check if value exists in a MySQL database

Suppose I have this table: id | name | city ------------------ 1 | n1 | c1 2 | n2 | c2 3 | n3 | c3 4 | n4 | c4 I want to …

php mysql exists
MySQL Select Date Equal to Today

I'm trying to run a mysql select statement where it looks at today's date and only returns results that signed …

mysql
How to add not null constraint to existing column in MySQL

I have table name called "Person" with following column names P_Id(int), LastName(varchar), FirstName (varchar). I forgot to …

mysql constraints