Importing text to MySQL: strange format
Sorry - this was an accidental duplicate of http://stackoverflow.com/questions/2188522/importing-text-to-mysql-strange-format, don't know how to delete question :( If an editor sees this, please delete. ...
mysql
Ordering and limit
In a table containing cities I want to get the five biggest cities and order them by name: SELECT * FROM cities ORDER BY population DESC LIMIT 5 That gets me the biggest cities ordered by population, but I want the same cities ordered by name. Is there an easy way to do this (without turning to a subquery or sorting the cities afterwar...
Amazon RDS (Relational Data Store) and SSIS
Does anyone know if it is possibble to use SSIS with Amazon RDS? Since RDS is essentially MySQL - would this be possible using OLE DB or something...? ...
Trying to insert IP address but get an error.
I'm trying to insert IP addresses into LastIP(An unsigned integer) INSERT INTO user_entry (UPC, StateID, StoreID,CityID,Price,Count,LastIP) VALUES (885909301378,1,1,1,170,0,INET_ATON(127.0.0.1)) Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to...
Is there a better way to include() a PHP loop that depends on a varying MySQL query?
I have a large PHP loop that I'm re-using in multiple spots on multiple pages of my site. I'd normally just use an include() to set that PHP loop wherever it's needed, but the PHP loop in question makes use of a MySQL query in which I need to change variables (different filters and different LIMITs) for different instances of this PHP l...
MYSQL Searching by Zip Code
I am having a tough time searching by zip, which wasn't a problem before and will most likely be an easy problem for a MySQL / PHP programmer. I have a database full of house listings that I need to search by various fields. I have no problem searching by city, until I search by zip code (which like I said used to work). Anyways here i...
Searching for keywords in two MySQL columns
I have a user table with columns named *first_name* and *last_name*. SELECT * FROM users WHERE first_name LIKE '%keywords%' OR last_name LIKE '%keywords%' Using the above, if I search for "John" or for "Doe" I'll get a hit. But if I search for "John Doe" I will get 0 results. How can I search MySQL in a way that will mat...
MySQL - Limit the amount of rows in a join?
Not sure Looking for some guidance here... I have the following tables: site_text id site_id text date_added 1 1 ... 2010-02-02 10:01:00 2 1 ... 2010-02-02 10:01:20 3 2 ... 2010-02-02 10:01:00 4 1 ... 2010-02-02 10:01:40 5 2 ... 2010-02-02 10:02:00...
How to drop all table in MySQL?
I don't want to drop database, because I'm not hosting the website on my own machine, drop the database will require create it again,and many settings. Is there a command in MySQL that can be used to delete all tables in a specific database? EDIT Everything I can do is within a phpMyAdmin ...
php mysql update statment generation from form values
I am creating a very small database abstract layer, i want to send an array of variables that i obtained from a form, and generate an update sql statement, and eventually execute it. What do I put on the second to last line below? for example. $table name = "user"; $username = $_post['username']; $password = $_post['password']; $email ...
jquery - refresh the page when new data stored in to the table across the browser sessions
Environment : PHP/MySQL/Jquery I would like to refresh the page (ex: index.php) when new data stores in to the table (ex : new_entry_table) checking for every one minute. The same page will be opened in many machines(pc-browsers) at a time all should get refresh when new data arises. using jquery and database check i tried the followi...
mysql optimization - display 10 most recent records, but also identify duplicate rows
I am new to mysql and I have been pulling my hair out about this problem for days. I need to improve/optimize this query so that it runs faster - right now its taking over 5 seconds. Here is the query: SELECT SQL_NO_CACHE COUNT(*) as multiple, a.*,b.* FROM announcements as a INNER JOIN stores as s ON a.username=s.username ...
MySQL Query Issue - Count Query Uses lot of CPU
Hi, We have a table on mysql to log all visitors of our site. The structure is shown below CREATE TABLE `tblvisitors` ( `visitorURL` longtext, `visitorDatetime` datetime DEFAULT NULL, `visitorIP` varchar(255) DEFAULT NULL, `visitorID` int(10) NOT NULL AUTO_INCREMENT, `visitorUser` varchar(255) DEFAUL...
Zend: How to fetch record from Database without considering case sensitive ?
I am using Zend Framework. I want to fetch record from database without considering case sensitive. This is my Person Table: Id|Name |Gender|Occupation ----------------------------------- 1 |Naveed|Male |Software Engineer ----------------------------------- 2 |Ali |Male |Software Developer Now If I use the following strings to s...
Is there any free tool for creating database (mysql prefered) tables from existing html forms automatically?
I got a front-end designer to write tons of html form for me. Is there any free tool for creating database (mysql prefered) tables from existing html forms automatically? Names and datatypes of table fields would be generated based on names and types of form elements. ...
A php-based search facility with ExtJS not working well on Windows Environment
I created a search facility with ExtJS and PHP. The PHP file is the server side script with communicates with the database. On my Linux Environment, its working flawlessly. However, since I need to install this application on a Windows Server, I tried to copy it to my personal Windows XP. I installed Apache, PHP with the necessary exten...
Is MySQL's trigger concurrent?
Can there be two triggers running at the same time? ...
HTML table: modify order using mysql
I have a mysql table: (Questions) => question_id(PK), question(varchar), order(int) When displaying the data in a html table: the order of the data is sorted by 'order'. Is there a way to make changes in the 'order' using buttons(move-up/down) then update the order in the database? Thanks in advance! ...
What is difference between mysql,mysqli and pdo ?
What is difference between mysql,mysqli and pdo ? Which one is the best suited to use with PHP-MYSQL? ...
MySQL Filter results
Hey, I have a table in my SQL in the following structure called actions: +----+--------+------+---------+ | id | action | type | user_id | +----+--------+------+---------+ | 1 | 5 | 4 | 1 | | 2 | 6 | 4 | 1 | | 3 | 5 | 4 | 2 | | 4 | 0 | 0 | 2 | | 5 | 0 | 1 | ...