[mysql] Forum Topics

I have a query. Say in a notepad( D:\SQL.txt) I have 100 commands written in it UPDATE sal SET sal= sal+3000 select * from .................. insert into table tab_name values(........) insert into table tab_name values(........) insert into table tab_name values(........) .........so on Is there any SQL query like that if …

I've installed the plugin "WP Security Scan" on a fresh install of Wordpress 2.6 running on a Apache server at hostgator & the plugin says this about my table prefix. Your table prefix should not be wp_. Click here to change it. Change your database table prefix to mitigate zero-day …

[B]Please excuse the length of this post:[/B] I'm trying to integrate OpenFire (XMPP Server) with a Joomla (CMS) user database. Openfire allows authentication against an external database by editing its configuration. In the configuration you have to supply the query that will retrieve the password from the external database, given …

Hi, I have noticed that a lot of newbies using MySQL ODBC driver on their Windows often come across difficulties testing the connection despite that they have created the database on their servers. If you can put our members through in step wise fashions, please respond to this tread. It …

Hi, How can i pick next or prevoius day in mysql? Any function like curdate() ? Thanks

Hi, [inlinecode]Select closing From balance Where account_no = 12 Limit 1[/inlinecode] returns an error "You can't specify target table 'balance' for update in FROM clause" Where is mistake? Thanks [code] AFTER INSERT ON Close BEGIN Insert into balance (date, opening, account) Values (CURDATE(), (Select closing From balance Where account_no = …

Hi, I have been trying to get MySQL to work on my apache server with PHP on it. My Apache version is 1.3.29 and my PHP version is 5.0.0RC2. I'm also running Windows XP Professional SP2 32 bit. I tried modifying the php.ini file to load the php_mysql.dll, but I …

Problem: I have been unable to access encrypted information using ENCODE and DECODE. The information goes into the file OK but I cannot DECODE it. Below is the code.’ 1. The call from the program. [code]$result1=$dba_pm->selectencrypted($id); [/code] 2. the code in the class module [code] $sql="select DECODE('PM_Subject','2TRILFDA9Gioads*%'), DECODE('PM_Memo','2TRILFDA9Gioads*%') from personal_memo …

Before I continue, quick explanation: product table pid (primary key), pdesc (Product discussion), and pquant (quantity of product). I then link it to sub_category which determines if it is where it falls (AKA SODIMM or DIMM). Now, I have duplicate product descriptions (160GB HD, for example.) We have 2.5 inch …

Hi, Code below is wrong but i can't find the mistake. [code] Set @RecAdj:=(SELECT SUM(Paid) AS Total FROM payment WHERE PayDate = CURDATE()); if ISNULL(@RecAdj) set @RecAdj:= 0; end if; [/code] Or is there any other way? Thanks

hi, i want to select from more than two table using a single mysql query.please tell me a example query/. thanks in advance

My SQL knowledge is a little rusty. While I can write simple queries, I have a complicated one that is giving me a headache. Any help? I'm using the following tables (only showing the relevant fields)... [B]Test table[/B] - TestID (pk) - TestDesc [B]FAC table[/B] - TestID (fk, Test) - …

Hello, I have a wordpress blog that I'm just testing around. I've chosen "friendly" urls which look like this: [B][url]http://www.self-made.us/2008/06/organization-of-material/[/url][/B] where the link is in this format : /[year]/[month]/[title of post]/ The "normal" link would look like this : [B][url]http://www.self-made.us/?p=4[/url] [/B] where p equals the database primary key of which …

My website host supports MySQL and has a simple MySQL “workshop” available in their “V-Deck” (user control panel) to make simple tables for things like subscriber email lists, etc.. [B]My question is, can I use MySQL on my HTML web site, to update item prices on multiple pages at once, …

If You need to login to a MySQL server with a username that is different from the username you use to log in to your operating system. Which command will we use?

range of datetime data type (show all records in between 2 dates. example: form 2008/10/01 to 2008./12/12). thanks

i have some entries in a databse like: <a href="85\test\some\other link.pdf"> 85\test\some\other link </a> I need to change that to just "85\test\some\other link.pdf" Is there A way it can be done without having to go through them one by one? Any help would be extremely appreciated

Alright after a few months of logging visitors to my site, I've compiled a database with the bots IP addresses and names. As of right now I have a little more than 1,400 recorded IP addresses. I've attached a 4 text documents of the IP addresses. I will continue to …

I've taken over a site and i see certain tables being updated without any code on the site doing the update. (It's logical updates so I know its by design and not a hacker) What I can't see in PHP admin and I also have MySql Query Browser is to …

Is there anyway to have (in one query) two separate queries? For example if query one fails then it will not affect the rest of it. Example code: Say that the lastLogin table does not exist: UPDATE userInfo SET lastLogin=3 WHERE id=5 UPDATE userInfo SET LastLogin=3 WHERE id=5 Is there …

I am trying to create website that has questions with drop down options. Do I need to know MySQL for that?

Hi, It's took me a weeks to figure out this query. I'm trying to select all the data from 7 tables but i got empty result. All these table has a link on region_id column. Your help will be much much appreciated. here's my query: [code]$q = 'SELECT rs.*,rr.*,cs.*,cr.*,cl.*,ls.*,ll.* FROM …

hi friends i hava two primary key in single table no auto incriment.when i insert the value in jsp i getting like this error. com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '0-3' for key 1

Hello all: I'm currently building a website for a radio station and I want to setup a programming lineup. The fields I'm using are: ID Title Dayofweek (Show Day) Timeslot (Show Time) AMPM (AM or PM) Description Name (Host Name) Bio (Host Bio) Photo (Host Photo) I set these all …

Hello friends, when iam working on mysql server 4.1 the power suddenly went off. and when i restarted the mysql the mysql service is not starting and the error [B]"#2003 - The server is not responding"[/B] is comming can any one please help me to get back the database please. …

i am trying to set up this db and i am getting a parse error which it says it is on line 24 i cannot see the error. help need [CODE]$sql="CREATE TABLE IF NOT EXISTS `merc_users` ( `****` int not null, `******` varchar (250) not null, `*****` varchar(250) not null, …

Hi, I don't know what is LEFT JOIN at all, but i accidentally made this query work. Can someone tell me if there is a shorter version of this query? [CODE=SQL] SELECT j . * , k.report FROM ( SELECT x . * , y.category AS parent_category FROM AccountCategories x …

hi friend I want insert value to three table in single query any body have idea pls send the query for me advance thanks by san..

hi i am rupak from india, i know little about mysql and i would like to more about mysql. i need help. regards rupak <URL SNIPPED>

Hi, I encrypte my data when i insert into database. [code]insert into person (name, psw) values ('john',SHA1('111'));[/code] What about when it comes to checking that particular encripted values? Is there any function to use agains SIH-1. I have a textbox and i wanted to verify it with checking encripted data. …