I’m sure my terminology is wrong, which is probably the reason google isn’t helping me. Anyways here is my problem and maybe you can deduce what my real question is...I hope Ok let’s say I have a table called MOVIE this table has the values (columns?) for Name, ReleaseDate and Staring now my issue is how do i have the Staring value cont...
I'm using phpmyadmin/wampserver. Is it possible to add a password on a database?Because my problem is I cannot access the whole thing(http://localhost/phpmyadmin) in my web browser if I put a password on it. ...
Hello I have my data in the mysql database but i want to update my database tables without affecting the old data. and i need the functionality that i can fetch the old data as well as new updated data as and when required in the software according to the date ...
I have a .sql file and I want to load it into MySQL database. I don't know from which database (MySQL or MS-SQL) it was created. Now, I am trying to import that file into MySQL database. It is showing errors while importing and executing that file. Q1. So, my question is whether the .sql file generated from MySQL and MS-SQL are diff...
i would like to update for every action(insert,update,delete) happens in localhost mysql to remote mysql server. how to i do that? . ...
hey guys i'm about to begin a football manager inspired facebook application in php/mysql and had a couple of questions: 1) where would be the best place to host the database? any services offered within great britain would be excellent! 2) does anyone have any ideas on how i could use player statistics as part of the in-game match eng...
We have developed one web-based application. We are running it on our intranet for 1 year. Now we are in process of writing events. We are calling stored procedure from events. The problem is: Mysql doesn't throw any error when event is called but doesn't execute stored procedure which is called from an event. Application details a...
Hi, Is there any way i can convert a table struture in a MySQL or Oracle database to XSD (XML Schema Definition) format ?. Thank You. ...
I am just learning normalization, so please forgive me if this is a dumb question. I have a table TBL_Users with the Primary Key being ID. To track who is friends with who my most recent thought was to do a table with two Foreign Keys, both of which are the other person's ID. However the more I think about this I can't help but think th...
In MySQL I create a database name like de mo, and it contains a table like tablename. When I try to execute a query, for example: select * from de mo.tablename I am not able to execute that query. How can I? ...
Hi, I'm desperately trying to create a relatively concise search engine with PHP, mySQL and PDO. I have a database of books, and I'm trying query a search against two of the fields. Here is what I have so far: "SELECT id, title, author, isbn, MATCH(title, isbn) AGAINST (:term) AS score FROM %sbooks WHERE MATCH(title, isbn) AGAINST (:te...
Hello Masters! I have an user registration procdedure, with this steps: If user send the registraion form then: 1. step: run a QUERY 2. step: run another QUERY 3. make a directory1 on the server 4. make a sub directory2 into the directory1 5. make another sub directory3 into the directory1 6. upload an image into the sub directo...
I'm defining a simple stored function which works fine in my local testing database, but when I try to create it on the "real" server, it just doesn't get added to the 'proc'-table. I'm getting no errors or anything, it just doesn't get added (hence, the function can't be used of course). Both servers are using the same version, and I c...
Hi Friends, I'm using -msqldump to backup the database in remote machine. If firewall is enabled i cannot login to the other hosts.Is there any solution for this problem. I have posted the below coding in a web server and trying to backup from another domain. String dumpCommand = "D:/MySQL/MySQL Server 5.0/bin/mysqldump -h"+scheduleIn...
how to load the mysql server in android emulator i.e Class.forName("com.mysql.jdbc.Driver") i got the exception java.land.ClassNotFoundException in com.mysql.jdbc.Drive please reply me. ...
Assume we have a popular site. We need to implement mail-like messaging between users. Typical solution is to use 2 tables: Users (user_id) Messages (message_id, sender_id (references user_id), receiver_id (references user_id), subject, body ). This method has 2 significant limitations All messages of all users are stored in one tab...
I'm using the following as part of an ActiveRecord find method: :conditions => "created_at > date_sub(now(), INTERVAL 7 DAY)" This works properly on my development server where I'm using MySQL, but I'm deploying to postgreSQL which doesn't have a date_sub function. Ignoring the fact that I'm using two different databases, does Rails h...
Hey guys, Im working on an application that needs to talk to a database. The application is written in C#. Im quite taken by LINQ and auto generating classes to represent the database and its tables, so first I considered using SQL as .NET only comes with support for LINQ to SQL. Right now Im leaning more to MySQL mainly because scaling...
Is there a way to remove all repeat rows from a MySQL database? ...
I have two columns in different product tables. tblproduct1.partno is an old product list tblproduct2.partno2 is a new one Both partno columns should have identical model numbers but they don't. When executing the below query, I get about 300 model numbers that don't match when comparing counts from both tables. tblproduct2 has 1955...