422 solutions found in database
Page 13 of 22votes
I'm trying to setup up MySQL on mac os 10.6 using Homebrew by `brew install mysql 5.1.52`. Everything goes well and I am also successful with the `mysql_...
votes
I am moving away from Linode because I don't have the Linux sysadmin skills necessary; before I complete the transition to a more noob-friendly service, I n...
votes
Someone sent me a SQL query where the `GROUP BY` clause consisted of the statement: `GROUP BY 1`. This must be a typo right? No column is given the alias 1....
votes
I have installed a recent community version of MySQL from MySQL site. The version is `5.6.x`. It was done using an installer and I also chose the option to c...
votes
What is the correct format to pass to the `date()` function in PHP if I want to insert the result into a MySQL `datetime` type column? I've been trying `...
votes
My Current Data for SELECT PROD_CODE FROM `PRODUCT` is PROD_CODE 2 5 7 8 22 10 9 11 I have tried all...
votes
How do you select all the columns from one table and just some columns from another table using JOIN? In MySQL.
votes
When I tried running the following command on MySQL from within Terminal: mysql -u $user -p$password -e "statement" The execution works as e...
votes
How can you connect to MySQL from the command line in a Mac? (i.e. show me the code) I'm doing a PHP/SQL tutorial, but it starts by assuming you're...
votes
I'm testing the speed of some queries in MySQL. The database is caching these queries making it difficult for me to get reliable results when testing how fa...
votes
I am looking for the syntax for dumping all data in my mysql database. I don't want any table information.
votes
I am trying to forward engineer my new schema onto my database server, but I get this error. Everything I've found has said to either set the database en...
votes
Is there a difference between a schema and a database in MySQL? In SQL Server, a database is a higher level container in relation to a schema. I read that `...
votes
I have a innoDB table which records online users. It gets updated on every page refresh by a user to keep track of which pages they are on and their last access...
votes
How do I set the initial value for an "id" column in a MySQL table that start from 1001? I want to do an insert `"INSERT INTO users (name, ema...
votes
I'm using [PuTTY][1] to run: mysql> SELECT * FROM sometable; `sometable` has many fields and this results in many columns trying to be displaye...
votes
If I have a MySQL table looking something like this: company_name| action |pagecount ------------|-----------|-------- Company A | PRINT |3 Company A |...
votes
I've just started getting into Node.js. I come from a PHP background, so I'm fairly used to using MySQL for all my database needs. How can I use MySQ...
votes
I have an unnormalized events-diary CSV from a client that I'm trying to load into a MySQL table so that I can refactor into a sane format. I created a tabl...
votes
I have been very excited about MongoDb and have been testing it lately. I had a table called posts in MySQL with about 20 million records indexed only on a fiel...