I'd like to give customers a choice of the database engine, but also want to minimize my troubles of such a decision. The engines in question are MySQL (5 or later) and SQL Server (2005 or later). ...
I am looking to parse INSERT and UPDATE MySQL SQL queries in PHP to determine what changes where made from what original data. Now this would be pretty easy to create, but I want to see if there are any existing libraries in PHP to do this. Basically what I have is a table with all of the above queries that have been run on a database. ...
Hi, since fews days Mysql server on Windows does not success on closing itself. In the mysql error log I find multiple instance of these lines: InnoDB: Operating system error number 32 in a file operation. InnoDB: The error means that another program is using InnoDB's files. InnoDB: This might be a backup or antivirus software or ano...
In short: How do you specify a BIGINT in Django models? In a current project I am doing using Django (0.97-svn release), I've all the integer fields in all the models defined as IntegerField. It was working immaculately during the development cycle where I was using SQLite for the DB backend. However, as soon as I rolled off to MySQL, ...
I'm trying to determine what situations MySQL updates an index. Say I have the following table: CREATE TABLE MyTable ( ID INT NOT NULL AUTO_INCREMENT, MyIndexedColumn VARCHAR NOT NULL, MyNonIndexedColumn VARCHAR, PRIMARY KEY (ID), INDEX MyNewIndex(MyIndexedColumn) ) Then I run the following SQL to insert a row: INSERT INTO...
I'm using system catalog views such as SYS.ALL_ OBJECTS, SYS.FOREIGN_KEYS etc. to get information about my database structure in MS SQL 2005. Are there equivalent functions/views for MySQL (v. 5) servers? ...
I am messing around with Doctrine (version 1.0.3) to see if would make a good fit for the collection of apps I am writing. I am trying to do a query and return only 3 fields. I am getting the correct fields in one table, but the join table I am getting everything when I only want one field. I have written out the what the SQL should b...
What's the easiest way to get the data for a single table, delete a single table or break up the whole dump file into files each containing individual tables? I usually end up doing a lot of vi regex munging, but I bet there are easier ways to do these things with awk/perl, etc. The first page of Google results brings back a bunch of non...
What is the preferred way to insert strings that can contain both single and double quotes (",') into MySql using DBI? For example, $val1 and $val2 can contain quotes: my $dbh = DBI->connect( ... ); my $sql = "insert into tbl_name(col_one,col_two) values($val1, $val2)"; my $sth = $dbh->prepare($sql); $sth->execute(); ...
In a project I'm starting I would like to give privileges to users based on certain conditions, eg (in a certain table): can READ all rows cannot WRITE to rows with id < x, but can WRITE to row >= x etc... I would like to avoid views as these conditions might change for each user (I understand I would have to create a view for each c...
Hey guys, I already know Java, Objective C, C#, and some Python. I want to be able to integrate with XML or a MySQL database for dynamic content. What are some tutorials or online references that would get me up and running with Actionscript 3.0? ...
Hi, The line where this error was called from is this: $celkova_suma=mysql_result($c_res, 0, 0)+mysql_result($d_res, 0, 0)-$zlava_suma+$arr[$_POST['sp_platby']]; Can someone tell me what I should be looking for?? ...
I want to reverse engineer (import into diagram form) the database definition dump of a database I have, then since no foreign keys are defined in this particular database, I want to be able to manually create the table to table key mappings (using crow feet notation if possible). I've taken a look at MySQL Workbench, and it gets me 85%...
Is it possible to insert a row, but only if one of the values already in the table does not exist? I'm creating a Tell A Friend with referral points for an ecommerce system, where I need to insert the friend's email into the database table, but only if it doesn't already exist in the table. This is because I don't want any more than 1 p...
Heya Is there a way to get the count of rows in all tables in a mysql database without running a SELECT count() on each table? Cheers ...
My question is a lot like this one. However I'm on MySQL and I'm looking for the "lowest tech" solution that I can find. The situation is that I have 2 databases that should have the same data in them but they are updated primarily when they are not able to contact each other. I suspect that there is some sort of clustering or master/s...
errr im not sure if my question's title is clear enough but i'll try my best to explain i really am not sure about how php executes the function mysql_query in terms of retrieval and storageof strings, does it recognize any character set encodings used in the table? and does my browser by default overrides any character encodings sent th...
I have this query statement and want to only get records that has a certain column empty (volunteers_2009.venue_id) Table is volunteers_2009, column I am looking to see if it is empty: venue_id Here is the current query: SELECT volunteers_2009.id, volunteers_2009.comments, volunteers_2009.choice1, volunteers_2009.choice2, voluntee...
Last night I added a parameter to a stored procedure in a mySQL database. I accessed it, messed up the parameter, and decided to remove the parameter again, for testing. Still minutes after re-creating the procedure without the parameter, my command object was still complaining about a missing parameter. Is this mySQL, MySQL/Connector...
I have a MySQL (v 5, MyISAM) query that returns different rows depending on date string format. (1) IFNULL(date1, ADDDATE('2008/10/31 23:59:59',INTERVAL 1 DAY)) > '2008-10-31 23:59:59' (2) IFNULL(date1, ADDDATE('2008/10/31 23:59:59',INTERVAL 1 DAY)) > '2008/10/31 23:59:59' (3) date1 > '2008-10-31 23:59:59' (4) date1 > '2008/10/31 23:59...