Database Archives - Page 35 of 44

I would like to know the following: how to get data from multiple tables in my database? what types of methods are there ...

This question already has answers here: Remove duplicate rows in MySQL (26 answers) Closed 2 years ago. How would I delete all duplicate ...

Bearing in mind that I’ll be performing calculations on lat / long pairs, what datatype is best suited for use with a MySQL ...

I’ve got a very large MySQL table with about 150,000 rows of data. Currently, when I try and run SELECT * FROM table ...

I am learning MySQL and tried using a LOAD DATA clause. When I used it as below: LOAD DATA INFILE "text.txt" INTO table ...

Is there a MySQL command to locate the my.cnf configuration file, similar to how PHP’s phpinfo() locates its php.ini? 30 s 30 There ...

I’m just getting started learning SQLite. It would be nice to be able to see the details for a table, like MySQL’s DESCRIBE ...

MySQL 5.0.45 What is the syntax to alter a table to allow a column to be null, alternately what’s wrong with this: ALTER ...

How can I kill all my postgresql connections? I’m trying a rake db:drop but I get: ERROR: database "database_name" is being accessed by ...