Top "Mysql" questions

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

MySQL: selecting rows where a column is null

I'm having a problem where when I try to select the rows that have a NULL for a certain column, …

mysql null
start MySQL server from command line on Mac OS Lion

I installed mySQL for my Mac. Beside starting the SQL server with mySQL.prefPane tool installed in System Preference, I …

mysql macos command-line osx-lion
How do I use MySQL through XAMPP?

I installed XAMPP v3.2.1 because I wanted to learn how to create database in MySQL and learn more about TOMCAT. …

mysql xampp localhost
MySQL error: key specification without a key length

I have a table with a primary key that is a varchar(255). Some cases have arisen where 255 characters isn't enough. …

mysql sql mysql-error-1170
INSERT with SELECT

I have a query that inserts using a select: INSERT INTO courses (name, location, gid) SELECT name, location, gid FROM …

mysql sql insert-select
How to check if mysql database exists

Is it possible to check if a (MySQL) database exists after having made a connection. I know how to check …

mysql database exists
Find the number of columns in a table

It is possible to find the number of rows in a table: select count(*) from tablename Is it possible to …

sql mysql
How to find out the username and password for mysql database

I've forgotten what I set as username and password for mysql database. How could I be able to find it …

mysql passwords
mysql error 1364 Field doesn't have a default values

My table looks like create table try ( name varchar(8), CREATED_BY varchar(40) not null); and then I have a trigger …

mysql
How can I use mySQL replace() to replace strings in multiple records?

We have a database that has a bunch of records with some bad data in one column, in which an …

mysql replace