MySQL Archives - Page 10 of 38

I have a table with a unique key for two columns: CREATE TABLE `xpo`.`user_permanent_gift` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT , `fb_user_id` ...

May 26, 2022
0 Comments

MySQL, Programming

IT Nursery

Can I restore a single table from a full mysql mysqldump file?

I have a mysqldump backup of my mysql database consisting of all of our tables which is about 440 megs. I want to ...

May 26, 2022
0 Comments

MySQL Cannot drop index needed in a foreign key constraint

I need to ALTER my existing database to add a column. Consequently I also want to update the UNIQUE field to encompass that ...

May 26, 2022
0 Comments

MySQL: Cloning a MySQL database on the same MySql instance

I would like to write a script which copies my current database sitedb1 to sitedb2 on the same mysql database instance. I know ...

May 26, 2022
0 Comments

How do you stop MySQL on a Mac OS install?

I installed MySQL via MacPorts. What is the command I need to stop the server (I need to test how my application behave ...

May 26, 2022
0 Comments

Dropping Unique constraint from MySQL table

How can I drop the “Unique Key Constraint” on a column of a MySQL table using phpMyAdmin? 10 Answers 10

May 25, 2022
0 Comments

MySql: Tinyint (2) vs tinyint(1) – what is the difference?

I knew boolean in mysql as tinyint (1). Today I see a table with defined an integer like tinyint(2), and also others like ...

May 25, 2022
0 Comments