Asked in PHP interview, Is it possible to insert Object in database?
Asked in PHP interview, Is it possible to insert Object in database? ...
mysql
how many field we keep in table
How many field is possible in one table, Shall i maintain 150 field in one table is good way , OR Maintain relation ship with other tables, Thanks Bharanikumar ...
MySQL skip first 10 results
Is there a way in MySQL to have the first 10 result from a SELECT query skipped? I'd like it to work something like LIMIT. ...
Find the nearest campground by postal code
I have a database of Postal Codes in Canada and the scripting to do my searches. But for some reason I am not get the nearest campground based on a Postal Code search. I am doing something wrong with my SQL Query as when I am selecting the campgrounds it displays a business within range by not the nearest. When I run the SQL Query to ge...
SQL: joining multiples tables into one.
I have 4 tables. r1, r2, r3 and r4. The table columns are the following: rId | rName I want to have, in fine, an unique table - let's call it R. Obviously, R will have the following structure: rTableName | rId | rName I'm looking for a solution, and the more natural for me is to: add a single column to all rX insert this column...
Testing database connection Using Javascript in outbound database connector in Mirth
I have database handle in channelMap (for 1 connection for all messages) and I reuse the connection for all messages. Now, before performing inserts (to a MySQL database), I want to test if the connection still exists. How do I perform this test? ...
Why are transactions not rolling back when using SpringJUnit4ClassRunner/MySQL/Spring/Hibernate
I am doing unit testing and I expect that all data committed to the MySQL database will be rolled back... but this isn't the case. The data is being committed, even though my log was showing that the rollback was happening. I've been wrestling with this for a couple days so my setup has changed quite a bit, here's my current setup. Lo...
Problem using Min(field)
The problem was between the keyboard and the seat folks. Thanks for lending your knowledge! have these two queries: SELECT classroomid AS crid, startdate AS msd FROM unitTemplates where classroomid = 6 GROUP BY classroomid and: SELECT classroomid AS crid, Min(startdate) AS msd FROM unitTemplates where classroomid = 6 GROUP BY cla...
Turn RSS into array, explode the 'description' and insert words into MySQL table one per row
I have only recently gotten into php and MySQL and I want to take an RSS feed, turn it into an array, take only the description part of the XML, explode it and insert it into a table on a MySQL base. I feel like this should be possible, but is a little over my head right now. I tried using magpie as a parser, but if possible I want to ...
Commercial web application--scalable database design
I'm designing a set of web apps to track scientific laboratory data. Each laboratory has several members, each of whom will access both their own data and that of their laboratory as a whole. Many typical queries will thus be expected to return records of multiple members (e.g. my mouse, joe's mouse and sally's mouse). I think I have th...
MySQL - how to retrieve columns in same row as the values returned by min/mx
I couldn't frame the question's title properly. Suppose a table of weekly movie earnings as below: MovieName <Varchar(450)> MovieGross <Decimal(18)> WeekofYear <Integer> Year <Integer> So how do I get the names of top grossers for each week of this year, if I do: select MovieName , Max(MovieGross) , WeekofYear from earni...
adodb: what does createparameter do?
in plain english can you please explain to me what does this line mean: Cmd.Parameters.Append _ Cmd.CreateParameter("datapath", adChar, adParamInput, 100) i then have a line that writes data to the datapath column: Cmd.Parameters("datapath").Value = "abc" but i do not understand the purpose of the first line? what is adChar and...
how do I display list of URLS say maximum 50 per web page from MySQL database??
I do have thousands of urls in my database. what I want to do is display all urls in multiple pages say number of URLS per page is 100 and alphabetically then when ever a user search for a URL info it should get updated on relevant page. for example if it is google.com then it should get updated on "G" page and no duplicate entry. how ca...
MySql - set of time stamped data (timestamp,event) calculating events per day
I have a table: id, datetime, event i also have table dates: date (Y-m-d format) the problem is some days don't have any events, I would like them to show 0 (or null) SELECT DATE_FORMAT(table.timestamp, '%Y-%m-%d') ydm, count(table.fkUID) FROM `table` where table.fkUID=$var group by ydm; is there some way to join or use conditional...
Creating a MySQL trigger to verify data on another table
I am trying to set up a MySQL trigger that does the following: When someone inserts data into databaseA.bills, it verifies if databaseB.bills already has that row, if it doesn't, then it does an additional insert into databaseB.bills. Here is what I have: CREATE TRIGGER ins_bills AFTER INSERT ON databaseA.bills FOR EACH ROW BEGIN ...
Problem with MySQL query
This time my setup looks like this: one table with galleries names CREATE TABLE GalleriesName ( gallery_id , gallery_name ) and another table with galleries photos CREATE TABLE GalleriesPhotos ( photo_id , photo_gallery_id , photo_name ) What I need is to get all the galleries with one random picture for eac...
fIltering email addresses in a mysqldump file
I would like to scramble all email addresses in a mysqldump file and make all the scrambled email addresses unique. Any recommendations? ...
Need help managing MySql connections
I'm having trouble finding a clear explanation of connection pooling. I'm building an app using the .NET connector I downloaded from mysql.com. The app only needs one db connection but will be running simultaneously on about 6 machines on my network. Normally, I'd create the connection at startup and just leave it. But I'm seeing lot...
Creating tables and inserting data (MySQL Dump) using PHP Doctrine 1.2
Hello. I got a script that create a new database, now I need to fill that database with tables and values (from a MySQL dump file). I'm using PHP - Doctrine 1.2. Here is how I create the database: $manager = Doctrine_Manager::getInstance(); $newConn = $manager->openConnection($customer->Config->db_connection_string); $newConn->c...
Connecting Excel to Mysql Update PROBLEM
i am connecting to a mysql table through vba in excel and i am updating it: Set cn = New ADODB.Connection cn.Open "DRIVER={MySQL ODBC 5.1 Driver};" & _ "SERVER=localhost;" & _ "DATABASE=employees;" & _ "USER=root;" & _ "PASSWORD=M1llen;" & _ "Option=3" 'lets get the batch info ' ' open a recordset Set rs = New ADODB....