I'm getting the following error with my code below
Error Executing Database Query.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo...
hello,
I am getting this error when I try to execute this command
SELECT * FROM Groups WHERE domain_id=1 group by id
#1 - Can't create/write to file '/var/lib/mysql/#sql_5960_0.MYI' (Errc...
I have one table with 3 values:
tablex
sku_id weight1 weight2
1234 1 2
1234 1.4 2
I need to identify any sku_id in colu...
Server Error in '/Reports' Application.
--------------------------------------------------------------------------------
Attempted to load a 64-bit assembly on a 32-bit platform. Use Refle...
I have a query where you only specify the month value, and then you'll get a table-like output where the user can see for the specified month, what day of the week had the most rents (with a '...
I have 2 mysql start in same server.
one to port 3306 and socket /tmp/mysql.sock
one to port 3308 and socket /tmp/mysql2.sock
I want can connect with script shell to mysql1 or mysql2
h...
Please can you let me know how to clean up the old data in a table before I can insert new data? Do you have a query that I can use?
TIA.
V.
How can I be able to truncate a large table instead of doing a delete on the data? Pls do you have a sample query?
TIA.
V.
When to use Fill Text Searching? On which data types?
Does MySQL support Row-Versioning? What type of locking is used to manage concurrency?
Can I pass parameters to a Trigger?
I have the following two tables(fields):
synset(synsetid,definition)
sense(wordid,synsetid)
both fields are UNIQUE in the synset table, but neither field is UNIQUE in the sense table.
...
I have a small script that runs on a server that has mysql, then nrpe returns the output to the nagios server. I want to change this so that the nagios server runs the script by logging into t...
Hi everyone,
I have a unique request. I must do a comparison on the db side of 2 or more result sets, and locate only the rows that have matches in other datasets being compared.
In summ...
Hi experts,
How can I read .db files generated using Sqlite.
Please say a software by which I could view this file in a table format.
Please help.
Any help in this regard will be well app...
I have an ASP.net web application running on a IIS server using MySQL DB
I have a form that allows the customer to use many text area boxes input to allow 500 chars for 25 text area boxes i...
This is in relation to my previous question:
http://www.experts-exchange.com/Database/MySQL/Q_23944816.html
So this is probably directed more to angelIII. Unfortunately, these queries ta...
Ive just completed a site using php and mysql.
now my host tells me they dont support mysql but only use mssql.
Am I able to use mssql?
any feedback would be appreciated.
I have a table item_master with several fields:
product_id date
Each product ID can have mulitple records. I need select each row where the product ID only has had one entry and the date ...
Say we have a table with the fields named id and codes. the codes field would be delimited by commas or any other character. Would it be possible, if yes how, to run a query that would be:
...
I have the following error when trying to open database table:
Can't open file: table_name MYI (errno:144)
Any idea how to resolve and open the table.
Regards,
introlux
Hello,
Here is my MySQL table structure as shown below.
The "timestamp" field is populated using PHP time() function when any search is performed.
Can you please tell me how can I sho...
hi,
Everytime I open MySQl Administrator, I get an error informing me that the config file could not be found. Startup variables and service section are therefore disabled.
I need this s...
Dear experts,
I have to implement a system that uses several types of fees (tuition, laboratory, books, and others). As of now there are 10 different types, but in the future, they will div...
Hi,
I am trying to install phpMyAdmin on my Window XP system. Apache server and PHP works fine and MySQL works fine by itself.
This is what I have done
1) I downloaded a phpMyAdmin-3.0.0...
