422 solutions found in database
Page 15 of 22votes
When we create a table in MySQL with a `VARCHAR` column, we have to set the length for it. But for `TEXT` type we don't have to provide the length. What...
votes
When I run the following query I get an error: SELECT `a`.`sl_id` AS `sl_id`, `a`.`quote_id` AS `quote_id`,...
votes
Bearing in mind that I'll be performing calculations on lat / long pairs, what datatype is best suited for use with a MySQL database?
votes
I'm interested in learning some (ideally) database agnostic ways of selecting the *n*th row from a database table. It would also be interesting to see how t...
votes
I asked a question and got this reply which helped. UPDATE TABLE_A a JOIN TABLE_B b ON a.join_col = b.join_col AND a.column_a = b.column_b...
votes
My MySQL database contains several tables using different storage engines (specifically myisam and innodb). How can I find out which tables are using which e...
votes
From the [MySQL](https://www.mysql.com/) console, what command displays the schema of any given table?
votes
How would I delete all duplicate data from a MySQL Table? For example, with the following data: SELECT * FROM names; +----+--------+ | id...
votes
I have a `datetime` column in MySQL. How can I convert it to the display as **mm/dd/yy H:M (AM/PM)** using PHP?
votes
I believe that I've successfully deployed my (very basic) site to fortrabbit, but as soon as I connect to SSH to run some commands (such as `php artisan mig...
votes
I'm trying to use a select statement to get all of the columns from a certain MySQL table except one. Is there a simple way to do this? EDIT: There are 5...
votes
Some background: I have a Java 1.6 webapp running on Tomcat 7. The database is MySQL 5.5. Previously, I was using Mysql JDBC driver 5.1.23 to connect to the...
votes
I would like to know the following: - how to get data from multiple tables in my database? - what types of methods are there to do this? - what are joins a...
votes
Basically the question is how to get from this: <pre> foo_id foo_name 1 A 1 B 2 C </pre> to this: <pre>...
votes
I am trying to execute the following query: INSERT INTO table_listnames (name, address, tele) VALUES ('Rupert', 'Somewhere', '02...
votes
Is there a way to get the count of rows in all tables in a MySQL database without running a `SELECT count()` on each table?
votes
I have a MySQL table which is as follows: | id | name | parent_id |:--:|:-----------:|:---------: | 19 | category1 | 0 | 20 | category2...
votes
I'm using MySQL 5.7.13 on my windows PC with WAMP Server. My problem is while executing this query SELECT * FROM `tbl_customer_pod_uploads`...
votes
I have a table with the following fields: id (Unique) url (Unique) title company site_id Now, I need to remove rows having same `...
votes
I know that you can insert multiple rows at once, is there a way to update multiple rows at once (as in, in one query) in MySQL? Edit: For example I have th...