I need to convert a bunch of dates in a MySQL database from Pacific time (America/Los_Angeles) to UTC. I found a great SO answer on how to do this. During my t
I'm looking for the best solution to implement messaging to multiple users within the system(Facebook-style). I'm came up with the following idea: where each
Mysql Database suddenly cannot be start in my Mac. I already tried to run sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start but it show the error ../Ap
I am getting this error: Fatal error: Array callback has to contain indices 0 and 1 in C:\xampp\htdocs\phpprojects\plapp\worker.php on line 53 How can I s
I am getting the above error when I execute the code - MySqlConnection mysqlConn=new MySqlConnection("server=127.0.0.1;uid=pankaj;port=3306;pwd=master;database
I am developing a project in Visual Studio 2010 on a 64-bit Windows 7 machine. I have been able to successfully connect to a local MySQL database without any is
I have written an mysql update query in PHP with preventing sql injections as: UPDATE table1 status = 1 WHERE id IN ( ? ) and active = ?, array(implode(',' $id
I am trying to update user information (phone number) but mysql showing syntax error. Here is the query for showing all data (phone number) select distinct a.
I keep a record of logins in a table. I have columns for id, ip, date and time. From that record of logins I wanna fetch logins made only in the last hour. I'
How do I get friend list from Friends table with counts of friends of my friends (Count not of my friends) Friends table" tbl_users_friends Field 1: id Field
I have a simple query that selects one field and only one row, thus one value. Is there any way to make it return NULL if the query results in an empty set? In
Hi I'm so confused with this UTC and GMT I'm inserting in MySQL table as ex column "event_date" like "2010-07-01 23:50:00" (datetime) my client asking an opti
Generate the following two result sets: 1). Query an alphabetically ordered list of all names in OCCUPATIONS, immediately followed by the first letter of each
the last days I was trying to learn how to access mySQL databases via Java. I am able to load the driver and get a connection to the database ( at least I thin
I'm in the middle of an SQL tutorial, and the question is which shipping mode has the highest number of delayed orders. The code i have tried using is as given
I'm working on getting my database to talk to my Java programs. Can someone give me a quick and dirty sample program using the JDBC? I'm getting a rather stup
I have one button retrieve I just want to get the database table "account" value by its row and col and display it in a textbox. I keep on getting errors on th
i export my database and export to another computer use phpmyadmin but it error, Static analysis: 2 errors were found during analysis. Unexpected character.
Please let me know what is wrong with the below command mysql> select max(count(*)) from emp1 group by name; ERROR 1111 (HY000): Invalid use of group functi
In SQL, I know I can do: UPDATE TableA SET MyColumn=NULL But, how do I enter NULL into a cell graphically? I tried entering 'null' and 'NULL' and '' (nothing/e