100Topics.net

Databases

           


Home > Computers & Tech > Databases

TOPICS

Mysql Problem:

I have just set up mysql and phpMyAdmin. I tried to log in to phpMyAdmin with the correct login of root with no password. PhpMyAdmin didn't care, it just said "Please fill in the password field". Then I tried a couple of sql commands with PHP to change the root password, but none of them worked. Can someone please give me a PHP script to query the database to change the root password?

....know more

Auto Generating Sql Database

IS it possible?? is there any program that does such a thing??create tables automatically when i tell him which script to do it on??and how much would a guy ask from me to do it instead of me??Thanks...Eggie

....know more

Help With Muti-table Query

I am trying to get a category name form a table(categories) based form a id form another table(stories), I can kinda do it but it gives me the wrong one because it's in more than one category. here's the two tables with only the fields I need to use and sample data in them.categoriescatidparentcatidcategory other fields562Right one 1other datas572Right one 2 other datas60-1Wrong one 1other datas615Wrong one 2other datas storiessidcatidother fields16060,56other datas all the right categor

....know more

What Kind Of Databases Does This Server Provide?

What kind of databases does this server provide?i want to know about the databases that i can use in this server ...regardschristian

....know more

A Very Small Db Class For Beginner

May be it helps for an MySQL entryCODE</P><P><?php    class Db_Default{      // connection   var $db_user     = 'username';   var $db_pass     = 'password';   var $db_db         = 'database_name';   var $db_host     = 'localhost';    

....know more

Phpmyadmin Setup

Hi Guys.I am a developer the does a lot of developing for the web in PHP, I need MySQL. I have Apache Web Server and phpMyAdmin installed on my laptop. I can get phpMyAdmin to work but I can't use it because I can't find a file that will let you set up an account.Cheers

....know more

Working With Curl

Have you ever worked on Curl with php Is it easy to learn? Any one has a tutorial for Curl

....know more

How To Connect A Java Applet Or The Html To A Database

i was wondering how to connect to the database from some other source like java or html i just got to know that the connections are made through a jdbc or odbc connection but how to establish them is the question if anyone could answer iti would be happy

....know more

How To Upload A Database Into Internet

i have developed a database on my system and want to upload the database on to the internet and use it for my website how do i do this

....know more

Using <? Instead Of <?php

QUOTE My whole php code begin with <?, not <?php so i upgrade from php 2.2.x to 2.3.0 apparently, now it will only work if my php code start with <?php if i start with <? it will just dump it as html. i got hundreds of php files, most are mixed with html code where php code are all over the place between html, I don't think it's a good idea to automatically do search and replace. to manually do search and replace obviously will take too much tim

....know more

Mysql Service Help Needed

I have just installed MySQL and ran the configuration wizard. The wizard failed to start the service, and I can't start it using services.msc either, this is what comes up in the Windows Event Viewer:QUOTE Plugin 'FEDERATED' is disabled.Plugin 'InnoDB' init function returned error.Plugin 'InnoDB' registration as a STORAGE ENGINE failed.Unknown/unsupported table type: INNODBAbortingForcing shutdown of 1 pluginsC:\Program Files\MySQL\MySQL Server 5.1\

....know more

Composite Key?

I am learning database and i want to know the differernce between the primary and composite keys..and something about the normalization..thankx in advance!!!!

....know more

Dbms Features And Capabilities

QUOTE =Alternatively, and especially in connection with the relational model of database management, the relation between attributes drawn from a specified set of domains can be seen as being primary. For instance, the database might indicate that a car that was originally "red" might fade to "pink" in time, provided it was of some particular "make" with an inferior paint job. Such higher arity relationships provide information on all of the underlying domains

....know more

Phpmyadmin Help Needed

Description:It's a wordpress blog in Hebrew that its database was erased by accident and then restored. While the DB was restored it lost its collation. Instead of the original Hebrew characters I now see ??????? I tried to change the collation in the config.php and in the DB, tables and fields through the phpmyadmin, but I still get the ?????

....know more

Mysql --- Multiple Entries Single Field

Hi all first off I am new here so let me take a second and say hello to everyone for the first time.Iam also fairly new at working with php and mysql actually trying to create my first site using these however I am kind of stuck at how to do something so that it comes out right hopefully you can help me out here.i am trying to figure out how to do multiple entries for the same field an example is this an event calendar where the event is held yearly and I want to be able to go back each year and

....know more

Database Wrapper For Asp

Hello,I have ASP application with MS SQL Database. Now i want to migrate it to DB2 Database .Is there any wrapper which supports MS SQL to DB2 conversion in ASP ??

....know more

Connecting To Mysql Databse

hi, i need help with connecting to a mysql database, i am developing my application in microsoft visual studio with vb.net and require help with the code for the connection string, as i am not using ado.net to connect to the database, i am using a vb class file to connect to the database.CODEPrivate Sub OpenDatabase(ByVal DatabaseName As String, ByVal TableName As String)'declare a variable to store our SQLDim SQL As String'declare a new command builderDim CB As OleDbCommandBuilder'd

....know more

Lists Of Users, Etc In Tables

I'm wondering what the most efficient way of doing this is.I have a table with users in it, each user has a unique id.Now suppose I had a table with groups in it. Each user can join the group. I estimate that the maximum size of a group would be 100 users.How do I store the user IDs in the group table? Do I make a column called `members` and store them in a semicolon separated list? If so, how do I delete members?Then again, there might be other methods I've never even thought of

....know more

Best database

When it comes to the best Database, a lot of stuff needs to be considered1) Size2) Ease of use3) Embedded Nature4) Licensing5) Enterprise Orientedness6) Features1) Size: Oracle is synonymous with databases in companies where there are a huge number of records in the database. Nothing can come close to it.2) Ease of Use: Well, this stands for the interface. There is quite some competition here. Oracle is good. MySQL has some third party GUI and cli interfaces that can ease out the job. Sqlite3 is

