This coldfusion/MySQL query is driving me crazy. It just won't return the month of september's values from 2007. The column 'trading_data_values.TDVdate' contains several entries for sept with...
Hi, I am trying to run php and mysql locally on my home computer. I am using a simple install setup called Uniform Server 3.3 and I ran all the queries to setup my database (from my online sit...
When updating individual rows in a table with 7+ million rows I seem to be getting a high number of the below error. What might be causing this and more importantly, how do I make it stop?
...
I'm using HQL, which is Hibernate's SQL. I'm hoping it works
I have the following HQL
select distinct r from Release as r, ReleaseComponent as c
where r.deploymentDate between :fromDat...
I have installed a RHEL 5 server with php5 and mysql5. Now I need to have the mysqli extension installed. I looked for a RHEL5 RPM for mysli but there isn't any. ALso on google nothing to find...
hi guys,
i have two tables in my MySQL database and I would like to merge them. They are almost similar in structure pero mas marami lang columns ung isa. Here the create table statement fo...
I have a mysql table that I want to insert Blobs(pdf's) into from the commandline.
The pdf's are on workstation with network connection to mysql server.
D
hi experts,
in my local phpmyadmin. I can changed all the charset of the db and the charset of the connection
but it still see in the main page a charset that I cant change !
any idea how ...
What is the syntax in MySQL to view user privileges?
Hi!
I need a mysql query that will select only the rows that have duplicates in a table.
For example if there are 10 identical rows, I need to delete 9 of them so that I will end up with...
I'm trying to add a trigger to a database using phpmyadmin. However, I get the error:
Access denied; you need the SUPER privilege for this operation
How would I sort this out in phpmyadmin?
Hi All,
I have setup master-slave MySQL replication, which works great, however I would like to make sure, that slave database cannot be modified. Is there any way i could make it "read-onl...
I need to display the variable for @BeginDate, but nothing displays.
Declare @BeginDate datetime
SET @BeginDate = DATEADD(mm, -3, @BeginDate)
Print @BeginDate
is there any syntax for mysql which converts datas to uppercase..
Thanks.
I wish to create a table with composite primary key ( more then one field is the primary key ).
what is the statement in MySQL ?
thx so much
Hello,
I have a table with a column called _id.
Examples of IDs are AB001, AB002, AB003, etc
I want to run a query to verify if a certain ID exists.
If it does, then return 1 else return...
The script -www.nihaorr1.com/1.js is getting inserted into every record of my organizations SQL db. I'm the accidental techie in my office, and I'm clueless as to the vulnerability in our cod...
Is it possible to pass multiple years to the interval function? I am trying to modify code that has INTERVAL 1 YEAR and trying to change it to INTERVAL 10 YEAR.
Is my syntax wrong?
I got this error when I try run the command:
ginjas:/# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Can you help me?
BR,
Mário Machado.
Hi,
Please kindly assist how can we install mysql on fedora 3 ? the error message is being generated below..
Thanks.
[root@point ~]# rpm -ihv MySQL-server-4.1.14-0.i386.rpm
warning: ...
How do you get MySql to ignore upper and lower case when you do a "select from col where name like"
Eg: I've noticed that "where name like '%how%';" will return only "how".
It will not re...
Hello,
I would like to use Visio to "Generate..." a dB for me, and also to "Reverse Engineer..." an existing database.
Currently, I am using MySQL 4.1.12 and Microsoft Visio for En...
Hi,
I am new to MySQL and am currently using the MySQL GUI Tools, specifically the MySQL Query Browser. I am trying to create a foreign key to create a relationship between two tables. I go...
I have been looking at mysql documentation concerning access denied, but I fill like I am getting nowhere.
I have tried the following
C:\>mysql -uroot mysql
ERROR 1045: Access denied f...
I'm trying to import a .csv table into MySQL via PHPMyAdmin, but receiving the following error message immediately after I press 'go':
"You probably tried to upload too large file. Please ref...
