I'm taking a Software Design course at Penn State and my group is tasked with solving the Nurse Scheduling Problem. I would like to have it store previous schedules as well as the current schedule in a MySQL database, but I'm not sure what the best way to do this is. For the current schedule, I was thinking of a table with the date, the...
All, is there any means by which it is possible to connect to two seperate mySQL databases and execute SQL statements to interact with both? The aim would be to query DB 1 on connection 1 and insert the results into DB 2 on connection 2. Is it possible to do this using the mySQL query browser? Many thanks, all help appreciated ...
I want to know if it is possible to use MySQL Engine without having to install WAMP Server. I'm developing an application that will require a database, so I was thinking of using MySQL instead of MS SQL or access. So I don't want to install the WAMP package yet I want to install the MySQL Engine, so if possible, please provide me with th...
I'm dealing with a legacy database table that has no insertion date column or unique id column, however the natural order of insertion is still valid when examined with a simple SELECT * showing oldest to newest. I'd like like to fetch that data with pagination but reverse the order as if it was ORDER BY date DESC I've thought about wr...
I am currently working on a project in C# and use MySql as database. I am currently having a problem with creating a custom DataTable I want to show in my Report. Extra Info : A test can have any no combinations of Cells & Valves for a test But for one test it uses set range of Vales and Cells are predefined before each test. Results T...
message table id user_id| message 1 1 | this is my cruel message 2 1 | this is my happy message 3 2 | this is happy messgae message_tags table id message_id| tags 1 2 | happy 2 3 | happy what i want to acess all the messages that have the the tag happy, how would construct...
I'm having trouble thinking this one out. Input is greatly appreciated. Content is always changing, but here is an example of what I'm trying to do. STORY 1 (keywords: 5, 9, 17, 18, 25, 22) STORY 2 (keywords: 5, 25, 16, 19, 32) STORY 3 (keywords: 1, 9, 17) STORY 4 (keywords: 25, 22, 16, 3, 17) Now, I'm querying bas...
I started coding recently, and this community has helped me a lot understanding many things which I was not aware of. However, many reputed coders instructed me of some patterns, the way I have to code and the way I shouldn't write codes. Although I accepted their suggestion with gratitude, there was many thing I couldn't understand. I...
I build a webisite with wordpress and i want to show my website to other client computers I run xampp server at server computer How can i do for that? plz answer quickly..** ...
We have a web application (it is a game) with lots of various forms and elements which act as buttons and trigger some actions on server. The problem is that users can sometimes confuse our application if he clicks on buttons too fast or opens the website in two tabs and then issues some actions simultaneously. We have some basic protect...
Hi, this is again, following on from this question I posted yesterday - my other question from yesterday Webbiedave helped me enormously with his answer on the question I posted yesterday and it now all works great, but I've decided to complicate matters by adding an 'Image Title' box that enables the back-end user to add a 'title' to ...
Hi to all, i get a really strange, pointless and totally random error when i fetch rows from a resource (query) using PHP. My development machine is a Windows XP SP3 with Apache 2.2 while MySQL runs on a virtual machine, using ubuntu 10.04, with 768mb of ram, 100gb of hdd and 4 logic cores (intel q6600). However this problem is not rel...
Let's assume i have three table - list,a and b table list |a_id|--|b_id|--'name' |4 |--|3 |--|foo| |1 |--|2 |--|foo| table a |id|--|name|--|order| |1 |--|a_1 |--|1 | |2 |--|a_2 |--|2 | ..................... |n |--|a_n |--|n | table b |id|--|name|--|order| |1 |--|b_1 |--|1 | |2 |--|b_2 |--|2 | ......................
Similar question here but this is slightly different... I have two tables that I want to join: location --------------------------- | id | city | state_id | --------------------------- | 1 | Denver | 6 | | 2 | Phoenix | 2 | | 3 | Seattle | NULL | --------------------------- state ------------------- | id | nam...
Hello all. here is how my tables are currently setup: Dataset | - Dataset_Id - Int | - Timestamp - Timestamp Flowrate | -Flowrate_id - int | -Dataset_id - ALL NULL (INT) | -TimeStamp - TimeStamp | -FlowRate - FLoat I want to update the flowrate dataset_id column so that its ids corespond to the dataset dataset_ids. The D...
Hello everyone, I have a complex SQL query with nested 'subqueries' that I want to optimize SELECT 'likes' `type`, entry_date item_date, CASE `type` WHEN 'entry_id' THEN entry_id WHEN 'member_id' THEN f.member_id WHEN 'topic_id' THEN entry_id END AS item_id, CASE `type` WHEN 'entry_id' THEN (SELECT title FROM ex...
What is the equivalenf of a Java long in the context of Mysql variables? ...
I have a string[] of the list of tags to use with my SQL statement. The code is pretty obnoxious to write. Maybe i'll paste when i have it finished and working but essentially i need to show all items with a list of tags applied. All of the tags must exist. So i have code like tN.name = a[n] AND tN2.name = a[n+1] ... Is there a way i c...
Is there a way using MySQL, to query a value containing a space, but as some sort of escape character? It's for an instant search engine I'm building (I'm trying to incorporate special search strings such as quotes to search for exact string). cheers ...
I need to update (replace) fields in a MySQL database, but only if they have changed. The table contains an ID, text field and date changed. Users query the data by ID based on the date it was changed. i.e. If the date is before the last the time user queried the data, he doesn't want it. I would like to change the date in the data...