....know more

Database Management Systems

QUOTE A computer database relies upon software to organize the storage of data. This software is known as a database management system (DBMS). Database management systems are categorized according to the database model that they support. The model tends to determine the query languages that are available to access the database. A great deal of the internal engineering of a DBMS, however, is independent of the data model, and is concerned with managing factors such as performance, concurrency, in

....know more

How To Replicate Ms Sql 2000 To Sql 2005

Hi all,I was having 2 SQL 2000 Servers and I have enabled snapshot replication. Its working fine without any issues.Now I have upgraded one MS SQL 2000 to MS SQL 2005. Is it possible to replicate the data in SQL 2000 to SQL 2005. If possible, how can I do that?Need your help to setup it.Thanks...

....know more

Best Performance Databases From Not-so-far Future (published By Parts)

Part ISome time ago I was acquainted with one very fast bussiness-critical web-server application, and I became very interested, - how does this site work, outperforming fastest GUI applications?And what was told to me.Design has to met with very tight requirements for performance of system: simply to be the most powerful solution by performance, given that it should run on ordinar server equipment.The guys who get this proposal owned some parts of this technology, so they brought up their compo

....know more

Some Help With Data Basing

Hey guys, I'm new when it comes to data basing anything so maybe my post should actually go here. Here is my previous thread on my situation, and do you think that this will all be covered in my basic database?http://www.astahost.com/Bit-Please33-t19865.html

....know more

Login System

I want to make a login system using Mysql. I am amateur in these things so please explain in detail like spoon feeding. I have already made a database in http://www.sitebooth.com now what type of table I should make and and the website or PHP for it . If you think i hav chosen wrong site please give any better database hosting site. Please help meBest RegardsPritesh Gupta

....know more

Free Or Opensource Database/schema Browser?

I was wondering if there were any alternatives to TOAD or PL/SQL Developer that allows you to browse through a database(s), the different schema objects, and perhaps the stored procedure/function/packakge editors.One thing I have tried is to the use the Data Tool Plugins set for my Eclipse but that brings my machine's performance to crawl.One a further note, I am basically looking for Windows environment, with connections to remoate databases.

....know more

Mysql Overhead

Sometimes in a table especially if i do alot of things in it i start seeing overhead then a size near it? what is overhead? and is it essential to optimize the table to fix it? I know its just a press of a button but i'd like to know what happens when i optimize a table.Also when you make a new table you can limit the size of VARCHAR to a number, that number would be the number characters allowed in that column per entry. I'd like to know how the limit works for texts, is it in KB? or nu

