I'm trying to create a database that stores the students grade for each homework assignment I want to be able to store the grade and how many times that student got a certin grade for example a student got an A+ 30 times, for each student, as well as how many grades a student got. And how much a grade is worth in points for example an A ...
Some of my unit tests take 10-15 seconds just for mysql to create the tables. This seems unnecessarily long. It has to create around 50 tables, but that's still only 3 tables per second. This is a big annoyance when running unit tests over-and-over. As a workaround, I have been running my unit tests in sqlite3. It is blazing fast, but ...
I am good with ideas, but due to my limited programming experience I sometimes strain to come up with the most effective solution for a given concept. Currently my mind is trying to fathom the most efficient way to reference a database table specific to a data type. Concept I am building an admin interface that allows a site owner to '...
Hi, I have a problem connecting to MS Access and MySQL using Java. My problem is that I cannot find the driver for MySQL. Here is my code: <%@ page import="java.sql.*" %> <% Connection odbcconn = null; Connection jdbcconn = null; PreparedStatement readsms = null; PreparedStatement updsms = null; ResultSet rsread = nul...
I'll be writing a script to parse text documents into a MySQL database. I'll be converting PDF's to text with a separate utility. These PDF's will be submitted via e-mail attachments. I'm looking to see if I can do this with PHP since that's the server language I'm most familiar with. Second choice would be Perl, but I'll take your r...
Hi, I'm using GoDaddy's Shared Linux hosting and some PHP I wrote just won't work with my DB on the server. EDIT: I fixed the problem. I accidentally deleted the "database" connection variable from a config file. Wow. That was silly of me. EDIT: By not work, I mean that I can't read the DB. I've messed around enough to know that the...
I'm working on a website with typical CRUD web usage pattern: similar to blogs or forums where users create/update contents and other users read the content. Seems like it's OK to set the database's isolation level to "Read Uncommitted" (dirty reads) in this case. My understanding of the general drawback of "Read Uncommitted" is that a ...
Is there such a thing that will allow you to create a mysql query and view its results live? Almost like an ajax sort of live search results kind of thing, so each character i type in will affect my result? ...
Does a Joomla site write anything (session etc.) to the Db upon browsing (no logins just plain browsing)? I would like to make my DB read-only for maintenance purposes. ...
I'm not sure, if it fits exactly stackoverflow, however as i'm seeking for some code rather than a tool, i think it does. I'm looking for a way of how to replicate / synchronize different database systems -- in this case: mysql and mongodb. We are running both for different purpose. We started with a mysql database and added mongodb lat...
i have a php file which regularly writes and reads tables from mysql DB. i have another ruby file that runs at the same time which reads and write to the same tables in mysql DB. can there be potential issues with this set up ? ...
Problem starting service jboss.j2ee:ear=registration-ear.ear,jar=jboss-seam.jar,name=TimerServiceDispatcher,service=EJB3 java.lang.NullPointerException at org.jboss.ejb.txtimer.DatabasePersistencePolicy.listTimerHandles(DatabasePersistencePolicy.java:165) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun....
Hi, Is there a standard or recommended method of exporting the data from an Oracle DB into a SQL Server or mySQL database? Was thinking exporting the Oracle data into XML then importing the XML into SQL Server...or this recommmened? Thanks, ...
I am doing easy web based chat so I need to get (for example) 30 latest messages from a MySQL database. That doesn't make any problem but how can I take the data in up side down order? I mean, the oldest message is the first. I have to take latest 30 records by added time. EDIT: Thanks for the answers, but... ORDER BY added DESC LIM...
I have one table in MYSQL It has data like Id Name 1 test 1 test 1 test123 2 test222 3 test333 I want the data like Id Name RowNum 1 test 1 1 test 2 1 test123 1 2 test222 1 3 test333 1 Means i want assign row number on group of Id and Name ? what should the script for same? ...
I have database where one column contains numbers. 3 example values: 1111111555 2222222555 3333333555 which I need to reverse and put a dot between each digit. i.e. the result for each of the examples above would be: 5.5.5.1.1.1.1.1.1.1 5.5.5.2.2.2.2.2.2.2 5.5.5.3.3.3.3.3.3.3 respectively. I then need to update another column wi...
The Sphinx config file hints to it supporting multiple sources for one index, how do I actually specify it? Here's the snippet from the config file: # document source(s) to index # multi-value, mandatory # document IDs must be globally unique across all sources source = src1 I've tried setting it in the following for...
I am having problems with this and I'm hoping it's possible. I have a table from wordpress which stores post meta data, so the columns and field data cannot be changed (Easily). The table structure is thus post_id meta_key meta_value the meta key stores a field name and the meta_value, the value for that field. I need to group thes...
My application needs to use geodata for displaying location names. I'm very familiar with large-scale complex geodata generally (e.g. Geonames.org) but not so much with the possible MySQL implementation. I have a custom dataset of four layers, including lat/lon data for each: - Continents (approx 10) - Countries (approx 200) - Regions/S...
I want to update data table for those who score exam id 1,2 more than 80. I try this UPDATE data SET column = 'value' WHERE (SELECT * FROM exams WHERE (id = '1' AND score >= 80) AND (id = '2' AND score >= 80)); It gives me 0 result. But it should have few hundreds results ANy help?? I think the problem is this: SELECT * FROM exams ...