10,940 Topics
 | |
| | |
| | [icode] "My wamp server got damaged recently and i had no backup for my databases. I had reinstalled the wamp server and replaced the bin/mysql/data folder to the new one but I only get the database and not the tables inside it. I need help!!!!!!!! "; [/icode] |
| | Hi, everybody. I've been a member for a while, but I'm not a coder, so I haven't made any posts. But I get frustrated not knowing how to do things. So I'm taking the plunge. I'm working through a tutorial on PHP and MySQL (here: [url]http://dev.mysql.com/tech-resources/articles/ddws/[/url]), and things have been …  |
| | the following is the code: [CODE] <%@ page import="java.util.*" import="java.sql.*" import="java.io.*" language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <% Integer hit = 0; Connection con = null; Statement stmt=null; ResultSet rs = null; %> <% try { out.println(); Class.forName("com.mysql.jdbc.Driver").newInstance(); con = DriverManager.getConnection("jdbc:mysql://localhost/lab2","root","root"); stmt=con.createStatement(); rs=stmt.executeQuery("SELECT hitCount from table1"); hit = rs.getInt("hitCount"); hit = hit … |
 | I have a database that needs to hold names of people from all around the world. Some names have special characters in them such as é and ¢ Is there a character set I can use that will accept any character no matter what language it is (with the exception … |
| | Hi; I want to connect MySQL database from turbo c++.I have installed MySQL 5.0.Also MySQL c++ connector.But it's not working.How can i connect.Any body have any procedure for it? Is it possible to connect it directly without any connector?If yes,then how?  |
 | How to handle UTF-8 characters in HTML, JavaScript, PHP and MySQL ... |
| | I created some data files with 'outfile ' command. The files are created in the mysql folder.{I use WAMP} I want to create those files in another directory. How can I do that? Thankx in advance. |
| | This script works with require_once and produces warnings for line 6 when I try to use $mysqli = new... (which I've commented out). Please help me with this script: [codebox]<?php require_once "connect_to_mysql.php"; //$mysqli = new mysqli("localhost","user","pw","db"); $result = mysql_query("SELECT * FROM example") or die(mysql_error()); echo "<table border='1'>"; echo "<tr> <th>Name</th> … |
| | How do I connect, wirelessly, to a localhost on another PC? I have not problem with "jdbc:mysql//localhost/databasename" but I can't figure out on another PC, named "PC2". Thank you. |
| | My C# program is able to work with existing MySQL and Access databases. Additionally, it will also create a new Access database if none exists. I am not able to get it to create a new mySQL database though. When the program attempts to run the ExecuteNonQuery command for CREATE … |
| | I've spent a bit of time porting my database connection over to MySQL. It's taken a bit of time, but generally been fairly easy. However, one of my insert queries is currently failing due to an auto increment ID field. I have this insert query: [CODE]INSERT INTO entries(text, name, screen_name, … |
| | A few days ago I decided to install MySql v1.2.17 and I downloaded a client class library: MySql.Data.dll v5.0.9.0 (by MySQL AB). I included the client classes inside my wrapper class and had it creating, dropping, inserting, and deleting tables..., or so I thought. I guess I never actually looked …  |
| | how do i add an image path to a mysql table of mine which has "product image" as a field. i have saved the necessary images to images folder in root folder as well... please help! |
 | Hello all.. Very new to php and am working on an online strategy game as a precursor to my business websites. I am having a problem coming up with something I thought would be simple. My intention was to have a list of units display on the screen using checkboxes … |
| | Hello New member and pretty ignorant about SQL I should say. I have made regular backups of mySQL database and now that I need to restore it[B] I see all the characters (UTF-8) characters have changed to wierd characters [/B]that make no sense at all. I am using [B]phpMyAdmin's Export … |
| | hi i have two tables, one is products, the other is for 'discounts' on those products... when adding a new 'discount' i want to avoid adding two discounts to a single product... so i was looking for some sort of Right Join which would exclude all products which have a … |
| | Hello, I am a training developer in .NET and web 2.0 technologies and this one is an exercise from one of our first lessons in PHP: accessing a MySQL database from a PHP script. The problem I've encountered is that while database is thought to be in Unicode (i.e. the … |
| | Hi, Is it possible to upload a file that contains some data and directly save the data in specific fields as in database using php?. this is important as the data retrieved according to their field name. Thank you.  |
| | Hello all, i would like to know how it is possible to remove for example last 20 characters, or by specifing the string to remove. For example i have 2 rows (in reality there are more than 100, thats why im not working it out by hand) with the next …  |
| | Ok so what does mysql return when the select query doesnt exist. So say I query the database: SELECT username FROM user WHERE username='test' AND password='test' Ok so say test doesnt exist what will the database return because i code in java and have made a method that should return … |
 | Hi! After years I decided to sign up! Can you please tell me of a bot tutorial or getting a solution to my problem. What direction should I be going. I want to make a PHP script that searches a MySQL table's columns, rows and then returns all the spelling … |
| | Ok so what i want to be able to do is connect to a mysql database. Here's my code so far: [CODE] Connection connection = null; try { // Load the JDBC driver String driverName = "postgresql-8.4-701.jdbc4.jar"; // MySQL MM JDBC driver Class.forName(driverName); // Create a connection to the database … |
| | hello plz i need help with this urgently as it i supposed to be used tomorrow :S i get this error from the following script Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/aybasuco/public_html/MySQL-Formmaker/lib/db_index.inc.php on line 42 thanks in advance for your valiable time [CODE]<?php # … |
| | Hi. I have a web application whereby I perform a search through 4 fields, namely:book serial no.,tel no.,gender and publishing date.In my jsp page variables picking the values respectively are:serial,tel,gender and datez.These are submitted to the java class.Currently, I perform my searches as follows(in java class): /***********************************************/ [code=Java]//......after connecting to … |
| | hey.. i have a table with one column defined as SET somethin like (a,b,c) does anybody know the sql query to be run inorder to get elements like a b c all seperately so as to save it in an array in php script..?? |
| | I know this forum isn't for databases but I couldn't find a proper one so i post here. (my original post is at forums.mysql.com, but not much seems to be happening there) can MySQL server be started as a globally accessible server by using libmysqld? For example, can a application … |
| | I have made stored procedures in Oracle...but need to export them to mysql. I have searched on google but cant figure out the syntax. Here is the oracle procedure: [code=sql]create or replace procedure delgroup (g_id in number) is begin DELETE FROM grouptable WHERE GROUP_ID=g_id; commit; end;[/code] I jus basically want … |
| | Hello, I have a two tables created to apply keywords to a given entry: Table: File FileID (int, pk, auto incr) Name (varchar) Table File_Keyword KeywordID (int, pk, auto incr) FileID (fk) Keyword (varchar) Given that I have a record in table File with 2 corresponding records in table File_Keyword … |
| | Hi, I tried to restore my decompressed database [B]'cyberview_db_2809_2009-10-27_17h30m.Tuesday.sql'[/B] using the command : [QUOTE]mysql -h localhost -u root -proot123 info < /backups/daily/cyberview_db_2809/cyberview_db_2809_2009-10-27_17h30m.Tuesday.sql[/QUOTE] but there was no restoration. I checked the [B]/var/lib/mysql[/B] directory where all restored databases are located, and in the 'info' folder, the only script that was available was …  |
The End.