422 solutions found in database
Page 16 of 22votes
I am really interested in how MySQL indexes work, more specifically, how can they return the data requested without scanning the entire table? It's off-t...
votes
What's the difference between VARCHAR and CHAR in MySQL? I am trying to store MD5 hashes.
votes
I have installed MySQL Community Edition 5.5 on my local machine and I want to allow remote connections so that I can connect from external source. How can I...
votes
How can I import a database with mysql from terminal? I cannot find the exact syntax.
votes
I want to keep a backup of all my MySQL databases. I have more than 100 MySQL databases. I want to export all of them at the same time and again import all of t...
votes
I want to add a Foreign Key to a table called "katalog". ALTER TABLE katalog ADD CONSTRAINT `fk_katalog_sprache` FOREIGN KEY (`Spra...
votes
How do I rename a column in table `xyz`? The columns are: Manufacurerid, name, status, AI, PK, int I want to rename to `manufacturerid` I tried usi...
votes
On one server, when I run: mysql> select now(); +---------------------+ | now() | +---------------------+ | 2009-05-...
votes
I have an email column that I want to be unique. But I also want it to accept null values. Can my database have 2 null emails that way?
votes
I have a database that is quite large so I want to export it using Command Prompt but I don't know how to. I am using WAMP.
votes
Without local access to the server, is there any way to duplicate/clone a MySQL db (with content and without content) into another without using `mysqldump`?...
votes
Error SQL query: -- -- Database: `work` -- -- -------------------------------------------------------- -- -- Table structure f...
votes
Let's say I am doing a MySQL `INSERT` into one of my tables and the table has the column `item_id` which is set to `autoincrement` and `primary key`. **H...
votes
What is the difference between tinyint, smallint, mediumint, bigint and int in MySQL? In what cases should these be used?
votes
I need to store a url in a MySQL table. What's the best practice for defining a field that will hold a URL with an undetermined length?
votes
I'm trying to find out if a row exists in a table. Using MySQL, is it better to do a query like this: SELECT COUNT(*) AS total FROM table1 WHERE ......
votes
Is there a way to grab the columns name of a table in MySQL using PHP?
votes
What is the (default) charset for: - MySQL database - MySQL table - MySQL column
votes
In MySQL, how do I get a list of all foreign key constraints pointing to a particular table? a particular column? This is the same thing as [this Oracle questio...
votes
Is it possible to make a simple query to count how many records I have in a determined period of time like a year, month, or day, having a `TIMESTAMP` field, li...