-
All Sites mysql sql sql-server sql-server-2005 sql-server-2008 sql-server-2008-r2 sqlite sqlite2 sqlite3 postgresql postgresql-8.4
change mysql data directory
Is it possible, if I change my default mysql data directory to other. But, will I be able to access the databases from old location.
stackoverflow.com MySQl Configuration Error
When i reinstall mysql database after remove it, I got this error: How can i fix this problem? Thanks!
SQL query to find the highest paid salary for each lanauges
As i am not expert in writing the sql queries so want for help. i have a table called programmer whose structure & data look like: > PNAME DOB DOJ GENDER PROF1 PROF2 …
E/SQLiteLog(1893): (14) cannot open file at line 30176 of [00bb9c9ce4]
I am using this tutorial to import a database into my App. It runs fine on API 10, but on API 17 it throws the following error: 05-19 14:52:46.492: E/SQLiteLog(1893): (14) cannot open file at line …
Mysql Error Output: Column count doesn't match value count at row 1
SQL Query: INSERT INTO probid_users (username, password, email, reg_date, payment_mode, balance, max_credit, salt, tax_account_type, tax_company_name, tax_reg_number, tax_apply_exempt, name, ...
Selecting latest conversations from table containing private messages
I have a table containing personal messages from one user to another. Here is the table structure: mysql> describe pms; +---------+--------------+------+-----+---------+----------------+ | Field …
Wrodpress plugin display query in linked file
I am creating a wordpress plugin that will query a db based off of user entered parameters and display the results in a linked html file. I can get it to display the html page, but the results ...
Does mysql index null values?
I have a mysql table where an indexed INT column is going to be 0 for 90% of the rows. If I change those rows to use NULL instead of 0, will they be left out of the index, making the index about 90% …
NULL in MySQL (Performance & Storage)
What exactly does null do performance and storage (space) wise in MySQL? For example: TINYINT: 1 Byte TINYINT w/NULL 1 byte + somehow stores NULL?
Why are some images not rendering
My program uploads images of various sizes into the blob field of a MySQL database using PHP. I was able to successfully upload different sizes up to 1MB and above. My problem is that when I display …
Show hiscores within Flash?
I am creating a game in Flash using Actionscript 3 and the game is to be integrated into a Facebook app. My question is how do I go about creating and showing a hiscores table within my game? The …
mysql statement not return correct result
I have a mysql row with 'date = 2013-05-02, type = 1' etc. Then I run this query SELECT date, type, status, rate FROM reservation WHERE type = 1 AND date BETWEEN 2013-05-01 AND 2013-05-08 ...
New Lightswitch app will not publish to newly installed server environment
I have fresh Windows 2008 R2 virtual server setup with Windows SQL 2008 R2 (full version). I loaded the Lightswitch prerequisites via Webinstaller 4.5. From a client computer I can get the IIS7 …
Problems with DataAdapter at VB.Net in a connection to SQL Server 2008
I´m experimenting troubles on a local connection to SQL Server 2008, it´s throwing me the next especific error: A network-related or instance-specific error ocurred while establishing a connection to …
Create Table Syntax Error - MS Access, SQL view
Simple question - I keep getting CREATE TABLE Syntax Error, but I don't see the error! My brain will explode shortly so please, I appreciate your help. CREATE TABLE my_employee ( employee_id INTEGER …
Mysql Subquery to reverse order
I have this code and it is not working. I want to reverse the order after i make my query with the latest comments. SELECT * FROM( SELECT users.id, users.nome, users.email,users.foto, ...
Text searching to compare against Mysql database tables
Let's say I have a string containing words. Some of these words may be compound words. I also have a MySQL database which contains a table which contains a column called words. This column may ...
Why does the mysql % permission not work for all remotes on EC2?
I had a mysql admin issue with permissions on % hosts. EC2_DB launched with IP 10.55.142.100 and DNS ip-10-55-142-100.ec2.internal EC2_web launched with IP 10.55.142.144 and DNS ...
MySQL - executing text file with unicode causes “question marks”
The table: CREATE TABLE test (test VARCHAR(10)); test.sql: INSERT INTO test VALUES ('тест'); In bash: $ mysql --version mysql Ver 14.14 Distrib 5.5.31, for debian-linux-gnu (x86_64) using …
Lost my column headings SQL
I had the following dummy code (you can use this to test): USE tempdb; GO CREATE TABLE dbo.Products ( ProductID VARCHAR (50), Period VARCHAR (6), Value DECIMAL (15, 2) ); INSERT ...
What's the most efficient way to batch UPDATE queries in MySQL?
I'm writing an application that needs to flush out a large number of updates to the database for an extended period of time, and I've gotten stuck at how to optimize the query. Currently I'm using ...
dba.stackexchange.com Connect to mysql on Amazon EC2 from a remote server
I want to connect to db on EC2 from my local machine, I am not able to do and have tried everything- I am using this command to connect to EC2= mysql -uUSERNAME -hEC2_IP -pPASSWORD The error ...
gaps in employment history
I have a simple employment history database, I store the entry id, user id, their job, start and end date. There may be some overlapping entries. I need to establish that in a given period there are …
How to convert a SQL date to a DateTime?
I have a column with the date type in my SQL database. How can I convert it to C# DateTime and then back again to a SQL date?
Getting data from SQLite database error
I'm getting a error which is really frustrating... I want to get a title out of my database by calling this: public Cursor getTitle(long rowId) throws SQLException { Cursor mCursor = …
Do conditional INSERT with SQL?
I have a database that is updated with datasets from time to time. Here it may happen that a dataset is delivered that already exists in database. Currently I'm first doing a SELECT FROM ... WHERE …
Error decrypting in java
I'm trying to encrypt/decrypt a String in Java. No problem concerning the encryption then stored a in sqlite table. But I always get the same error trying to decrypt it : ...
How do I do IN queries in Go?
I'd like to run a query like this in Go using "database/sql" package: SELECT id, name FROM users WHERE id IN (1,2,3,4); How do I use variable substitution in the query command? E.g., I want to do …
PHP Ajax Friend Request Not Getting User's ID And Name
I'm Making a Social Network and Having Issues With The Add Friend. When You Click "Add Friend" Below it slides down Says Add user and you can click Yes Or Cancel. If You click Yes, Sends the request …
how to solve RunTime error with imageView in android
(java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.assfar/com.example.assfar.hotel.Hotel_Details}: java.lang.NullPointerException i got a run time error with start ...
Email Updates
Log in to receive emails of new questions in this filter. You can receive emails every 15 minutes, every 3 hours, or daily.These users asked the most up-voted questions on this page
