Hi, I have a MySQL table where there is a 'date_added' (date) field, 'time_added' (time) field and 'timestamp' (int) field. I found out afterwards that I can convert timestamp to a date or a time anyway, so so does that mean I could get rid of the other date/time fields and keep the timestamp only? Thanks in advance ...
Hello, For a few hours I was figuring out how to make an inner join these tables(tables are simplified for this question): Table message have these fields: | id | content | Table message_relation have these fields: | id | message_id | sender_id | receiver_id | Table user have these fields: | id | name | What I want to do with th...
hello let's say mysql is something like this select x,y from xx group by y i want to know how many rows that select will get, i tried to use count but it will n't return all results since i'm using group by. how to do that? Thanks ...
I'm really new to website development and for a project I need: No public pages. All private. Login+Password (Users, Admins) Being able to upload XML-files from Android device Parse this XML into something I can plot. Easy charting. Admin users being able to read all sub-users uploads. Doesn't have to look good. No blog-post. Strictly...
SELECT MAX(some_field) FROM table_A GROUP BY another_field. this only get the max value of the 'some_field', I wanna get the whole record which contains the MAX(some_field). thanks. ...
Hi, I have noticed that there are strange requests to my website trying to find phpmyadmin, like /phpmyadmin/ /pma/ etc. Now I have installed PMA on Ubuntu via apt and would like to access it via webaddress different from /phpmyadmin/. What can I do to change it? Thanks Update For Ubuntu 9.10 and Apache2, the corresponding sett...
I would like to better understand the basic steps needed to a take an XML document like this Breakfast Menu... <?xml version="1.0" encoding="ISO-8859-1"?> <breakfast_menu> <food> <name>Belgian Waffles</name> <price>$5.95</price> <description>two of our famous Belgian Waffles with plenty of real maple syrup</d...
I understand that Oracle will at some point add support for MySQL to its Enterprise Manager software. However I'd like to know perhaps from other Oracle to MySQL migrants what tools are available for monitoring the queries, activity and resource usage happening on a MySQL database instance. ...
I have something like that: to_days(now()) < to_days(birth) It work but instead of comparing days I was to compare the time too. Is there a similar function? ...
Our database is filled with articles retrieved from RSS feeds. I was unsure of what data I would be getting, and how much filtering was already setup (WP-O-Matic Wordpress plugin using the SimplePie library). This plugin does some basic encoding before insertion using Wordpress's built in post insert function which also does some filte...
Consider the following DB table: c p ========= 1 'a' 1 'b' 2 'a' 2 'c' Now, my goal is to retrieve a list of numbers c, for which holds that each number in this list has at least a record with p='a' AND p='b'. In the example table above, that would be c=1. Now my question is, how do I accomplish this using one My...
just yesterday i finished one site, which provides video watching. but now i need to show the number of views of each film. i never wrote such thing, so i don't know what to do. maybe i must add one field in mysql database, and increase it every time the video opened? but i use flash player, and i can't wrote script onclick of player....
I have the following tables: CREATE TABLE title ( booktitle VARCHAR( 60 ), title_id CHAR( 6 ), au_id CHAR( 11 ), PRIMARY KEY (title_id) ) create table authors ( au_id char(11), au_lname varchar(20), au_fname varchar(20), phone varchar(10), address varchar(30), city varchar(20), state char(2), zip char(5)); I ne...
I am running some sample tests against mysql, and finding that there are a bunch of queries which are stuck in "copying to tmp tables". They remain stuck in the same state. They are usually aggregate queries and I can kill those queries. But how can I find out what is causing them to be stuck? I am using mysql 5.1.42 with the innodb plug...
What is an easy way to design MySQL Queries? ...
I cant believe this, i always throught the below would be concurrency safe. I write to a row in one transaction and i am able to read the dirty value from another transaction/command/connection! Why is this possible (not my main question) isnt this not desired and cause more troubles!?! Anyways, i expected that once i write to a row no...
I have a coordinate. I want to find the top "n" (n being a variable value) nearest coordinates out of several thousand rows stored on a MySQL database. I also want to be able to define maximum and minimum distances between the coordinate in question and the coordinates in the database. How best am I to go about this? Would it be bonkers...
Hi All, I'm probably going to make myself look like a fool with my horrible scripting but here we go. I have a form that I am collecting a bunch of checkbox info from using a binary method. ON/SET=1 !ISSET=0 Anyway, all seems to be going as planned except for the query bit. When I run the script, it runs through and throws no erro...
While I've been working with MySQL for years, this is the first time I've run across this very newbie-esq issue. Due to a client demand, I must host their website files (PHP) on a IIS server that is not running MySQL (instead, they are running MSSQL). However, I have developed the site using a MySQL database which is located on an extern...
Hi All! ;-) my question is: assuming we have a calendar_table with UNIX datestamp date_column, i want retrieve the event with the closest proximity to the today date. So, for example if there is no event today, keep the closest one based on it's date! UPDATED probably i need to be more clear, i need to retrieve not just one event, b...