Try this :

work around would be to

Create a column CaptureDate of type varchar or char
once import is done u can update the data and get it in date time format

Save the image in the database as type BLOB
and Load the image file and read the file into a variable using file_get_contents() or similar

but best way is not to save image directly in Database...

Check what is causing the locking...
Post your Show Global Status

Try this way
put this line in my.cnf file and bin logging will be enabled

log-bin=/home/Bin_Log


This command is not to start Mysql but to connect to Mysql

if you Mysql installed as...

Try this


SELECT
budget.budget_name,
total.fundlink.fundlink_amt
FROM
budget
Left Join
(

How are u trying to connect ?

Take a note all binary collation are case sensitive

Try this for Database Size or Table Size :

SELECT TABLE_NAME,ROUND((DATA_LENGTH/1024)/1024) AS DATA_SIZE,ROUND((INDEX_LENGTH/1024)/1024) AS INDEX_SIZE,ROUND(((DATA_LENGTH/1024)/1024) +...

You can do it by a sp or from Mysql Administrator
I generally do it from Sp

DELIMITER $$

DROP PROCEDURE IF EXISTS `reports`.`SP_Mysql_Maintance_Plan_Optimize_Tables`$$

CREATE PROCEDURE...

What does the error message say?

It depends on your error message
if its says access denied then it the problem with mysql /username/password
but if its saying can't reach mysql server its the...

Create ID column in second table
and run a update query on second table with joining both the tables,so all values in ID column will be update in second table properly
come back and drop column in...

Use Left outer Join

SELECT bookings.*,times.slotId FROM bookings
left outer join time
on bookings.slotId=time.slotId
WHERE bookings.date='$date' AND bookings.stylist='$stylist'
ORDER BY...

Try this

SELECT consultants.name
, consultants.surname
, consultants.cell_number
, consultants.id_number
,points.id_number
FROM consultants
LEFT OUTER JOIN points
on points.id_number...

simple way is to comment the first query
Use -- and a space to comment

1.
mysql> EXPLAIN SELECT avg(participation_score)*2 FROM yk_participation_score,yk_contributor WHERE yk_participation_score.user_id = yk_contributor.user_id

mysql> EXPLAIN select...

Rather than Joining all 3 into 1 and complicating things u can add some index to tables and optimize select queries to executing will be faster

INSERT INTO `yk_contributor_aging` ( contributor_id,...

If there are small number of rows in a table u can go with Like '%a%'
else you need to try full text index

See if you force mysql to use index

EXPLAIN SELECT
tb1.Name
FROM
tb1, tb2 force index(t1.name)
WHERE
tb1.Name = tb2.Name;

and also check it name column is of...

If u can have down time for the current database then try detach and attach

it will be easy and fast

Try This....

SELECT is missing "T"
query will give correct results

I didn't understand the post completely
but from what i got :

Access denied for user 'ODBC'@'localhost' (using password: NO).

As the Error Say
You are trying to access Mysql with out...

Post table structure

Say we have a table with 1000 rows
and there is no column which can identify a row(i mean no Identity or unique column)

now if we want to select a set of rows from this table how can we do that?...

Try Msql Migration Toolkit,its a free download on mysql site

its the easier way

Plz post table structure

if you have any matching fields in both the tables say Org_ID
you can use a join to get the data if the format you specified

how about

select product_id from orders where order_id=?

This will give you all product_ids for a order

I guess you cant do that

DB should know how to join 2 tables or else it will join with all rows in both the tables

INSERT INTO TempTime1 (NOM,Tday,Ttime,Ttindex) SELECT * FROM time1 WHERE days AND times NOT IN (SELECT * FROM timetable1_1)

Few things to note here

you are inserting values into 4 columns of...

select
leave_Type,
emp_Leave_From,
emp_Leave_To,
emp_Leave_Days
from leave_details
inner join leave_eli
on leave_details.leave_Type_Id=leave_eli.leave_Type_Id
inner join leave_cri
...

leave_cri:typs of leave allowd 4 an emp
leave_eli:all typ of leaves
leave_detail:details of leave taken by an emp

Does leave_cri has any emp id or some column to identify specific leaves are...

select leave_Type,emp_Leave_From,emp_Leave_To,emp_Leave_Days from leave_details inner join leave_eli on leave_details.leave_Type_Id=leave_eli.leave_Type_Id
inner join leave_cri on...

Try this

update table1 set address=left(address,(locate(',',address) -1))

Than Configuration step just adds path to mysql\Bin folder in environmental variables

example : %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;D:\Program_Files\MySQL\MySQL Server...

Or you can simply drive to your mysql installation folder and to bin folder

and try

mysql -u root -p

Or you can use password('$password')

you can use this while inserting in database and then to compare the text entered by user

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

Error Say Password is not provided
"using password: NO"

check your connection string

This is how i goes

Select
Student.stud_id,
Student.stud_name,
Max(subject.marks)
from Student, subject, stud_sub
where sum(marks)<
( Select Max(sum(marks)) from student, subject,...

Just My taught

@out variable means you are creating a temporary variable
Temporary variables are connection specific

make sure these both are executed on one connection

$query = "CALL...