2108 solutions found
Page 32 of 106votes
I'm running MySQL version 8 on PHP 7.0. I'm getting the following error when I try to connect to my database from PHP: > Connect Error: SQLSTAT...
votes
I have a table called `provider`. I have three columns called `person`, `place`, `thing`. There can be duplicate persons, duplicate places, and duplicate things...
votes
Is there a way in a MySQL statement to order records (through a date stamp) by >= NOW() -1 so all records from the day before today to the future are selecte...
votes
I'm trying to follow along [this tutorial](http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html) to enable remote acces...
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 am trying to optimize one part of my code that inserts data into MySQL. Should I chain INSERTs to make one huge multiple-row INSERT or are multiple separate I...
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
There are many conflicting statements around. What is the best way to get the row count using PDO in PHP? Before using PDO, I just simply used `mysql_num_rows`....
votes
I need to change my column type from date to datetime for an app I am making. I don't care about the data as its still being developed. How can I do this...
votes
table #1: | Field | Type | Null | Key | Default | Extra | | -------- | -------------- | ----- |--- | --------|------ | | UserID | int(11)...
votes
I'm using the below code to pull some results from the database with Laravel 5. BookingDates::where('email', Input::get('email'))->...
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...