To make a long story short, one part of the application I'm working on needs to store a somewhat large volume of data in a database, for another part of the application to pick up later on. Normally this would be < 2000 rows, but can occasionally exceed 300,000 rows. The data needs to be temporarily stored and can be deleted afterwards. ...
I have quite complicated view in mysql, like select filter.id as filter_id, person.id, person.name from person, filter inner join ... left join ... where person_match_filter_condition ... group by filter.filter_id, person.id, person.name Query filters person which corresponds domain specific conditions. Typical use of view is: sel...
Let's say I need to query the associates of a corporation. I have a table, "transactions", which contains data on every transaction made. CREATE TABLE `transactions` ( `transactionID` int(11) unsigned NOT NULL, `orderID` int(11) unsigned NOT NULL, `customerID` int(11) unsigned NOT NULL, `employeeID` int(11) unsigned NOT NULL, ...
Given 2 dates, how can i calculate the number of hours/minutes between them, excluding weekend time (since Friday 17:30 till Monday 09:00) The script queries a MySql database but i assume this sort of calculations would be easier in php. I'm thinking of a iterative function to determine the weekday and keep looping until last date would...
Whenever I try to connect to MySql using vbscript, I'm getting an error: Script: E:\VBScript\CreateAccount.vbs Line: 6 Char: 1 Error:[Microsoft][ODBC Driver Manager] Data source name too long Code: 80000405 Source Microsoft OLEDB Provider for ODBC drivers Here's the code to open the connection to Mysql: dim cn, rs set cn = CreateObj...
i have a overflow memory usage problem and i need badly to scan all my scripts . so my question is how to show a list of running mysql queries in php ...
Hi all I've created a client with login acces in Flex. After the succesful login i have to show a table based on a mySQL server. The database is composed by some tables, and I have created 6 flex mxml components with each own scripts for each of those tables. How can i load sub-applications, for example with a PopUpButton or a TabBar in ...
I have two queries: SELECT s.id AS id, g.id AS group_id, g.nazwa AS group_name, s.nazwa AS station_name, s.szerokosc AS szerokosc, s.dlugosc AS dlugosc, s.95 as p95, s.98 as p98, s.Diesel as diesel, s.DieselTIR as dieseltir, s.Super98 as s98, s.SuperDiesel as sdiesel, s.LPG as lpg, s.ulica as ulica, s.kodP...
I am developing a Java Desktop Application which uses MySQL database. The DB has 6 tables. Every table, as usual, should allow CRUD (Create, Read, Update and Delete) operations. I have designed 6*4 = 24 JPanels, 4 JPanels for each tables. Each JPanel have Components to take user input and perform the CRUD operation for which it is desig...
Table Name :: Feedback_master Fields 1. feed_id 2. roll_id 3. batch_id 4. sem_id (semester ID) 5.f_id (faculty Id) 6. sub_id (subject Id) 7. remark. 8. b_id Table Name :: subject_master Fields sub_id (subject Id) sub_name (Subject Name0 f_id ( Faculty ID) Table Name :: faculty_master Fields f_id (Faculty Id) f_name (Faculty Nam...
I'm building a highly scalable app, and I need to know which data type to use for small strings (50-1000 chars). I heard that VARCHAR is fixed sized and therefore might be faster, but with TEXT, chars might be stored in a seperate CLOB, and only a pointer in the row data. This would be smaller, but would it have any significant performa...
Hi, I have a large table with ZIP codes but they are in long format like : 06608-1405 What I require is to REMOVE the hyphen and the numbers after the hyphen. I have using MYSQL REPLACE before but not sure how if you can use Wildcards. Cheers for you time. J ...
I am new to databases. I have a classifieds website with MySQL db and I am soon about to use SOLR to index them also. Then whenever a query is done, SOLR will return ID:s and I will match those ID:s to the MySQL database and fetch the ads to display. Anyways, I have trouble making the db. Users may choose from a drop-list what category...
We need to regularly create a clone of a production server's live MySQL 4 database (only one schema) and import it on one or more development databases. Our current process is to 'mysqldump' the database, copy it via ssh and restore it on the target machine using the 'mysql' client utility. Dumping and copying is relatively fast, but re...
I have a MySQL database running on a deployment machine which also contains data. Then I have another MySQL database which has evolved in terms of STRUCTURE + DATA for some time. I need a way to merge the changes (ONLY) for both structure and data to the DB in deployment machine without disturbing the existing data. Does anyone know of a...
Hey there, Hopefully someone can point me in the right direction or knows the answer. I'm using a recreation of the sample MSDN SessionStateStore provider which is designed for MSSQL server. This one was done by Harry Kimpel. The particular issue I am having is with the "CreateUninitializedItem" routine. Basicaly the error I get often...
Here is the code that I'm working on: login.php: <?php $con = mysql_connect("localhost","root",""); mysql_select_db("koro",$con); $result= "SELECT * FROM users WHERE UNAME='".mysql_real_escape_string($_POST['Uneym'])."'"; echo $result; ...
I'm porting a class from plain JDBC to use Spring. Part of this class consists of a block that find the most recent row, updates a field, and selects it into an object to be processed later. This block should only be executed by one thread on one machine at a time to make sure no two threads process the same row. We've been handling mu...
Hi, I want to retrieve column values(login,password) from my mysql database table to vbscript. How can I do that? I've no experience of vbscript, and I've to do that as a part of myproject. I'm sucessful in connecting to Mysql database table, but I don't know how to retrieve those column values(both are in varchar) in vbscript. I search...
In What table in Drupal is the current version of core (Drupal) stored? I'm looking for a string like 6.2.3. I don't see it in the system table. ...