7,368 Topics
| |
how to copyng data from another database postgre to mySQL database without cronjob with realtime... thanks | |
Hey, could use a little help here. I must be brain dead but I can't think at all, I need help. I have a table with a bunch of IP addresses in it and a lot of them are the same, how do I -- Remove all the IP's except … | |
I've fired a query which result some data with the respective count from the table and after that i want to fire a query to get the total number of count on that count which i got it from my first query. Could anyone helps me out to get the … | |
I was trying to create a moving average. Here's the sample data: [code=MySQL] create temporary table if not exists window (id int); delete from window; insert into window(id) select 1 union select 2 union select 3 union select 4 union select 15 union select 6 union select 7 union select … | |
hi all, Is there a code where i can check from all the existing tables if a certain variables exist in it? I am currently working on a project but the tables are not linked properly, having a hard time trying to find out how many tables actually have the … | |
Here is the code. For a short time, I will leave the test results up at [URL="http://superiorminitrucks.com/inventory"]superiorminitrucks.com/inventory[/URL] Clearly, I need to stop it from displaying the final entry twice.. Thanks in advance.. [CODE] <?php $db_connection = @mysql_connect("######", "#####", "####"); if (!$db_connection) exit(); mysql_select_db("tefflox", $db_connection); $result = mysql_query("SELECT * FROM trucks"); … | |
Hello Friends, I have three table and i want to select data from them Table 1 Roll No. --- Name---Age 1------------a--------12 2------------b--------13 Table 2 Roll No.---Name---Age 7------------d------12 8------------b------13 9------------c------12 Table 10 Roll No.---Name---Age 41---------d---------12 43---------b---------13 44---------c---------12 Table 3 Roll No.---Sex 1------------f 7------------f 41----------f i want to select date from Table … | |
| |
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near." Now this is a really stupid error. (yes that sums up the error S T U P I D) I am making an update to … | |
I am helping a website owner to transfer a site to new servers. All site files have been uploaded onto the new server, only thing left is the database. In phpmyadmin, when I try to export the DATABASE to my local PC, using zip or gzip to compress, as this … | |
I am reading records from a linked server table, and trying to use the output in the next update statement, not on the linked server. I am assigning it to a declared variable. The file is being updated with NULL, instead of the correct check number. Any help??? Example code: … | |
Is this an appropriate place to submit a question concerning netbeans and creating queries? | |
Please tell me what I'm doing wrong. The sql query is in bold. [CODE]<?php //////////////////////////////////////////////////////////////////////////////// // // SECRET PAGE // // Invokes require_authentication() to ensure that the user is authenticated // //////////////////////////////////////////////////////////////////////////////// require("common.php"); require_authentication(); session_start(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns='http://www.w3.org/1999/xhtml' xmlns:b='http://www.google.com/2005/gml/b' xmlns:data='http://www.google.com/2005/gml/data' xmlns:expr='http://www.google.com/2005/gml/expr' xml:lang="en"> <head> … | |
I am able to connect to the database and located the table. I am unable to populate the db. Attached is a in image of the phpmyadmin trucks table structure. Please help. I am excited to be so close to getting it right. [CODE] echo '<blockquote><blockquote><blockquote>'; echo '<form method="post" action="/inventory/">'; … | |
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Inetpub\vhosts\thepinflow.com\httpdocs\staff\checklogin.php on line 12 Wrong Username or Password That is the error message I am recieving. I was using another website to host a PHP/SQL website before, currently located at: [url]http://www.blackairplane.com/Pinflow/index.php[/url] which works. When I copied all the … | |
Hi Everyone, Good Day,, can you help me to config mysql server to be able for me to connect to it thru a network. for example the mysql server is on the other pc and i am using a software in other pc. how can i connect to it.? thanks … | |
Well, i am facing this problem when i try to configure my ODBC 3.51 Driver. I had successfully installed MySQL. Then i try to install and configure my ODBC 3.51 driver. I add a new user DSN, filling with the correct username and password, with the data source name. However … | |
Hello, I'm having some sintax problems using PL/SQL in mySQL TRIGGERS.. I need some help please :). Here is the code: [code] CREATE TRIGGER modificou AFTER UPDATE ON monitor FOR EACH ROW BEGIN IF NOT EXISTS(SELECT estado_tmp FROM alteracoes WHERE id_tmp = OLD.id) THEN INSERT INTO alteracoes VALUES(OLD.id,NEW.estado); ELSE UPDATE … | |
I'm trying to carry out the following delete statements [CODE]DELETE FROM images AS i WHERE i.image_id = 803 AND i.plant_num = 2277 LIMIT 1 DELETE FROM images AS i WHERE i.image_id = 804 AND i.plant_num = 2277 LIMIT 1 DELETE FROM images AS i WHERE i.image_id = 805 AND i.plant_num … | |
I have a ton of inserts in an sql file that look like this: [code] INSERT INTO grades (GWid, classid, semester, year, grade, required) VALUES(100000089, 'CS210', 'B', 'fall', '2006', 'yes'); [/code] but when I get my filled tables, the semester and grades are all null and the year is 0000. … | |
Hi, I need to send a SMS message or/and Email in my database project. Which one is better option for me; Shall i create database with Oracle or MySQL? Thanks | |
Hello everybody!!!! I am just curious if I can make a database where all the data are images like bitmap, jpeg and other pictures format... If yes, can you pls show me some code or sites to where I can learn a lot about this.. YOUR HELP IS HIGHLY APPRECIATED.... … | |
I'm brand new to SQL queries, hoping someone can help me set up this query. I'm using [URL="http://www.phplist.com"]phpList [/URL]to manage my mailing list. All user defined attributes appear to be stored in a table called phplist_user_user_attribute. The structure of this table is:[INDENT][U]Field[/U], [U]Type[/U] attributeid, int(11) userid, int(11) value, varchar(255) [/INDENT]attributeid … | |
Hi, I put websites together using Xoops and OsCommerce. I need to know how to edit mysql databases using Cpanel. Please could you point me in the direction of some tutorials? There are some which show how to se up a database but not how to edit one. For example, … | |
Does anyone know of a free tool or utility that I could use with pgAdmin III that would accomplish the same type of import functionality found in Navicat? | |
Hello Everyboby!!! I just want to ask basic information but confusing in my part about the differences of ADO, ODBC and OLEDB ... I get confused in differentiating this three.... I hope you could help me with this problem... Your help is highly appreciated.... Thank You. | |
I'm trying to set permissions in mysql for an ecommerce open source application (freeway) for a path: Set the permissions on Freeway/images directory to 777 in my terminal I have typed: chmod 777 /Sites/Freeway/images but it is telling me that "no such file or directory exists", and yet when I … | |
Can someone help me figure this out. What do I need to do to set permissions in MySQL? Thanks in advance. |
The End.