hi , i am working on a event kind website. What i am trying to do is, i show a form for broadasters to create their events for the particular date and then store them in the database. when the event date is current date then users will be coming to the site will click on that event link to watch the show. when they click on that link i ...
Microsoft provided us a way to create our own profiler by using Microsft.* namespaces. I can trace all queries going to any MS SQL instance. I need to do this on MySQL as well. Is there any api available for .net or java to do this? If anyone can provide also a working code is very much appreciated thanks alot. ...
Hi, I'm trying to store a database of GPS locations and run queries which find the points within a given radius and also the closest points. I'm using mysql and have been looking at the spatial extensions. I am not sure if i see how to actually use the spatial extensions to do what I'm looking for in the location radius queries. So h...
I have a MySQL InnoDB database. I have a 'phone_number' field. My data is dirtly in the sense that sometimes my data is: (111) 222-3333 111-222-3333 111.222.3333 (111) 222 3333 How can I strip all spaces and parenthesis from my 'phone_number' field to only store my phone_number in the following format '1112223333'? What would the S...
When your creating a database schema and come up with all the foreign keys. What are the advantages of explicitly defining them as such in the database? Are there advantages? If it's reliant MySQL is the db I will be using. ...
I use MySQL extensively, but it doesn't support database-level encryption without some external library. What databases come with db-level support built-in, and if you know MySQL enough to compare, how close is its syntax to MySQL. I'd obviously prefer not to re-learn everything. I also use PDO extensively to handle sql injections, s...
In my MySQL InnoDB database, I have dirty zip code data that I want to clean up. The clean zip code data is when I have all 5 digits for a zip code (e.g. "90210"). But for some reason, I noticed in my database that for zipcodes that start with a "0", the 0 has been dropped. So "Holtsville, New York" with zipcode "00544" is stored in m...
Possible Duplicate: Truncate all tables in a MySQL database in one command? how to delete all the data from all tables in the database. ...
I'm considering using mysql's built-in aes_encrypt. I normally use blowfish, but mysql doesn't seem to support it natively. How do the 2 compare together? Is one stronger than the other? ...
Hello ! please is ignoring the valuse AUTO_INCREMENT in my table sql have a effect to my current content ? thanks !!! ...
I want to store domain names(example:google.com - without "http://" and "www")in MySQL as primary key+Index. so when I call a domain through PHP I should get the result according to that domain faster. Right now I am inserting domain in plain text. is it right way to do it?? or do I need to hash it?? your Ideas please ...
what does "delete from table where NULL = NULL" means ? ...
how to retrieve yesteraday inserted records in a table?Note there is no timestamp column in a table ...
I've got a user table and a complaint table. The complaint table has the following structure: [opened_by] [complaint_text] [closed_by] (user_id) (text) (user_id) (user_id) (text) (user_id) (user_id) (text) (user_id) All users, both the complainers and complaint-resolvers are loca...
I have the following bunch of code trying to update a field using 2 cursors the one inside the other. I use the first cursor just to get an id value (1st cursor) and then I get a list of other id values based on that id (2nd cursor). The problem is that the result set from the 2nd cursor contains the last id twice! I can't find the bug! ...
Does Apache with MySql will use less system resources (RAM, CPU utilization) if we develop a web application instead of IIS with Sql Server? My friend told that MYSQL consume very less when compared to SQL Server. I have both PHP and ASP.NET skills. Which one will be preferable to develop application? ...
select query to select all records that were inserted in 15 minutes.for ex if now time is 10:00 then it shoulld fetch all record inserted from 9:45 to 10:00 ...
hello On you tube,facebook,flicker millions of photos and videos are uploaded by users so how they manage all such large uploads.i know that they have large space on their servers but i just want to ask that which technique they are using to store this kind of huge data? And also please suggest me to best way to get this kind of ...
i generated my dataaccess dll using subsonic 3.0. i have a new proj referenced to this dll and am tryign to insert data to my mysql database. i get the following configuration error. however when i look at my App.config, i have a connectionstring that defines my database connection. <?xml version="1.0" encoding="utf-8" ?> <configurati...
In most web (PHP) apps, there is mysql_connect and some DB actions which means that if 1000 users is connected, 1000 connections are opened? But with C++ app it is incredibly slow...what is the main difference? Thanks ...