2108 solutions found
Page 27 of 106votes
I need to delete all rows from a table but when I add a new row, I want the primary key ID, which has an auto increment, to start again from 0 respectively from...
votes
Error message on MySql: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' I have gone thro...
votes
I have table name called "Person" with following column names P_Id(int), LastName(varchar), FirstName (varchar). I forgot to give...
votes
Are there are any Linux mysql command line tools that don't require the entire mysql db installation package to be installed? What I'm trying to do...
votes
I have latitude and longitude and I want to pull the record from the database, which has nearest latitude and longitude by the distance, if that distance gets l...
votes
I am wondering if there is any difference with regards to performance between the following SELECT ... FROM ... WHERE someFIELD IN(1,2,3,4) SE...
votes
What is the equivalent of varchar(max) in MySQL?
votes
Is there a measurable performance difference between using INT vs. VARCHAR as a primary key in MySQL? I'd like to use VARCHAR as the primary key for referen...
votes
I have been trying to reset my MySQL root password. I have run `mysqld_safe --skip-grant-tables`, updated the root password, and checked the user table to make...
votes
I'm trying to run WordPress in my Windows desktop and it needs MySQL. I install everything with `Web Platform Installer` which is provided by Microsoft....
votes
What is the upper limit of records for MySQL database table. I'm wondering about autoincrement field. What would happen if I add milions of records? How to...
votes
I'm looking at MySQL procedures and functions. What is the real difference? They seem to be similar, but a function has more limitations. I'm lik...
votes
While importing the database in mysql, I have got following error: > 1418 (HY000) at line 10185: This function has none of DETERMINISTIC, NO SQL, or READS...
votes
I have two tables in MySQL. Table Person has the following columns: id | name | fruits ---|------|------- The `fruits` column may hold null or an array o...
votes
with the following statement: mysqldump --complete-insert --lock-all-tables --no-create-db --no-create-info --extended-insert --password=XXX -u...
votes
I cant get my mysql to start on os x 10.7. It is located in `/usr/local/mysql/bin/mysql` I get command not found when I type `mysql --version` in the termi...
votes
What good resources exist for understanding database tuning on the major engines and advancing your knowledge in that area? The idea of this question is to c...
votes
I am working on a project where i need to create a database with 300 tables for each user who wants to see the demo application. it was working fine but today w...
votes
I have two columns in table users namely `registerDate and lastVisitDate` which consist of datetime data type. I would like to do the following. 1. Set regi...
votes
I have 1-many number of records that need to be entered into a table. What is the best way to do this in a query? Should I just make a loop and insert one rec...