I have attached a large MY SQL database to MS ACCESS for reporting purposes. Is there a tool that can provide and presetn me with the table relationship structure for the MY SQL database (re...
I need to allow an end-user to search for a product-related phrase across two fields.
ProductName
ProductDescription
is there any "loose" way of matching words within the searchphrase to ...
Hi,
please give me the equivalent in mysql for the following grant permission in mssql.
GRANT SELECT,INSERT,UPDATE,DELETE ON table _name TO PUBLIC.
Here what is the meaning of public??
Re...
Hi,
i am trying to get table name by using "show tables " statement but it is giving me views also.
i want only table names.
please let me know any thing is available for getting only tabl...
i have a project in which i have to made a query for getting data from the fuzzy databases based on some priroty .
suppose , i want to get the result based on the required priority from a fu...
This is basically the solution I needed to generate a random password for the user so they can later log in and change it:
http://www.experts-exchange.com/Database/MySQL/Q_21803421.html
...
I have a table called employee in production database; I have another table called employee in Freelancer database. I need to update my employee database in production if any new freelancer ad...
I have tables N and M
tblN
ID
tblM
ID
N_ID
I want to return Rows that two values per row: ID and a boolean B depending on if
tblN.ID value exists in tblM.N_ID
thus the ret...
I am looking for a windows based solution to automatically backup MYSQL database. After searching this site this software (SQLyog) was mentioned. Has anyone used this ? what are your thoughts ...
Hi,
i am trying to insert data into a table but i am getting this error.
Field 'BIOMETRIC_FLAG' doesn't have a default value
INSERT INTO mytab (CLIENT_ID,DAD_ID,LOCATION,DESCRIPTION) VALUES...
I have a whole table of products. Right now, the products don't have anything in their "category" column. I want to update this column through a query. My categories are these:
Boards
Chai...
Why do I get this error message: Invalid Use of Group Function ???
SELECT Date_Format(colDateTime,'%m/%d/%Y %r'), col1, col2, col3, col4, col5, col6
FROM
(
Select colDateTime, col1, col...
I inserted a row into a table by logging into the system and it is replciated to slave.
But when I use my web site/php scripts to add a row in the same table....it is NOT replicated?
Pl...
I would like to output the latest 10 pictures that have been uploaded by userID 44, the output should be descending essentially displaying the biggest gpictureId first and so on, the result sh...
Hi guys,
I have a table with car listings; some of the listings are premium, some are semi premium and some are free listings. In a search result, I need to show up to 3 premiums per resul...
The two databases are both in php/MySQL . However, they do not have the same database structures.
The old db have 25 tables and the new db have 66 tables.
The db have categories, members, le...
I have this wierd problem where i have a master master setup for mysql 5 and as soon as the setup is completed the replication takes place fine between each other untill i create a new schema ...
I want to develop a multi user word game on facebook. The potential of having 200k active users per day is very real. The app is like the facebook app Scrabulous. (a game of scrabble) Every ...
Hello Everyone
I had a video content site coded for me. The database is mySQL and I have a PhpMyAdmin web interface. I would like to know how to reset some of the video views in the databas...
Hi,
Please continue the thread here...
Thanks,
akiles
This is a large membership site, each member is a Post, with Custom Fields for "Business", "Proprietor", "Address", etc.
I need a web-form that a new member can fill out online that will ad...
I have an installation of Mantis installed on a Window 2003 SP2 Server. Mantis is running and users are able to log entries via its web based interface. I now need to create some custom querie...
I'm a little bit of a PHP mySQL newbie, so this may be a really obvious question.
Anyway,
I get this error:
mysql_connect() expects at most 5 parameters, 10 given
Okay, I understand,...
Hi,
I have a program that someone at my work created, which USED to work.. that was until we needed to remake the MySQL Virtual Server that it was running on. Now, it's not finding the ser...
Hi,
Im creating an application using MySQL and PHP... Ive downloaded dbtools to edit the database and so far it seems to do all i want (other software you can recommend for MySQL GUI that i...
