This question is related to this one. I have a page table with the following structure: CREATE TABLE mydatabase.page ( pageid int(10) unsigned NOT NULL auto_increment, sourceid int(10) unsigned default NULL, number int(10) unsigned default NULL, data mediumtext, processed int(10) unsigned default NULL, PRIMARY KEY (pageid...
I am storing time in a MySQL database as a Unix timestamp and that gets sent to some Javascript, how would I get just the time out of it? Ex. HH/MM/SS ...
The column name is Case Ignore with MySQL 5.0, but, as for the table name, is Case Exact true? ...
I want to achieve by mysql query +------+---------+ | frq | -any- | +------+---------+ | 10 | 10 | | 15 |10+15=25 | | 15 |25+15=40 | +------+---------+ please help with code references, thanks ...
hi. im developing a cms. the Table clients contains many fields and one of them is the image caption. When the user uploads a file(image) the file is stored in a public folder. The image caption field retrieves the final name of the file and stores it in the table. The problem is when the user wants to update the information. If the...
Hi! I am sorry for the incomplete information. Here's my two sp's: SP1 - DELIMITER $$ DROP PROCEDURE IF EXISTS SP1 $$ CREATE PROCEDURE SP1(InputCustomerID int, InputOrderID int) BEGIN // Some sql statements and finally put it into the actual table tb1 in the database END $$ DELIMITER ; SP2 - In SP2 i am assigning input value of ...
I'm writing a publicly accessible web application which will contain personal user data, such as names and birth dates, and I'm required to encrypt this data in a form that will be difficult for a human who might access the raw data to decrypt. I'm using Fluent NHibernate, mySQL, and C# 3.5. What method should I use for industry stand...
What is supposed to happen is that a row gets inserted into a table, then that row's id is selected by means of comparison of the name and surname of that particular entry. The id returned is then inserted into another table: $result = false; $result = mysql_query("INSERT INTO `reunie` (`naam`, `van`,`nooiensvan`, `selfoon`, `email`, ...
Hi, I am trying to loop though my users database to show each username in the table in their own row. I can only get it to show one user but loops through this the number of rows there are. Code is below <?php require_once ('../login/connection.php'); include ('functions.php'); $query = "SELECT * FROM users"; $results=mysql_query($quer...
I have fields in a Mysql database typed datetime. I store, for example, a payment's date with next Java code: payment.setCreatedOn(new Date(System.currentTimeMillis())); In my view layer I use fmt:formatDate to format dates: <fmt:formatDate value="${payment.createdOn}" pattern="EEE, dd MMM yyyy HH:mm:ss"/> My ...
Not sure how to do this. The query doesn't need to be executed quickly...it's for a sphinx index...but it needs to include all the data for searching. Here's the table structure: person - main_id - name person_attritubes - attribute_id - name (example: hair, eyes, height) person_details - main_id - attribute_id - value (example: blo...
I'm pretty sure I've seen this somewhere, but I can't find the right terminology so I'm having trouble... Let's say I have a table with user info (let's also assume that it was created by someone who gets paid more than me, so modifying the schema is not an option.) Among the various columns of user info are columns for DOB and job titl...
I'm not new to programming, but i'm new to MySQL and PHP. I'm wondering what the most efficient way of doing the following. I dont need the actual code, but just the steps. I have a list of user reviews, lets say simply: USER REVIEW Bob nice John good Fred bad Bob poor Bob the best Fred medicre Bob shiny ...
Hello, I have a database table with a unique string field and a couple of integer fields. The string field is usually 10-100 characters long. Once every minute or so I have the following scenario: I receive a list of 2-10 thousand tuples corresponding to the table's record structure, e.g. [("hello", 3, 4), ("cat", 5, 3), ...] I nee...
I have to look into solutions for providing a MySQL database that can handle data volumes in the terabyte range and be highly available (five nines). Each database row is likely to have a timestamp and up to 30 float values. The expected workload is up to 2500 inserts/sec. Queries a likely to be less frequent but could be large (maybe in...
I have 1 million rows in MySql table "temp" and wish to multiply column "t" (int unsigned, indexed) by 1000. mysql> update temp set t=1000*t; This process takes 25 seconds. The same statement on not-indexed column takes 10 seconds; Any ideas how to make this process faster? I have to apply this on over 1e5 tables. ...
I'm working on a website currently that needs a commenting system. As this website is brand new, and the database structure has yet to be set in stone, I would like some suggestions on how to best handle a commenting system such as this: Comments must be able to be placed on anything. Including items in future tables. Comments must b...
Is it faster for the randomize the sort order of a large set of results on the MySQL server or after I have received the data in PHP? Does anyone have any data to backup either side, or even anecdotal experience? ...
I'm storing time-temperature data in a database, which is really just CSV data. The first column is time in seconds, starting at zero, with the following (one or more) column(s) being temperature: 0,197.5,202.4 1,196.0,201.5 2,194.0,206.5 3,192.0,208.1 ....etc Each plot represents about 2000 seconds. Currently I'm compressing the ...
Hi, We are developing an order taking system in PDA using C# in .netcf 2.0. So we are having mysql server as our back end. Is that the web service is the only way to connect mysql with PDA? Or is any other methods available..? ...