422 solutions found in database
Page 6 of 22votes
I'm trying to connect to my MySQL DB with the Terminal on my Apple (With PHP). Yesterday it worked fine, and now I suddenly get the error in the title....
votes
I've been using indexes on my MySQL databases for a while now but never properly *learnt* about them. Generally I put an index on any fields that I will be...
votes
I'm using `now()` in MySQL query. INSERT INTO table SET data = '$data', date = now() But I want to add 1 day to this date (so that `date...
votes
I have a form on a website which has a lot of different fields. Some of the fields are optional while some are mandatory. In my DB I have a table which holds al...
votes
The MySQL reference manual does not provide a clearcut example on how to do this. I have an ENUM-type column of country names that I need to add more countri...
votes
I've read that Mysql server creates a log file where it keeps a record of all activities - like when and what queries execute. Can anybody tell me wher...
votes
I cannot figure out my MySQL root password; how can I find this out? Is there any file where this password is stored? I am following this [link][1] but I do...
votes
I have two tables, one for job deadlines, one for describe a job. Each job can take a status and some statuses means the jobs' deadlines must be deleted fro...
votes
How do I drop all tables in Windows MySQL, using command prompt? The reason I want to do this is that our user has access to the database drops, but no access t...
votes
I need to do a mysqldump of a database on a remote server, but the server does not have mysqldump installed. I would like to use the mysqldump on my machine to...
votes
I have a table whose primary key is used in several other tables and has several foreign keys to other tables. CREATE TABLE location ( locationI...
votes
I am trying to understand how to UPDATE multiple rows with different values and I just don't get it. The solution is everywhere but to me it looks difficult...
votes
Scenario in short: A table with more than 16 million records [2GB in size]. The higher LIMIT offset with SELECT, the slower the query becomes, when using OR...
votes
If you try to create a TEXT column on a table, and give it a default value in MySQL, you get an error (on Windows at least). I cannot see any reason why a text...
votes
What's the main difference between `length()` and `char_length()`? I believe it has something to do with binary and non-binary strings. Is there any pra...
votes
table #1: | Field | Type | Null | Key | Default | Extra | | -------- | -------------- | ----- |--- | --------|------ | | UserID | int(11)...
votes
Are table names in MySQL case sensitive? On my Windows development machine the code I have is able to query my tables which appear to be all lowercase. When...
votes
I have a perplexing issue that I can't seem to comprehend... I have two SQL statements: - The first enters information from a form into the database....
votes
I accidentally installed the PowerPC version of MySQL on my Intel Mac in Snow Leopard, and it installed without a problem but of course doesn't run properly...
votes
Is there a way to check if a table exists *without* selecting and checking values from it? That is, I know I can go `SELECT testcol FROM testtable` and check...