Popular "mysql" questions | Page 76

How to get all columns' names for all the tables in MySQL?

Is there a fast way of getting all column names from all tables in MySQL, without having to list all …

mysql database-schema database-metadata

How to remove MySQL completely with config and library files?

So far I've tried the following commands: sudo apt-get remove mysql-server mysql-client mysql-common sudo apt-get purge mysql-server mysql-client mysql-common sudo …

mysql debian

Unioning two tables with different number of columns

I have two tables (Table A and Table B). These have different number of columns - Say Table A has …

sql mysql

PHP MySQL Query Where x = $variable

I have this code (I know that the email is defined) <?php $con=mysqli_connect($host,$user,$pass,$database); …

php mysql variables where

ERROR 1067 (42000): Invalid default value for 'created_at'

When I tried to alter the table it showed the error: ERROR 1067 (42000): Invalid default value for 'created_at' I googled …

mysql

What does `unsigned` in MySQL mean and when to use it?

What does "unsigned" mean in MySQL and when should I use it?

mysql types

BOOLEAN or TINYINT confusion

I was designing a database for a site where I need to use a boolean datetype to store only 2 states, …

mysql types boolean tinyint

How add unique key to existing table (with non uniques rows)

I want to add complex unique key to existing table. Key contains from 4 fields (user_id, game_id, date, time). …

mysql unique-key

How to move columns in a MySQL table?

Currently I am having the following MySQL table: Employees (empID, empName, department); I want to change the table to the …

mysql sql alter

How do I add more members to my ENUM-type column in MySQL?

The MySQL reference manual does not provide a clearcut example on how to do this. I have an ENUM-type column …

mysql enums alter-table

Top "Mysql" questions