10,940 Topics
 | |
| | Hi, I am working in a finance project where each transaction table is having more than 4 Million records just for 3 months. I have user & branch related information on other tables. I wrote a joined query by joining around 5 tables to summarize the report based on Branch, … |
| | Hi, In main.jsp i wish to display the data from the database( user information stored in user table ). my codein main.jsp is: [code=JSP]<h2> description about user:</h2> <% Statement st = null; ResultSet rs = null; rs = st.executeQuery("Select description from user "); %> <option value = "<%=rs.getString("description")%>" > </option>[/code] …  |
 | Hi all Is it at all possible to do this? I have a number of records that I need to recover. Any help would be greatly appreciated |
| | Hi all, Instead of passing the variables to the other page and coding mysql queries there.. Is it possible that we can use the mysql(DELETE...) query within the anchor tags in the same page? <a href >... to delete a particular row in mysql table? Like having a link called … |
| | Hello, I have the following code, with 6 rows in the database for my query, although the mysql_fetch_row function is only able to get 5 out in my web page. I'm not sure what is wrong with my code, here it is: [CODE] $connection = mysql_connect("my server", "user", "pass") or … |
 | In most of my VB.NET applications, I connect to MySQL databases using the MySQL ODBC Driver. Recently, I got to know about the MySQL Connector (again provided by MySQL). Which one is better in terms of- a. Performance b. Security |
| | I have version 5.0.27 of MYSQL and when attempting to use AES_ENCRYPT I get the error: Call to undefined function AES_ENCRYPT() Here is a copy of a test query: $sql .=$name[$i] ."='".AES_ENCRYPT($assign[$xx],"36LKFOIREI#"); Can anyone help? tia Dick Deeds |
| | I am currently testing replication on mysql 5.0.9 running on Win XP Pro on 2 servers , one as a master , and another as slave , basic master-slave configuration. The slave have 2.5 GigaB of RAM,300GB SATA2 HD & on Intel 2.4ghz Core Duo and the master have 1 … |
| | Hi all!!! This is my first post here so please feel free to move if it's in the wrong place :-) Ok, i am just starting out in web development, and i have created a data entry form in DW CS3 and succesfully link it into MySQL (big deal for …  |
 | I have been reading books and articles and I have seen various mysql functions (mysql_query, etc) being used inside php functions and those php functions be called everything the php programming requires a query, etc. So what do you think are the best practices, etc? Thanks, Regards X PS: I …  |
| | I am a new convert to MySQL. It sounds like an answer to my prayers, BUT when I look for some training I find the cost to be substantial. I have purchased a book Beginning MYSQL by WROX but I now realize that I need some more structured training. I …  |
| | All, I am trying to write me an application using visual studio 2005. My back-end database for the application is mysql. I've found some code examples online and been able to get it working with both reading from the database and writing to it. However, the examples I find does … |
| | The migration seems easy enough, but what about a non-Access Interface. I need to move Access '97 databases to a system that will not have Access. I plan to migrate to Mysql. Any suggestions on an Interface similar to one my clients are used to? |
| | hey frnds... i am develpoing a program using PHP/MySQL. Here, i have a form which consists of a few text fields etc etc. It also contains a drop down menu. In the backend, i have a number of databases. The user input (drop down menu) will decide which database is … |
| | Hello, I try with the following query to calculate the working time of employees: [code=mysql] SELECT TIME_FORMAT( ADDTIME( TIMEDIFF(TIMEDIFF(hour_end, hour_begin),(hour_pause)), TIMEDIFF(TIMEDIFF(hour_end_o, hour_begin_o),(hour_pause_o)) ) ,'%H:%i' ) AS total FROM hour [/code] This works correct, if the pause is filled, if no pause is given, no total is displayed (NULL). How can … |
| | Hi all, i am getting `Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\xampp\htdocs\demo\help.php on line 23` this error. how to overcome by this problem, <?php include 'database.php'; $email = $_POST; $firstname = $_POST ; $lastname = $_POST ; $tphone = $_POST.$_POST.$_POST ; $message = $_POST; …  |
| | I'm uploading files via php script straight to a folder called 'uploads' on my mysql server. I can list all the files uploaded. My problem is listing only selected files from this folder for each user that login. i.e. user A logs in with username 'theboss' The user will be … |
| | Whats wrong with this query? [code=mysql] TIME_FORMAT( DATE_ADD ( TIMEDIFF(TIMEDIFF(u.hour_end, u.hour_begin),(u.hour_pauze)), TIMEDIFF(TIMEDIFF(u.hour_end_o, u.hour_begin_o),(u.hour_pauze_o)) ) ,'%H:%i') AS total, [/code] I get the error: [QUOTE]#1305 - FUNCTION system.DATE_ADD does not exist [/QUOTE] BTW: I am using version 5.0.51a. |
| | Hi, I couldn't get this to work, but I was using a PHP script to go through the rows in a table in my database and if it found a specific value, to delete that row. However, it deletes ALL the rows no matter what I do and throws an … |
| | At our television station we have a schedule of shows that need to be aired (stationschedule) and shows that have aired confirmed by our on air system (asrunlogs). What I'd like to do is compare both tables against eachother to see if there are any major differences. Both tables have … |
| | Hi , I am a newbie. I want to create a user and grant enough permission to backup a database. Also , i want to Create a daily backup schedule and select to perform daily incremental and weekly full. Please help me to do this using MYSQL script(MYSQL query Browser). … |
| | hi, i have a table called exam, it has following columns ----------------------------------------------------------------- | ID | QUESTION | OPTION_1 | OPTION_2 | OPTION_3 | ----------------------------------------------------------------- now I've normalized it and put the exam options in another table called 'exam_option' table which keeps these options in rows instead of columns. Since i … |
 | |
| | This must be a pretty newbie mistake, but I'm still flummoxed by it. I created a very simple procedure: [code] create procedure deleteAll () begin delete from test1; delete from test2; end [/code] but when I run it I get a Error code -1: Error executing SQL command. The strangest … |
| | Good day :) <<== new, please excuse If I post shit :) I've one query which doesn't work: [CODE] SELECT conquer.timestamp AS time, conquer.new_owner AS new_owner_id FROM de12_conquer AS conquer INNER JOIN de12_tribe AS conqueror ON conqueror.id=conquer.new_owner INNER JOIN de12_tribe AS loser ON loser.id=conquer.old_owner WHERE (conquer.timestamp>0 && conquer.timestamp<1213647029734) AND (conqueror.ally=37038 … |
| | Hi everyone and thanks for reading. I've been making a news section for a client's site and now I'm trying to make a little box for the front page to show the five latest stories. Everything is fine in that aspect; I know about using the LIMIT keyword in the … |
| | Hi, I am novice in PHP & Mysql. I am facing a problem when I put a command in Mysql the following error is showng. Please help me to solve this problem. Mysql> create database xx; ERROR 1044(42000):Access denied for user ' '@localhost' to database 'xx' Thanks Susanta |
| | what r the types of mysql backups..>?.. please explain.. what is meant by [COLOR="Red"][B]point in backup[/B][/COLOR]??? |
| | Hi, I have 2 tables "name1_" and "name_2". I want to compare them. If name in "name_1" table is same as name in "name_2" table, then copy whole row into other table "name_3". Thanks |
| | Hi guys, How can i convert code below into INNER JOIN style. Thanks [code] UPDATE def_1 SET Valid = 'Yes' WHERE id IN (SELECT id FROM def_2) AND paid IN (SELECT paid FROM def_2) AND valid IS NULL [/code] |
The End.