422 solutions found in database
Page 10 of 22votes
I'm rewriting a project to use Node.js. I'd like to keep using MySQL as the DB (even though I don't mind rewriting the schema). I'm looking for...
votes
Is there a nice way in MySQL to replicate the SQL Server function `ROW_NUMBER()`? For example: SELECT col1, col2, ROW_NUMBER() OVE...
votes
Given an array of ids `$galleries = array(1,2,5)` I want to have a SQL query that uses the values of the array in its WHERE clause like: <!-- language: la...
votes
In our place we're split between using mysqli and PDO for stuff like prepared statements and transaction support. Some projects use one, some the other. The...
votes
This is how my connection is set: `Connection conn = DriverManager.getConnection(url + dbName + "?useUnicode=true&characterEncoding=utf-8", use...
votes
I would like to know the command to perform a mysqldump of a database without the prompt for the password. REASON: I would like to run a cron job, which tak...
votes
Is there any way to later output the name of the database that is currently selected?
votes
I have two tables, both looking like id name value =================== 1 Joe 22 2 Derk 30 I need to copy the value of `va...
votes
Does MySQL index foreign key columns automatically?
votes
I'm working with map data, and the `Latitude/Longitude` extends to 8 decimal places. For example: Latitude 40.71727401 Longitude -74.00898606...
votes
In MySQL I am trying to copy a row with an **autoincrement** `column ID=1` and **insert** the data into same table as a new row with `column ID=2`. How can I...
votes
Is it possible to do a select statement that takes only NOT NULL values? Right now I am using this: SELECT * FROM table And then I have to filter o...
votes
I'm working on getting my database to talk to my Java programs. Can someone give me a quick and dirty sample program using the JDBC? I'm getting a...
votes
I'm building a Django site and I am looking for a search engine. A few candidates: - Lucene/Lucene with Compass/Solr - Sphinx - Postgresql built...
votes
If I have a table CREATE TABLE users ( id int(10) unsigned NOT NULL auto_increment, name varchar(255) NOT NULL, profession varchar(2...
votes
How do I use the `json_encode()` function with MySQL query results? Do I need to iterate through the rows or can I just apply it to the entire results object?
votes
I'm having a problem where when I try to select the rows that have a NULL for a certain column, it returns an empty set. However, when I look at the table i...
votes
When I run `show status like 'Con%'` it shows the number of connections, which is 9972 and constantly growing. Is this an active number of connections o...
votes
I have created a table and accidentally put `varchar` length as `300` instead of `65353`. How can I fix that? An example would be appreciated.
votes
How do I enable the MySQL function that logs each SQL query statement received from clients and the time that query statement has submitted? Can I do that in p...