....know more

How To Understand A Database Schema

Yesterday while i'm seaching for a data model and database schema at the Library of Free Data Models for a new project of a friend of mine i found there this nice and simple tutorial on How to Understand a Database Schema.As its name says, this tutorial will help you to better understand a Database Schema and covers the following basics topics that every Database Schema must define:QUOTEPrimary and Foreign Keys.One-to-Many and Many-to-Many Relationships.Inheritance."Rabbit's Ears&qu

....know more

Best Database

What is the best free database if some one trying built a social networking website? And how to operate it with dreamweaver 8?

....know more

Pgsql

Hello, i would like to know what server is the easiest to set as a web server?

....know more

Some Useful Database Links.

I thought I would take a moment to point the users here to some of the database resources available for reference and learning. First I will start with actually designing the database. This site by R937 covers the basics of database design. The author is professional database guru and a frequent helper at the at DB forums listed below. The Library of Free Data Models is an excellent resource for finding data models for projects you may have or as examples of well put together data models. With

....know more

Mysql Multiple Tables

It is good practice to use multiple tables to sort out big amounts of data. But once you do that it becomes increasingly hard to cross reference the tables. Mysql has a little beautiful command structure that they have added. You can select multiple tables within one sql query. Example of a basic sql queryCODE$sql = "SELECT * FROM table WHERE row=1";If you noticed that I selected all of the rows in the table. Normally you will try to not select the entire table from the database unl

....know more

Any Website Provide Free Host Mysql Host?

any website provide free host mysql host?i need it because i am using 000webhost.com now but it only provide 2 mysql database... can i know where or how can i get more databasesregards

....know more

Database Access On Remote Server W/jsp

Hello:I am new to JAVA and server-side applications and have a dumb question. I have set up Tomcat on my machine and created a JSP program to query an Access database using a DSN-Less connection. If I publish the page to a webserver and include the .MDB file will it work? I'm not sure exactly what needs to be packaged with my Java application to make it work. Since I don't have a remote server that supports .jsp I cannot really test it. I'm assuming that JDBC driver would be bun

....know more

Selecting More Than One Table

I know you can connect to data base and select a table, can you select a table get what you want from it then select another table with the same command, or do you have to close the first table (is their a command for closing a table)

....know more

Space Needed For Database

Iam assuming the information in the databases i will create will be stored in the 500 MB space i get, but since 500MB isn't enough iam wondering if you guys can tell me how much bytes the following take: Varchar(x),Tinyint,Text,date,smallint,mediumint,bigint,float.... And the rest present when you add/edit a row in a table.Also what are the ranges of tinyint,smallint,mediumint and big int

....know more

Mysql On Computer

I posted PHP on computer? , but for some reason it doesn't show :/. Anyways I am wondering if there is MYSQL on my computer, meaning can i make a data base on my computer? that way i make what i want and upload it when i get hosted =)

....know more

Mysql Database Entry By Excel Sheets

Hello .. I would like to ask if i can use use Microsoft excel files in order to make entries to mysql database.Thanks

....know more

Mysql Database Management

