Hi All,
I need to insert Blob data in my table using prepared statements. But Whenever I
try to insert it using prepared statement it is giving me mysql syntax error.
Here's the prepared statement :-
SET @stmt = Concat(Insert into ',mydb,'.MyTable(MyData, MyID)
Select
','"',Inputdata,'"
On Sun, Jul 25, 2010 at 12:55 PM, Geoff Galitz wrote:
>
> Hello.
>
> I need to migrate a master and slave to new hardware. The DB is approx 50G
> on disk and my time window for downtime is approximately 4 hours.
>
> My question is, is it advisable to do a mysqldump from the old master and
> the
On 07/25/2010 09:29 PM, Mark Phillips wrote:
I have been away from sql for awhile, and can't seem to figure out how to
write a simple query for two tables.
Table 1 has many columns, two of which are hID and vID. Table 2 has two
columns, ID and name. The hID and vID in table 1 correspond to the I
Hi Mark,
Please test this query:
select test1.*, (select name from test2 where test2.id=test1.`v_id` limit 1) as
name_1,
(select name from test2 where test2.id=test1.`h_id` limit 1) as name_2
from test1;
- test1 table:
col1v_idh_id
America 1 2
- test2 table:
id name
2
I have been away from sql for awhile, and can't seem to figure out how to
write a simple query for two tables.
Table 1 has many columns, two of which are hID and vID. Table 2 has two
columns, ID and name. The hID and vID in table 1 correspond to the IDs in
table 2. I want to make a query so I get
Hello.
I need to migrate a master and slave to new hardware. The DB is approx 50G on
disk and my time window for downtime is approximately 4 hours.
My question is, is it advisable to do a mysqldump from the old master and then
load on the new master and slave, or is it faster to just set th
