The code below when , SUM(`sellnote`.Paid) then
`sellhead`.RcvAmt + SUM(`sellnote`.Paid) As total become null
How can I change the code SUM(`sellnote`.Paid) if it is null it choose be come...
Hello,
I have created a Streets table: with int idStreet ; int idRegion ; String street name as columns.
I have a jsp page with 2 comboboxes that I would like filled with all the streets...
I'm using this code to select people (EXEC) from a database which works fine. But I get php warnings in error_log:
PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL ...
Hi,
I am new to MySQL and Linux (BASH). I am attempting to run a SQL query from BASH. I often do similar things using Oracle and KShell, but am new to the MySQL/Linux/BASH environment.
...
I need to know if it is possible to OUTER JOIN multiple tables at the same time.
this would be like OUTER JOINing 2 queries together
this code works (but is a pain to update and takes foreve...
I have some Data in a MySQL table that needs to have the letter casing changed. I imported some product data into a shopping cart but the original data was messy and the product titles were a...
Hi,
Thanks for your help.
I am currently on an XP box with the following software specs:
Apache/2.2.9 (Win32) PHP/5.2.6 and mySQL 5.0.51a/phpMyAdmin 2.11.7.1
I've uninstalled Apache/PH...
Hi I keep getting this message when I try to test mysql with the script below:
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
And I don't know why.
I've only ...
Hello:
I am working on a login script. (Was working before). User enters login information which then signs them in. However my page "Loged In" returns the following error message four time...
Hello, I am very new to PHP and MySQL. I need to insert a date into a MySQL datafield of type date.
I would liek to be able to have the user input their date of birth in a form and insert ...
Hi guys Im hoping you can help me understand what the MUL key actually means for a field in a MySQL table.
Field Type Key
-------------------------...
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 ...
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
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?
In MySql, dadiff only exist in version 4.1.1.
But my host don't have this version.
There is a mysql alternative ?
I need to get number of day's between date field and today.
I also ne...
is there any syntax for mysql which converts datas to uppercase..
Thanks.
I'm working on some statistical queries that I need to run against a single table with about 3 million records. I'm having some issues optimizing one query in particular, and while running EX...
my application does:
delete table1; insert data from tmp_table1 to table1;
delete table2; insert data from tmp_table2 to table2;
delete table3; insert data from tmp_table3 to table3;
del...
Can you create a user and grant privileges using CREATE USER and GRANT in a stored procedure using variables from a web page? I have code in my stored procedure to insert into the USER and DB ...
Hi
I got loads of mysql-bin.0000xx files in /usr/local/mysql/var is it safe to delete those files ?
Thanks
Hi,
I have a table with the structure shown below. I am trying to extract all records where there is an image and also just one from each sub-category (subcat).
I have tried the following qu...
I have a very simple database. Only two tables. The data is currently in .csv format and it looks as though it is only seperated by commas.
My web host (GoDaddy) offers a simple Windows s...
Hello Experts,
when I open
http://192.168.0.2/phppgadmin/
I got this message
"Wrong permissions on configuration file, should not be world writable!" on my FF 2
I do not know what I had ...
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?
...
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...