Hi i am new,I have a problem in understanding the query decomposition in D-DB. Can anyone help me to understand the first question of the exercise 25.21 of Elmasri-Navath 4th edition?Consider the following relations:BOOKS (Book#, Primary_author, Topic, Total_stock, $price)BOOKSTORE (Store#, City, State, Zip, Inventory_value)STOCK (Store#, Book#, Qty)Consider a distributed database for a bookstore chain called National Books with 3 sites called EAST, MIDDLE, and WEST.Consider that BOOKS are

....know more

Mysql And User File_priv

HI,I've hit the grain while trying to import file to mysql database - I need to enable file permissions of the database user but this seems not possible with most of the hosting providers. The problem is to set file_priv of the database user to "Y" . This is done in the "user" table of the maintanance database named "mysql". cPanel doesn't allow this. Via the cPanel you can only allow privileges on table querries but you cannot grant host file privileges to

....know more

Accessing Ms Access Database From A Centralized Location?

HiI am a manager at a trading/wholesaling company (and have no programming background). I customized the Northwind sample access database to make invoices and keep accounts for my company. We now opening another office at a distant location. So, the order entry will be done at two points(we plan to use the same Access database).I am not able to figure out how to access the same MS Access database from two different location(as LAN can't be used). Moreover, we can't afford to pay huge sum

....know more

I Have An Error With My Mysql Connection

ok so here's my web page...http://lacrossems.t35.org/it only lags cause its trying to connect to the my sql server...i followed this guidehttp://forum.ragezone.com/showthread.php?t=387249and when i edit my config.php to my host and login info i always get the error cannot connect to the databasehere is my config.php if you can help meCODE<?php$host['naam'] = 'CENSORED';               &

....know more

Mysql Backup With Another Address?

I just got my site hacked!! (don't worry because it is not on astahost) Actually it is a wordpress blog. So I backed up my MySQL Databases with cpanel. Now when I get my hosting approved here at astahost, can I restore those backups? Is the change of the site address going to interfere with this?Is there anyway I can edit those databases to work with my new address?Please help me out here!

....know more

Integrate Access Database Onto Intranet Site

Hey guys, im new here and am looking for answers Firstly, i have designed a database using M$ access, it consists of multiple forms which i plan to host on an intranet website, i need to be able to add records directly from the form on the intranet website aswell as being able to edit/review current entries on forms in the database.My question is, how would i go about integrating these forms onto the intranet website? i plan on keeping the database and the intranet site on the same director

....know more

Sun Bought Mysql

SUN bought the swedish company MYSQL for much money, around 2million each worker got in the company, they did it to come in to the database market, is it a good reson to buy it?

....know more

Database

i have free script but it is working fine on a lot of sites i tried to use it to my web site ....i edit its config.php right and but my database name and my user name and password every thing right and when i try to install it it gives me this error can`t connect to database please choose file from thismobile.sqlcan any body help plz coz i tried huderd of times and no thing happend

....know more

Connecting To A Remote Database

I wondered if anyone here can help.I have a database on a remote server (A). I want to access it through a php script on a different server C.I have allowed access on (A) in Cpanel - mysql dbases - Remote Access by putting the IP address of server CThe host of server (A) has also whitelisted the IP of server C.Though I am having trouble connecting from server C which is with a different webhost.any ideas how to get round this?I have though of SSH forwarding, but I think this can only be used to

....know more

Databases

How do you access databases?Even though i don't have a hosting account yet i want to think ahead. Please help thx,romeo123

....know more

Free Graphical Tools For Databases

There are a lot of different free software in Internet, but I have found only couple of free graphical tools for database adminiatration.On another hand, MySQL is free for non commercial usage. That's way it will be nice to have any good free GUI for this database.I remember the time, when one of MySQL-Front versions was for free, but now it is opened only for testing period.There is also free version of Toad, which is not full Toad, but it looks also very well -However, I am not going to us

....know more

Auto_increment Jumping About

Hello,I've been having very strange problems with AUTO_INCREMENT. It will be sequential for the first 4 or so inserts and display them fine. After 3 or 4 or 5 inserts the FileID, which has the AUTO_INCREMENT applied to it, will then jump to a seemingly random number like 72, 49207, and so on.My SQL for the table in question is:CREATE TABLE `IPR` ( `FileID` int(11) NOT NULL auto_increment, `Filename` varchar(40) NOT NULL, `ContentType` varchar(15) NOT NULL,

....know more

Mysql Problem

Hello guys,I'm making a PHP/MySQL site for a friend of mine who plays an online game where you can create towns, add buildings to them and upgrade them to a newer level.I've offered to make him a small site where he can input his data into a database and keep track of his towns, buildings and levels.I'll show you my database design and then explain what i want to do.Table: townsfield 1: TownID (primary key, auto-increment)field 2: TownNamefield 3: TownTypefield 4: Town DescriptionTab

....know more

Mysql - So Hard

Doesn't anybody think MySQL is so hard to code? I mean think about it, you need loads of databases just for one little script and you have to type things in like<MySQL> ;Host-Username: (blahblah) ;Host-Password: (blahblah) ;Host-DatabaseName: (blahblah)</MySQL>Ok, that MySQL code was random, and it is alot harder than that.If you have expierenced it being hard, you are free to post right in here, mate.

....know more

Itunes - Cannot Connect To Store

When I downloaded the Itunes update (7.6) I installed it, and now I can't use the store. I get a message something like Itunes cannot connect to store, as it was unable to establish a connection to a network. I have been told it might be something to do with norton protection center / norton antivirus, but I am not sure what settings I have to change.

....know more

Mysql Script Help

ok im a real noob to this myswql stuff i know what its for but can any1 write me a script for it for user sigh up and like a myspace type of profile with a forms peferbly Wii FC code Games. Also can some1 explain how to add the forms if it doset bother u guys too much TY

....know more

Not Understanding Mysql

Im not understanding MySql stuff can someone help me when u got to the MySql site and all that other stuff is this like a log of your web stuff or does it help u desigen your website just wanted to know what it does and how do u use this thing.

....know more

Sql Syntax Error [corrected]

QUOTE#1054 - Unknown column 'Eggie' in 'where clause'i get that error when i type this in MYSQLCODEselect bike from members where username=Eggiei have column bike,members and username...and i have information in every of those columns...but why does it say that there is no COLUMN because i said i want info from row where column 'username' is 'Eggie'btw-YAY..my 101 postEDIT:sorry...i just solved it i forgot to put apostrophes CODEselect bike from members where user

....know more

Apache Php With Mysql On Windows [solved]

I have problems running PHP MySQL function in a windows set web environment. PhP scripts are executed but if I try to use mysql connect and other like functions I get a blank window (while using the browser).The command line client is working...I've added the path to libmysql.dll and the extension=php_mysql.dll in the php.ini.

....know more

Subqueries In Mysql

This method is very useful. I always use this when simple queries of linking two tables is not enough.This method is putting a query inside a query.Example:SELECT * FROM table1 LEFT JOIN (SELECT * FROM table2 WHERE field1='id') AS subtableor joining multiple queriesSELECT * FROM (SELECT * FROM table1 WHERE userid='001') AS subtable1 LEFT JOIN (SELECT * FROM table2 WHERE field1='id') AS subtable2You can join more than two queries depending on the output you want.If someone

....know more

Lost Connection To Mysql ,..., System Error: 111 In

While I was trying to connect to my database or even create one using PhP mySQL I was given the followoing error:Lost connection to MySQL server at 'reading initial communication packet', system error: 111 inHas somebody encontered a similar report? I have my database created using the cpanel together with a user name and password.I wonder if it is a server issue? What can you do if you have not access to the configuration files?

....know more

Mysql Query Question

Hii Guyz,I am having this little problem creating a query in MySQL.Problem description:Table: mytableTable Structure:IssueId | ToolName | Status01 | Tool1 | Open02 | Tool1 | Closed03 | Tool2 | Closed04 | Tool3 | OpenNow, I want to get the results in the following form:ToolName | Count(Open) | Count(Closed)For the above input, result will be:Tool1 | 1 | 1Tool2 | 0 | 1Tool3 | 1 | 0There should be NO duplicate toolName in output.Thnaks,Manu.

....know more

Need Help In Database Auto_increment

i am creating a game and i set when someone registers than he gets id...in "extra" i have set it to be "auto_increment" but whenever new player signs up he gets number bigger than 210...(my first id was 211,next was 212,third was 213,fourth got 214) how to set it to go from 1 to infinite? thnx

....know more

I Thought It Was _my_ Sql, Now Sun Owns It

Sun buys MySQLhttp://blogs.mysql.com/kaj/2008/01/16/sun-acquires-mysql/http://blogs.sun.com/jonathan/entry/winds_...nge_are_blowinghttp://www.sun.com/aboutsun/pr/2008-01/sun....20080116.1.xmlhttp://arstechnica.com/news.ars/post/20080...cquisition.html

....know more

Installing Mysql?

Well i have the codes for my game i got them from a friend of mine. He bought them from MCcodes.com and now i am tring to install MySQL to it.. but no luck with all other web host. I don't yet have a account for Astahost but "localhost" will not work no matter what host it is.. the last host that worked was from freehostia but it doesn't support cron jobs. mysql4.freehostia.com was the hostname but the rest of the web host i tried did not tell me the host name they just said to

....know more

World Of Warcraft

Is Hosting a World of warcraft server Illegal?I ask because I was playing and I spotted a ad for a server. I do not have anything to make it with but would like to know before I do anything.Thanks, Apez

....know more

Script Tables On Sql Server Compact

So I have an application that's using SQL Server Compact Edition 2005. I need to export the table schema to a file of SQL statements, containing only the schema...no data, no rows, just the tables, indexes, and constraints.Now, when using SQL 2000/2005 I just use the script table as... feature to do exactly this, but because SQL server Compact Edition doesn't have the support for it, I can't do this.The tables in SQL Server Compact *do* have the information_schema views though, so I

....know more

Access 97 To Access 2003

I need to convert a database that is in Access 97 to Access 2003 but every time i do it using the Convert tools of Access 2003 i got some errors and can't change or add any of the objects -tables, querys, etc- of the converted database.All the errors i got are related to the user priviligies and permissions of the database, is there exists a way or procedure that allows me to reset this permissions???Best regards,

....know more

Access

I was looking to make a site where people need to create an account, and log in to view the main pages.Is it easy, or do-able, to use msoft access to make a database where people are able to sign up with a username and password via my website?

....know more

Oracle Vs. Mysql Vs. Postgresql

Hey Everyone!,Please choose your preferred database s/w!Regards,Avell

....know more

Mysql Question...

I was wondering if you could use mysql databases to combine with a totally different host.Example...I do not want to move my files from my 1and1 hosting.But I am out of databases i need 2 more.Would I be able to use these ones if i decide to sign up for hosting with my 1and1 hosting? like the file is on my 1and1 hosting, just upload myphp or w/e and tables etc to the other mysql...?

....know more

Working Out A Date Has Passed

Right i am curious to how i would work out that exactly 24 hours has passed from a given variable. The variable is taken from a mysql database and reads as follows2007-11-22 10:05:49How would i check if 24 hours has passed or not? So it will work out that the 24 hours has passed at:2007-11-23 10:05:49I have tried datediff from mysql but that didn't quite work. Anyhelp would be great thanks.

....know more

Can I Use Openoffice Base To Connect To Mysql?

How can I connect to my database with OpenOffice 2.3 Base. I know MS Access won't do this since it is only compatible with MS Access/Oracle.Thanksxxxx-jozh-xxxx

....know more

Learning Php/sql Basics

Hello,I've been wanting to learn to create websites for a long time. I'm not sure how hard it will be and how long it will take to learn enough to make my own database-driven website. I studied SQL, basic programming, worked with databases and am familiar with HTML tags, but this all was for work, university and I never paid a lot of attention to details.In the past few days I read beginner's tutorials on PHP/SQL, CSS and even HTML.Now I want to create a simple database with some tab

....know more

Sql Db

Hi! i did find a host with php and so, but it didnt have a database! Do i have to have the sql database on my host, or could i use someone else to host my sql database?! If yes, Does somebody know a good place fr free sql db hosting? I dont want to host it myself, so i need a online host to do it for me! Pls dont come with stupid aswers, i got enogh of them.................................Glad for any answers!

....know more

What Is Mysql With Mysqli

Hi!, what is MySQL with MySQLi because i am hosting phpbb3 site and i got a database types of MySQLMySQL with MySQLiPrestigeSQLI have choosed MySQL now but i am willing to reinstall.xxxx-jozh-xxxx

....know more

Firebird

Do you know what Firebird is?

....know more

Whats Wrong With This?

can someone explain to me whats wrong with the following code, im trying to make a table called person, only thing is, for some reason its not working<?php$con = mysql_connect("mysql3.xxxxxxxx.com","xxxxxxxx_forum","xxxxxxx");if (!$con) { die('Could not connect: ' . mysql_error()); }// Create table in my_db databasemysql_select_db("xxxxxxxx_forum", $con);$sql = "CREATE TABLE person (FirstName varchar(15),LastNam

....know more

Login System Using A Mysql Db

Hi guys, ive got a registration system that looks something like the one below:[codebox]<html><body><form action="insert.php" method="post">Firstname: <input type="text" name="username" />Lastname: <input type="text" name="password" /><input type="submit" /></form></body></html> [/codebox]Then i have inset.php, which looks like the following:[codebox]<?php$con = mys

....know more

My Sql Database Help?

Ok, i am new at web design, i dont know too much about it... I was working on a website for about a month this is what i got, My Web , like i said, i dont know much.. i used FrontPage and did all of that, my current host is AFMU which uses MySQL, but the way it is set up I dont know how to acquire the URL of the database or any information i dont know what it means at all.. i just want to do a simple login feature, i mean this is my first website and i am learning so I think it would be a great

....know more

Database Size?

Well I know that MySQL databases can get rather big, so I was just wondering how big everybodies databases were? Do you have really big ones, or are they relatively small? Also what do you store in them? (just text, or binary data as well)

....know more

All About Databases

QUOTEHi, I noticed there were a lot of questions in all of the database topics, so i went around the internet using different sources, and have some information that will answer your questions and help you understand databases. I hope this helps, and if you have any other questions which arent answered below, please send a message asking. Thankyou.In computing, a database can be defined as a structured collection of records or data that is stored in a computer so that a program can consult it to

....know more

Phpmyadmin Export And Collation Problems

I have a very strange problem with the Exported sql file generated by phpMyAdmin that never happen to me before, the problem is that my data contains some strange characters but when i see them on screen it shows correctly, instead of showing the spanish characters á, é, í, ó, ú and ñ it shows others, for example instead of á shows á, instead of ó shows ó, etc.The other problem i have is that when i use Internet Explorer and want to download the generated sql file to my machine nothing happens

....know more

Public Access Oracle Db?

This may be the stupidest question ever, I don't know, but frankly if this exists it would help me out a lot haha. What I'm looking for is an oracle database set up somewhere that has an open uname/password for the public to use for testing or anything really. I'm just developing something that needs to connect to our oracle db here but we don't want the computers to be required to have the oracle client installed. Currently though all the computers I have access to here DO have

....know more

Entering Data In Mysql

Hello every one,When using enterprise manager with MS SQL server, we get a very good interface to enter information at design time. i.e. Initial population of database. MySQL administrator does not have such a support. If any one knows an administration client that makes that easy, please tell me it will be of great help.I can design a small application for that my self but I want some professional kind of application with ever thing in. SQL server enterprise manager is a good example. Although

....know more

Text Based Game

Hey,I am new to this sight so i don't know a lot of things.Some of these questions maybe off topic since I the FAQ forum does not work for me O_o.I put this under data base thread cuz the main question is about data base.Before that, I was told that i gain credits by posting. How much?Is it a fixed number per post or is it related to number of characters,words or lines. Does the content affect the number of credits awarded?Do replies give credits?Now that thats over I have questions about Da

....know more

Data Base For Online Games

Iam thinking of starting an online game, I have some knowledge in PHP and C++ skills. But I am still new to mysql. I have 2 things to ask, the first is a bit of topic but does this sight allow me to host a game?. 2, how do i make a data base. You know units hp, attack and other characteristics. + people making acounts (sign up by email and verify) and all other things.Can any one help me?

....know more

Can Someone Help Me Install A Script?

Hi ,I need some help installing a script. Actually I have a few that I'd like to install and play around with. Unfortunately I have no clue what I'm doing. So, is there anyone here that would like to answer my questions in msn or maybe even install the script(s) for me. If you're interested and you know how to install cgi scripts, send me a message and let me know your fee. Thanks

....know more

Examining Databases At A Whole Glance

Most of us using databases or doing data minings are not aware of SQL-92 specification seemingly these days.SQL-92 specifiaction is the SQL database query language standard.Oracle,mysql postgresql,mssql and DB2 - most widely recognized SQL database programs - are all closely related to SQL-92 specification for the use of query nevertheless how they implemented SQL-92 specification features inside in the program.Implementation of SQL-92 specification features are applied in the order of Oracle, p

....know more

How Many Concurrent Users For Oracle Database?

Hi friends, How many concurrent users can practically access the oracle database? they say tht the figure is hundreds of thousands users...is there any exact figure?or does the number of concurrent users depend on any other factors as wel? I think depend on parameter 1.session2.processessession Specific connection of a user to an Oracle instance through a user process. A session lasts from the time the user connects until the time the user disconnects or exits the database applicati

....know more

Database Programming In Vba 6.0

hi , i need some sample program in database.thanks

....know more

Mysql--how Do I Order By..

well i would like to recieve the results in the same order a supplied in the IN Argument, ho would i do itPlease help[codebox]SELECT DISTINCT data.id, data.name FROM `data` WHERE category = 2 AND id IN(1957,1923,1921,6628,6377,6360,1942) [/codebox]

....know more

Mysql Connect

Okay, MySQL was installed, as per the guide on php.net, and all of the config done. This was done on a Windows computer with IIS 5 on XP. The comand line will not let me login! The program groups' own shortcut doesn't work! Will any one help?

....know more

How To Learn Mysql?

I want to learn MYSQL but I don't know where to start.Any suggestions of where to start in learning MYSQL?

....know more

Oracle "lite" Alternative?

for college, we run oracle on a win2k3 server that's run on a virtual system like VMware and/or Virtual PC. VMware has it bells and whistles, and makes a nifty gadget, but eats my laptop's resources like there's no tomorrow. So I got rid of the VMware image and VMware itself, and wanted to switch to VPC. Another problem I have, is that I barely have any diskspace left to work with, and those images are at least 4 GB. So I wondered if anyone knew a program that would act as Oracle, bu

....know more

How Do You Make Large Databases?

In a game I'm working on, I would like to have a database of actors/actresses. I'm not sure exactly how to do this. I'm pretty sure with the hosting here, I can only have 99 databases. I'm a little lost as to how to make it. Can all the actors/actresses be put on one database with the specific things I want to include (i.e. how well the do in each genre)? I'm new to Mysql and just need some help as to where to start.

....know more

(help With Sql And Php)retrive Datas From Realted Tables And Display Them!

Hi all..Please help me to write the SQL Query for the following requirement!Im having 3 MySQL tablesSales_usersSales_productsSales_details1st Table (Sales_users) contains unique userID and username for the users!2nd Table (Sales_products) Contains unique Product ID, product Name and Product Description!3rd Table (Sales_details) contacins unique Sales ID, Product ID (Foreign Key), FromUser (Foreign Key) and ToUser (Foreign Key)Sales_users User_id name

....know more

Problems With Php Saving Data Into Mysql

i have a server that says it allows php and mysql and in the control panel i can access mysqladmin and phpmyadmin but i cant get the php to save data into the mysql, i am trying to make a text-based MMOG so i need to save my users/passwords into a database(i thought) and it won't do it, can anyone help me

....know more

Oracle 10g - Dba Less?

Today Oracle is pushing the idea that if you have an Oracle 10grunning in your company then you could survice without a DBA inyour payrollNow I want your opinion on this thing

....know more

Need Phpbb To Nuke Help Offering Cash

Need a phpbb forum converted into a phpnuke 7.9 forum with a template that i already have for nuke. that's pretty much all i need done. there's a few mods like sub forums but other than that, that's all. offering some cash if you can get this done in one day. email hellenis@hotmail.com if you are interested. we need this done ASAP

....know more

Sendmail For Osc Can't Run In A Hosting Without Smtp?

I've just registerd a free hosting with providing the SMTP.the whole install and setup of OSC run well but it can't send any mails in the end.sendmail for OSC can't run in a free hosting without smtp ?

....know more

Need For Helip

HI I am a new member & this is my first partcipation I am reqired to compare SQLIGHT to SQLITE.I need to fined matereals like defintion , features , advantages , dsadvanteges , websites ... etc about the "SQLIGHT" I can't fened any info about it plez provied me wthe some info . Thanks

....know more

Mysql And Php

I don't know if this is the correct forum, but here is my question:I'm trying to test Joomla and some forums in my computer, I have already installed MySQL with the GUI tools, Apache, and PHP with the MySQL and MySQLi extensions, but when I'm trying to install Joomla I get this error: Required Settings Check:------------------------------------- PHP version >= 4.1.0 Yes - zlib compression support Available - XML support Available - MySQL support Unavailableconfiguration.p

....know more

Low cost web hosting