is there any operator equivalent to === in mysql which checks value as well the datatype. actually i have a u_id field in a MYSQL database which is int type now from login page where user enter user id and during logicheck i write these code $loginCode = mysql_real_escape_string($_POST[userCode]); $sql=SELECT * FROM tbl_user WHERE u_i...
Hi, I'd like to move some small app databases to a cloud hosting provider. Basically, I'd like to not have to manage databases myself. I've been looking at Amazon RDS and MongoHQ, which are great, but are bit expensive. Are there any other alternatives other than setting up my own VPS? Thanks. Jim- ...
I was wondering if there is any Bulk Insert functionality available on the MySql Connector. I do have to create millions of records and I believe the batching will be a great feature for this. I'm working on an MVC project with a MySql datastore. Thanks, Leonardo ...
Hi! As far as I know, mysql doesn't use index if using IN(1, 2...n) queries. Am I wrong? Or is there anything I could do to make mysql use it? I don't mean IN() subquery optimization, because this is clearly explained in the manual. Example (assuming there is an index on all fields, named index_abc): WHERE a = 1 AND b = 2 AND c = 3 - ...
I keep getting this error here: Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\ReadNotes\viewyournote.php on line 40 With this code here: <?php //Starting session session_start(); //Includes mass includes containing all the files needed to execute the full script //Also shows home...
The table columns have the data type BLOB and CLOB. What are the corresponding Java data types? I am using MySQL database. ...
I am still new to implementing joins in my db_design and i am not sure if, at all this SQL is valid. "SELECT * FROM notes JOIN small_note ON notes_id = '$id' AND authname = '$author' AND bookname = '$book' AND user = '$username'" A bit easier to read like this: "SELECT * FROM notes JOIN small_note ON notes_id = '$id' AND auth...
I'm trying to retrieve hierarchical data from a table but am failing to do so. The table has (for now) the following columns: ifc_key, ifc_name, ifc_parent. ifc_key is not used. (primary key, but not used for this function. The purpose is to get an array. Each element is a "parent" interface. (so all these root elements are ifc_name v...
Given a database with two tables X and Y, I have a query that should LEFT JOIN the two tables on attributes X.a1 and Y.b1. I used the following query: SELECT X.a1, X.a2, Y.b1, Y.b2 FROM X LEFT JOIN Y ON (X.a1 = Y.b1) I thought that would be good enough to work, even if Y is currently an empty table. However, the query breaks because...
I'm currently working on a PHP application that uses a MySQL database for its backend All of my queries contain backticks to escape the field names. This is so I can have fields like "password" in a query without causing issues (see example) I know that backticks are not universal between relational-database engines (SQLite uses a doubl...
Hello guys, I have a very simple question. I just need to determine the codification (UTF8, latin1) of a text stored in a MYSQL table field. Thanks for you help! Guillermo ...
I want to make a webapplication in witch there will be some users with different projects (like c project, c++ project so on). My question is that how should I build up my 3 tables: users,projects,files? One user can have many projects (there will be shared projects too), the projects can have folders(packages) and files, but on the file...
Hi, I'm not used to work with values that should decrement every a timelapse like for a user warned, for example a warn which persist for 30 days that can reach a maximum value of 3 warns before the user get banned I thought to design a user table like this but now I should work on it, I find it not useful on decrementing the values eve...
So I have access to a dedicated server and want to finally create my game - it's a browser based game, fairly simple. I know PHP and MySQL fairly well and would want to integrate with them on the front end. The question is what is a good server-side language to use either as a constant process or with cron to interface with the MySQL d...
SQL syntax question about UPDATE. It would be much easier to ask the question by giving example below: **Payments Table** ID user_id payment_due payment_made 1 3 10.0 5.0 1 3 10.0 10.0 1 9 20.0 20.0 **Balance Table** ID user_id current_balance 1 3 ...
I've run in to an issue whereby PHP and MySQL seem to disagree on which timezone they should be using when converting certain timestamps back to date and time. The problem arises when I have a timestamp which I would like to convert back to a datetime format. PHP gives the date and time based on GMT being the timezone, but MySQL seems t...
I have a table with a primary key that is auto increment. I want to have an image associated with the primary key but I don't want the primary key to be revealed. Would naming the images something like: $filename = md5($primarykey + $secret_string) . '.jpg'; be a good solution? I am worried that there could be a collision and a file ...
I want to store a price for an item in decimal in MySQL. How would I have to format the price in order to store in in the db? ...
Hi, does exist some PDO::PARAM_??? which can be used for dates or timestamps? $sql = "UPDATE my_table SET current_date = :date WHERE id = 43"; $statement = $pdo->prepare ($sql); $statement->bindParam (":date", strtotime (date ("Y-m-d H:i:s")), PDO::PARAM_STR); $statement->execute (); ...
I've been assigned a downloaded xyz.sql file (which recreates tables and data that resided on another server. I have running MAMP 1.8.4 on my Mac 10.6.2. I finally got my mysql prompt at the command line using: /Applications/MAMP/Library/bin/mysql mysql –uroot –proot Now, what command can take that file for input, give my Mysql serve...