Hello,
I have this MySQL cluster running and I wanted to add a sql node.
So I have added the new node to the management node and added the management node to the my.cnf of the sql node.
A...
MYSQL
Hello,
How do I write a MySQL query to select entries with the 2nd most recent date in a column? Then, 3rd most recent, 4th most recent etc. (separate query for each)?
The dates...
Ive just taken over a database which has a lot of dates in, the dates are stored in VarChar fields like '01/06/2007 03:54:30', I need to convert them into a datetime field, but the only way Iv...
i have spent the past 5 hours working on this mysql issue.
I installed today apache2, php 4.3.1 (need it for work) and mysql 5.
i continue to get this error. unable to load dynamic libr...
Setting up a FEDERATED storage ENGINE to link a masted and remote table
I get the following error MySQL Database Error: Unable to connect to foreign data source: Unknown MySQL server host
...
I am using last_insert_id to try to retrieve the id of the last record added to a table, just after the insert was done. The key field is auto_increment.
However, I ALWAYS get "Resource id...
It seems like a simple question:
SELECT * FROM table1 INNER JOIN table2 ON(table1.pk = table2.fk)
I don't want any of the columns from table2 in the result?
How can I achieve this?
T...
If you're like me and work on a web solution with php/mysql, and you have a local development environment on your laptop, what is the best way to keep the structure of your database in sync wi...
Hi all,
I want to install mysql on a dual processor multi-core windows machine.
Are there any issues I should know about, or anything worth mentioning?
Trying to remove characters from query result. In following file; "68 Widewater Front 2_150x0.jpg", which is a thumbnail image.
I am trying to get the query to trim the "_150x0" chara...
Hello,
I'm trying to get this to function to work. I have this code:
SELECT SUBSTRING_INDEX('www.google.com', '.', 1)
And I want it to return 'google'
Any suggestions?
Thanks.
If a mysql database has been dumped with something like:
mysqldump -Q -u root -pblah --all-databases > alldbs.sql
Is it possible to import db 'foo' from alldbs.sql without manually copy/...
i have a number of records that are ideltical in a table in a database, is there a single command or sql statement to delete these?
hi,
I have one Solaris mysql master server which will replicate data over 2 windows mysql slave.
I created one table, just like usual, without foreig_key or anything. The query goes through...
I'd like to pull the most recent entry for every unique person in my sql table:
Person | datetime
---------------------------
Bob : 2007-07-17 15:45:00
Tom : 2007-07-17 15:46:00
Bob : 2...
i am running website , i need a script to backup my database + compress it and send the compressed file to my email...
there are many scripts around that do so ,however gmail account does n...
Hi!
Though this should go to the Hibernate section, I am posting it here 'cos I didnt find any section for hibernate!:)
The prob is:
I am trying to return distinct objects from the databas...
I want to pull the first 10 random record, but then I want them in order by customer name.
The following query pulls the random 10 records, but I can't get them in order without messing up ...
My ISP says my site is generating a lot of errors on the server. Turns out that it's due to the testing being done by HackerSafe (to which I subscribe). I've had phone joint phone calls with m...
I would like to re-initialize my WordPress mysql database. I have some broken links, post, and categories and think it would be easier to cut and paste my content into a clean database. Can ...
I have a table which has a row for each enquiry to our company, the table has a timestamp field which is automatically filled when a new row is inserted.
using the following query gets the ...
Hi experts,
I have Mandriva 2006 with Apache,PHP,MySQL and IPB.
I have forgotten my SQL login credentials, can i delete them somehow without logging in to SQL as i cannot do that.
the...
I have two tables:
1. FRIEND
2. MATCH_MY_FRIENDS
FRIEND is a simple table that captures some general attributes about my friends.
MATCH_MY_FRIENDS is a table with every possible combi...
hi i have an array of values that im trying to insert into a mysql db. my usual way to insert them into a db would be to run a foreach loop. however i have been informed that i can just pass...
This is a repeat posting as I got no response last time.
I'm importing a MySQL 3.23.55 InnoDB database of about 1.7 million records across 26 tables into 4.1.9 using the mysql command line ...
