10,940 Topics
 | |
| | Hi, I wan to know where the MySQL variables stored? when I execute the [CODE]show variables; show status; [/CODE] I see many more variables, so I want to know the place they are stored in? and the file name too? |
| | For some reason I deleted a sample database that was in the netbeans tutorial. Of course now I need it and I don't where to get it( I tried the google,and will try again) but does anyone know how to obtain the script? Thanks -Steve |
| | Hello All, Is there a way how we can pass a PHP variable whose value has been retrieved from MySQL database to the next page? Initially I tried this which didnt help me anyway. [code=PHP] // if user login information is CORRECT then redirecting them to the user home page … |
| | I am running a MySQL cluster test on 3 nodes. 1 management node 2 storage nodes. I can't seem to get mysql to start successfully. All 3 nodes are running Ubuntu Server 8.04 with MySQL 5.1 ... I know this is totally new, however, we are trying to test out … |
| | Hi, I need to match rows from one table to another table that may or may not have a match on one common column.... the problem begins with bringing back the most recent row in the other table. So, the query I'm starting with is: [code]SELECT * FROM data LEFT … |
| | Hello Is there a way i can have a MYSQL query to run automatically at a certain time without me running it myself? |
| | Hi. I want to GRANT privileges on two tables, but I dont know why error, but on one table it is ok. what is wrong? [CODE]GRANT SELECT ON mysql.db, mysql.user TO 'user'@'localhost' IDENTIFIED BY 'password';[/CODE] I dont know why it is not working on two tables??? |
| | I keep getting an error where the symbol cannot be resolved and the arrow pointing to where i have written statement.ExcecuteUpdate Am not able to insert any data into my database, can anyone see where i may have gone wrong. thanx heres the code: <%@ page import="java.sql.*" %> <%@ page … |
 | somebody knows how to call mysql Procedure in PHP? i extract almost forum regarding procedure in php on google but didn't find solution. pls. reply ASAP. thanks in advance  |
| | I am using adodb to import a CSV file into a MySQL database. One of the fields is lastname. One of the contacts being imported has a last name of 'null' (yes, that is really his last name). It always gets valued as a NULL value, not null the string … |
| | Hi everyone I was wondering if there is a way to store data to a mysql db after it is screen scraped? Thanks |
 | I currently have a database that is just one table with products and is using the myisam engine for the fulltext capabilities on two columns. The question I have is that this database has about 390,000 rows with a lot of duplicate entries namely manufacturer, price. I have been searching … |
| | Hi all, I wonder if it is possible that someone can drop me a code or something on this particular problem which I am currently dealing with. in_date out_date 18/03 30/04 20/04 So how am i supposed to pair up 30/04 and 20/04 as 1 pair and show it up … |
| | Hello everyone, I'm currently building a cms system and have hit a brick wall in relation to the error I'm getting below. Any help would be greatly appreciated. Thanks James. The error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\widget_corp\includes\functions.php on line 41 The functions.php: …  |
| | Hi people. This is my first thread, i hope you can help me. I'm a newbie and my english is so bad, but, i hope you can understand me. this is my question: I've a table TURN with this field IDTURN (int) SEASON (string) SORT (string) another table GROUP IDGROUP … |
 | Hey, im having a problem getting this email check to work it basicly prints out in a very origional way how manny eails you have... [COLOR="Green"][B]Check Inbox [/B]([I]3[/I]) [/COLOR] Heres the code: [CODE]$find_content = "SELECT * FROM email WHERE email_too_id = '$userid' OR all = 'true'"; $content_sql = mysql_query($find_content) or … |
| | 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 … |
| | Straight to the point...:) I have problem connect to database. when I click Login button, the code can't read the username in my database. I have checked the codes but i think there are some mistakes, but i don't know where it will be. Please help me. Here with I … |
| | I get the following when attempting to view a project I have, I have MySQL 5.0 and Tomcat 6.0. Both services are running. As far as MySQL connectors, I have both "mysql-connector-java-5.0.7-bin" and "mysql-connector-java-3.0.8-stable-bin". This has not worked with either one. HTTP Status 500 - type Exception report message description … |
 | I am new to VB. Yesterday I learnt how to connect to a database. My work computer has Microsoft SQL Server (which I could connect to) but I use mySQL at home and do not know how to connect to it. Can somebody please help? |
| | I'm a C++ beginner. What's an easy to use (in terms of both installation and use in code) library for using MySQL in C++? Is there one that's a lot more commonly used than others? Note that I'm using MySQL 4.1.22 on GNU/Linux. I've found the following: [LIST] [*][URL="http://dev.mysql.com/doc/refman/4.1/en/cplusplus.html"]MySQL++[/URL] [*][URL="http://www.sqlapi.com/"]SQLAPI++[/URL] … |
| | 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 … |
| | Hi!! I have a problem to connect VB to Mysql database |
 | 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"); …  |
| | What would be the php mysql code to search more than 1 field in a table ? Im trying to search for a given partial phone number in all three fields home mobile and work .. im trying to use $query = "SELECT `first`, `last`, `home_phone` , `work_phone` , `mobile_phone` …  |
| |
The End.