hello, i'm trying to import a | delimited text file into mysql using phpmyadmin's import page. a copy of the text file is at http://www.lewissuperstore.com/vehicles/vehicles.txt [http://www.lewiss...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I had a coder enter some php code on my website which every so often completely deletes one of my main data tables. The table is kept intact but all the data is lost.
What should I be looking ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
I am new in mysql..........Please solution this problem.
I created the following table
CREATE TABLE User (
User_Id VARCHAR(25) PRIMARY KEY
);
and I created...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
hi...
i am using the Mysql 5 in the linux operating system.
i have nearly 50 tables. all the tables engine type is InnoDB.
when try to acess the table, the following error comes...
Err...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hey there!
I currently working with mySQL and JSP to build an eCommerce site for a fictional company selling components for desktop computers. The project is part of my course at the universit...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I'm trying to get the value of the primary key for the last row in the database.
The Product_ID field is auto-incremented at every entry and i want to find out what the biggest Product_ID in the...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi there,
Recently, I started getting small periods of intermittent connection errors about once every hour, lasting for about 1 to 5 minutes each time:
Can't connect to local MySQL server t...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello Im Not Sure This Is Where To Post This
but I need some help
I am running a php dating site
http://abmatch.com [http://abmatch.com]>
It was working fine until the database b...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Bay Breeze Software just released SQL Edge 3.0 to support auto-layout and multi-page ER diagrams. The ER diagram view now supports outline view, rulers, grid, page breaks, and multi-page print pre...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am struggling approaching the following problem.
I have two tables
1) contains Top level Site URL
Sites (Site_Id, URL)
2) Contains a trawl of all the top level sites URLS
Trawl ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi every1,
i m facing a problem with my stored procedure,named "procPayment".
I am doing update or insert through this stored procedure depending on whether that empid exist in table...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have couple of questions regarding MySQL (InnoDB storage engine) Disk I/O and caching.
1) How does MySQL write data to disk? Does it write at regular
intervals of time or does it write onc...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi There,
I am new to big databases so need a little bit of help. I have created a web based form which submits the data to a MYSQL database.
What i need to do is take these fields
Name ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
delimiter |
create PROCEDURE loan_vou
(in act char, IN appl smallint, IN doc_dt date, IN ln_amt float(12,2), IN cq_no varchar(15),
IN cq_dt date, IN mem_id smallint, IN Ireg smallint, OUT r...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi All,
Below I have given a stored procedure for User Registration in MS Sql
/******Stored Procedure MS Sql Starts Here*******/
CREATE PROC InsertRegDetails
(
@UserId numeric(9) ,...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
hi...
What is the difference between LEFT JOIN and LEFT OUTER JOIN in mysql table join?
Thanks & Regards,
S.Ashokkumar
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
hi...
i have the tables like....
Table Name : comment
id-----userid-----comment-----added_date
1----- 10 --------- xxxxxx------- 11/1/2006 2:15:20
2----- 4 --------- xxxxxx--------...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have two tables - one with category id, category name, category description
2nd table has data with category id
I want to query the data and have the data listed by category with the categor...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I'm trying to do is delete from multiple tables like using a foreign key, but also be able to delete from just one table if the others don't have a match. For example if I use "t1.id = 2"...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Forgive me as I am extremely new to database design.
I am going to have a database that will have around 7 tables. Each table will have a UserID column that will be used as the Foreign Key (k...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have two tables of time values as so:
Code:
v_times
+-----------+
¦ available ¦
+-----------+
¦ 12:00:00 ¦
¦ 12:30:00 ¦
¦ 13:00:00 ¦
¦ 13:30:00 ¦
¦ 14:00:00 ¦
¦ 19:00:00 ¦
¦ 19:30:0...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi....
i need the query to select the nth maximum value without using the "limit" in mysql 5
Thanks
S.Ashokkumar
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi all,
We am facing a problem while using MYSQL class as static member variable in a class. Here it is our code:
class CDataBaseConnection
{
static MYSQL *conn;
}
While comp...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi
Would anyone be able to look at the following statement and tell me why ORDER BY is not behaving as expected.
Code:
SELECT RTeamName, SUM( RGamePld ) , SUM( RGameWon ) , SUM( RGa...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have a simple table for transactions that will store information like a bank account.
To find the balance for a given user I want to sum all the amounts and display the result
How can I do...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Browse sub-categories 
