MySQL. I stink at RegExs. Just need one to tell me if string starts with a numeral
I need a MySQL query w/ Regex to tell me if my string's first character is a number from 0 to 9. ...
mysql
convert from mysql datetime to coldfusion datetime
Is anyone aware of a simple way to convert mysql datetime values to coldfusion datetime values in CF8 (and it may have to be backwards compatible with CF6)? I need to store date times in mysql and have chosen to store them in mysql datetime format so I can get the db to do date ranges and comparisons for me. I could so this stuff in CF,...
PHP Unable to echo ID field from MySQL database
I'm trying to print an ID from MySQL, the field loads into an array and is visible via print_r but I can't echo it or transfer it to another variable ... what am I missing? if ( $_POST['section'] == "freelance" ) { $field_name = "promoter"; } else { $field_name = "connector"; } echo $row[$field_name.'_login_ID'] As requested t...
How to IMPORT a excel file in to MYSQL DATABASE
Hi all, Will any one explain "How to IMPORT a MICROSOFT EXCEL file in to MYSQL DATABASE". For Example MY EXCEL TABLE LOOKS LIKE THIS. Country Amount Qty America 93 0.60 Greece 9377 0.80 Australia 9...
How to set value of mysql MaxNoOfConcurrentOperations
Hi All, I am getting following error Got temporary error 233 'Out of operation records in transaction coordinator (increase MaxNoOfConcurrentOperations)' from NDBCLUSTER While inserting data into ndb table. Can anyone explain more about this error. Also in my config.ini I dont have this parameter set. Is there any way I can see the d...
how can i print reports from browser in php
Hello, I have a report say, Sno Address Name Age when users click on Print button, they should be able to print the respective report Can anyone help me how can i handle this in php, as i generate this report in php I get all the info from table(MySql) Thanks for the help ...
Java not giving Error!
Here is my code - i am simply checking my MySQL database connection. But first i have compiled and run the program successfully. but then i have commented the line Class.forName . Still when i compile it runs successfully, without any error.Why? import java.sql.Connection; import java.sql.DriverManager; public class FirstJbdc { pu...
MySQL pattern replace
Would it be possible to do a little more 'advanced' string replacing in a MySQL query? I read about the REPLACE() method, but as far as I know, it cannot be used for fancy stuff. Basically, what I'm trying to do is remove all HTML tags from a specific column in a large dataset. Being able to do this in a single query would be a lot coo...
Proper indexing in a big table
I have a table with 8 million records that looks like this: CREATE TABLE `bdp_dosis` ( `ID_INSTITUTION` varchar(4) NOT NULL default '', `ID_SERVICE` char(2) NOT NULL default '', `SECUENCIAL` char(3) NOT NULL default '', `TYPE` char(1) NOT NULL default '', `DATE_LECTURA` varchar(8) NOT NULL default '', `ID_TARJETA` varchar(9)...
Design of the recommendation engine database?
i am currently working on recommendation systems especially for audio files.but i am a beginner at this subject.i am trying to design database first with mysql but i cant decide how to do it.İt is basicly a system which users create profile then search for the music and system recommend them music similar to they liked. which database ...
upload a file to a MySql DB with PHP
Hi! I want the users to upload files through my webapp I am developing in PHP usinig MySql in the backend. I want to store the files in the database. I am facing problems in doing so. Also, once the file is stored in a Database how do we go for downloading it, displaying it correctly in the webapp (the file type, and other attributes o...
Separating MySQL content via PHP on a "per-country/user preference" basis
Okay, I'll lay this out simply: I have one database that has content in it but I need to set up a conditon where if the user has selected Britain instead of the U.S. or vice versa -- some content will not show. This condition can be applied via a checkbox in the backend like so. "Hello, I'm a paragraph" show in [x] Britian [x] U.S. I'...
Inserting python tuple in a MySQL database
Hi, I need to insert a python tuple (of floats) into a MySQL database. In principle I could pickle it and insert it as a string, but that would grant me the chance only to retrieve it through python. Alternative is to serialize the tuple to XML and store the XML string. What solutions do you think would be also possible, with an eye to...
Using joins correctly
I am looking for a tip on how to optimize this.... SELECT u.uid, u.username, u.nid, wd.pay FROM (users_data AS u LEFT JOIN winners_data wd ON u.nid = wd.nid AND u.uid = wd.uid) LEFT JOIN dp_node dn ON u.nid = dn.nid WHERE u.uid = ".$val." ...
Retrieving the last record in each group
There is a table "messages" that contains data as shown below: Id Name Other_Columns ------------------------- 1 A A_data_1 2 A A_data_2 3 A A_data_3 4 B B_data_1 5 B B_data_2 6 C C_data_1 If I run a query "select * from messages group by name", I will get the result as: 1 ...
What is a good tutorial on how to set up tomcat with mysql and database pooling?
I have been looking for some good instructions on how to utilize connection pooling in Tomcat 6 connecting to Mysql 5, but there does not seem to be any complete references. I am having trouble piecing together different tutorials to get a clear picture. I must admit, I am very much a beginner in dealing with Tomcat and it's configurat...
MySQL replication is not running although mysql says it is
I have two servers configured in a master-master pair using MMM. I recently had an issue where the passive master received a replication error (got a packet bigger than max_allowed_packet) but the slave IO and SQL threads continued running. And seconds_behind_master was still showing as 0 even though the slave was not executing new state...
MySQL row count incorrect when reading a table's indexes from INFORMATION_SCHEMA.STATISTICS
I'm seeing some strange results when querying INFORMATION_SCHEMA.STATISTICS for index names. When I do "SELECT * ...", I see 2 indexes, but "SELECT COUNT(*) ..." it says count(*) is 0. Anyone know why? Is there a better way to get indexes on a table, ideally not MySQL-specific? Example: mysql> SELECT COUNT(*) FROM INFORMATION_SCHEMA.ST...
Basic SQL stuff... Left Join
I'm new to SQL. This didn't return any results..... SELECT media.id as mediaid, media.title as mediatitle, media.description as mediadescription, media.date as mediadate, media.duration, media.price as mediaprice, media.thumburl as thumburl, presenters.f_name as firstname, presenters.l_name as lastname, presenters.credential...
How do I get a list of tables from MySQL using Java's DatabaseMetaData?
DatabaseMetaData metadata = con.getMetaData(); metadata.getTables(catalog, schemaPattern, tableNamePattern, types); What fields are required to get a list of tables? ...