Where I Can Get Free DEMO DATABASE And TABLES For My Practice?
I want to hone my skills on MYSQL but i want to have dummy database and tables, and specially the contents of the tables the datas.
because i want to...
practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, practice, and practice.....
View Complete Forum Thread with Replies
Related Forum Messages:
Quick Question About Reseting Demo Database?
I would like to set up a cron job to reset my demo database on a regular basis. Is there a way to export an sql file via phpmyadmin, and run it as a whole via the PHP mysql commands? The only way I can see to do it, I have to split up the exported sql from phpmyadmin into individual queries. I'd like to just process the entire .sql file at once, as it would make maintenence much easier.
View Replies !
Free MySQL Or SQL Database
Is there someone who knows a webhosting provider who provides free SQL or MySQL(rather SQL than MySQL) database which is not limited by numeber of tables for free charge. I found one which is limited by one table, in which I cannot change the name table, cannot create new table etc. I need at least four tables. No matter space limits, may be under 5MB for example. But must be accessable from outside, I mean I want to connect it from Visual Foxpro via ODBC driver.
View Replies !
Can I Upload A MYSQL Database To My Free Web Hosting Space?
I have a domain with awardspace.com which has php and MYSQL enabled. I am a newbie and not quite sure how to set it all up or if it's even possible with the Database I've created on my desktop. When I go to the Database Manager in the administrator section it has a spot to create a database,and confirm a password. From there I take it you would use the PHPMyAdmin to alter the database. Can I just upload a database using an FTP manager like Dreamweaver, or do I need to start from scratch and create the database on this server. If so is there a way to eventually download it so I don't lose any of the information in it.
View Replies !
Which One Is A Better Practice?
Suppose that I want to create a MySQL database table/s to store user info. The info stored (db table columns): ID, username, first name, last name, email, website, location, age, occupation, salary, interests, short biography, additional info, total posts, total topics, user rank, date of birth, registration date. Which one of the following is a better practice and WHY? Creating one table to hold all the user data (18 columns as shown above). Disadvantage: Slower db queries (table search) when records are in thousands. Creating multiple tables (2 or 3) each one to hold part the user data shown above. Disadvantage: Slower PHP script due to multiple db queries on pages where all user data needs to be retrieved.
View Replies !
Best Practice Column
Is there an accepted best practice on whether to store decimal currency amounts (e.g. dollars and cents) in MySQL decimal column types? Certainly, the most straightforward way is to use decimal columns. But it appears that such values are stored as ASCII strings, which would be inefficient for calculations (requiring conversion to a numeric type for each calculation). I guess the alternative would be to use integer columns (and multiply by 100 to store the value as total cents). My particular context is a PHP/MySQL sales system.sie.nctu.edu.tw
View Replies !
Best Practice Normalizing DB?
Users - Zero or more User accounts Albums - Users have zero or more albums that contain zero or more tracks Tracks - Users have zero or more albums that may or may not belong to one album Currently I have one table for each and they are completely normalized and there are no foreign keys to each other. I have a relationship table called rel_user_album_track that looks like this: id : INTEGER user_id : Foreign Key to user table id field album_id : Foreign Key to album table id field track_id : Foreign Key to track table id field When I query this table I will be able to see which users own which tracks and if those tracks belong to albums, which album is it? I'm really looking for feedback on this design... I'm not a DB designer.. I'm just a software engineer trying to think ahead for performance reasons if this makes sense.
View Replies !
Best Practice When Saving Different Datatypes
I am working on a system where I need to save data from a questionnaire that will be of different datatypes either an integer, a boolean/bit or a text value (string to text size). Currently I am working on a model where I create two tables to hold the different datatypes and a column in the question's table to indicate whether the answer should be stored as an integer or a string. Is there some better way to do this? As far as I know I shouldn't create one column to hold all datatypes since the overhead of using a text column to store small integer values (eg. 1-5) would be enormous(?) Mostly the answers will be in the form of small integers like 1-5 or 0-100.
View Replies !
Best Practice To Store Images
I need to make a web app which has quite a number of jpegs to be stored online, what will be the best practice, store it in MySQL database or just in the file system of server?
View Replies !
Best Practice? More Columns Or Another Table?
I have a database with 500,000 or more records in it. It has 73 columns in it currently. I need to add about 16 more columns, for very related data, but its also data that wont be accessed very much. (probably 20% of queries would need info from the new columns) Would it be better to a) Make another table for the 16 columns, and do joins when needed b) Just add the 16 new columns to the existing table?
View Replies !
Best Practice To Record Orders Placed Online
Basically, i'm setting up an online shop, and would like to keep a database of all orders that are placed. The host i've chosen, has provided me with 2 MySQL databases. What's the best way to record each order? Bearing in mind:Each order will have a unique ID,Order IDs must automaitcally increase,Each order may have more than one item (item consists of, type, title, price, quantity and status) I was thinking maybe create a new table for each order? Would it be possible to create a table that contained ALL the orders? What would this look like?
View Replies !
Best Practice For Insert With Foreign Key Replacement
Am migrating some data from one table structure to another. Having trouble with an insert, which appears never to complete. Server is a local XP machine, P4 1.3, 1G memory, plenty of disk space, v5.0.27-community. Have tables A, B, C, and D, all InnoDB. Row Counts: A, 16K B, 250 C, 13K D, Zero (To Be Filled With Eventual Insert Query) A.f1 = A's primary index key (will be new foreign key for D) A.f2 = C's old foreign key B.f1 = B's primary index key (will be new foreign key for D) B.f2 = a text field C = the old data, to be inserted into D C.f1 = the data's old foreign key C.f2 = a text field which matches to B.f2 C has multiple rows containing the various old foreign keys Upon successful completion of the insert, for each row: D.f1 will be A.f1 (new foreign key) D.f2 will be B.f1 (new foreign key) D's other fields will be filled from corresponding fields in C In plain english, I want to do an insert, grabbing most of the fields from C and copying them over to D, but for D's field 1, instead of C's old foreign key (c.f1) I want to use A's new primary index key (a.f1), and for D's field 2, instead of C's old text field (c.f2) I want to use B's primary index key (b.f1). I would end up with the same number of rows in C & D, just those two field's values would be different. Code:
View Replies !
MYSQL Developer Needing Practice
I need a simple database application for my website. I don't have much of a budget however and I'm too busy trying to get my business off the ground to develop the application myself. Is there anyone out there willing to help
View Replies !
Is Using Large Select Queries A Bad Practice
I have been programming a limited bbs system in php, and I was curious as to how I should approach some of the queries. For example, when I do post counts, should I run a query to count how many posts match the member's id, or will that eventually become slow when alot of topics become posted? I thought that maybe I could just simply update a post count value in the members table and use that. Also on the main page I have it count the number of total posts, and displaying the total number of topics as well as replies. Is this a bad thing? I somehow doubt that if I actually use these scripts, that my bbs will become large, but there is always a chance.
View Replies !
Query Help. This Works, But I Don't Think It Is Good Practice
comics: id date location comments: id comicid datetime header comment author Every comic can have multiple comments. Each comic will have a comment, but there is a period of time where the comic is posted but the first comment is not yet submitted. So for argument's sake we can't assume there is any comment at all for a given comic. I want the all the comic ids and dates before a certain date along with the most first comment entered relating to that comic. select comics.date , comics.id , comments.header from comics left outer join comments on comments.comicid = comics.id where (comics.date>=񟭇-03-01') group by comics.id I never defined WHICH header should be returned when many are grouped together. I just know that mysql will return the first one in this circumstance. I seem to recall reading somewhere that different databases handle this sort of thing differently, with some returning a null in that field? I keep trying to forumate a useful subquery but keep drawing blanks just as I think I have it figured out in my head. Like I forget how the string starts by the time I mentally formulate the end....
View Replies !
Best Practice For Updating A Product Table
If I'm given a table with products and I have to update my current db of products, what's the best practice to only update those rows that have changed ? The mysql version of linux diff, if you will. The table I'm given to update with is csv but can dumped into a mysql table.
View Replies !
Is There A 'good Practice' Method For Date Fields?
What I mean is, with using php to insert and pull records from a date type field (called tsdate), should I insert as a unix timestamp or is there some advantage starting with 2006-06-06 and converting later? Just curious. I am dealing with millions of records, indexes are used, load time is good, but I want to (for the future) continually use one method for data records, that's all
View Replies !
Licence Free?
I am migrating a commercial application from DBISAM to MySQL (Delphi) I still dont understand: should I pay for every licence that I install or MySQL is free?
View Replies !
MySQL Free?
I have been using XAMPP as a server on my PC to test my PHP and MySQL code and it is free for those who have not heard of it. My dad was telling me his office was thinking about getting MySQL but it cost money. I went to there web site and it looks as if they have a certified server version (costs money) and a developer version (free). I was wondering if you have a site online running MySQL do you have to buy the certified version or can you use the developer version without any cost.
View Replies !
Free SE Submissions
I remember back in the glory days of the web long gone where I could run through 8-10 major search engines and submit for free. I recently tried to do that with my new site and realized that most are pay for inclusion. Is there a Secret Area to submit at or is it impossible to get into for the most part? Any other free ones besides dmoz and google? Or is it just impossible to get anywhere with hard work and no money now?
View Replies !
Commercial Or Free Reporting
I wondered if you could let me know which is the best report generating package for mysql.... I am looking into open source or commercial packages... I want the package to create me a link where I could add a button to so my user does not see the sql code... they just click the button and pops the charts... The Package must output plenty of charts... I searched through google, but I prefer to know by people that have used the packages
View Replies !
Is Mysql For Windows Free?
I saw in a site that says "mysql for windows is free for one month to continue using it you must get a license". I was planning to use mysql on windows for company database I thought mysql windows version is free. Am I have to use on the linux for free solution?
View Replies !
Free Or Inexpensive Version ?
I am an individual who would like to learn on their own how to use mysql. I am probably wrong, but I thought that being open source there would be a free, or inexpensive, version to "play" with on ones own PC. I cannot afford the Enterprise Version. Is there a basic, or watered down version, available ? (Perhaps, not directly thru mysql.com ?)
View Replies !
Free MySQL DB For A Web Portal
I'm running a web portal in simple HTML with static pages. But I want to setup my portal on PHP+MySQL. I know nothing abt MySQL but a little abt PHP. Can someone guide me setting up a PHP MySQL based web portal. ( including sample PHP pages & MySQL DB )
View Replies !
Form Free Text Field
I have a form free text field for which the user can enter any text. I do not do any scrubbing of this text, ie. checking for some text which could effect SQL statments. I look at my logs an I find alot of the error messages below. For free form text fields what should I "scrub" or run checks for. For example I guess is the users uses a . - or something of the like it can cuase this error. DBD::mysql::st execute failed: 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 'exp communications-in a B2B environment.'
View Replies !
Free Disk Space On DELETE
I'm building a huge DB. One particular table can contain as much as 125 million records. I need to DELETE records older than a year. That part works fine but it doesn't free any space on my hard drive (C:/). I tried OPTIMIZE TABLE and it still won't free hard disk space.
View Replies !
Using Free Version Of MySQL In My Company...
I am a student working part time for a company. I am just starting my final year dissertation and would like to use MySQL to hold a database that I will be making. I was just wondering if I would be breaking any rules by using the free version of MySQL?
View Replies !
Free LAMP-Image - Is It Legal?
I plan to make a vmware image, which contains a LAMP system, that means: Linux (in my case debian or a smaller one), apache, mysql and php5. My question: Is it legal? I want to provide this image for FREE!
View Replies !
Open-source/free DB Modeling Tool
I'm looking for a decent DB modeling/designing tool that is free and supports the following features: 1. Visual design of tables/relationships 2. Syncronization to database 3. Query mode 4. Ability to sync with different database types I've been using DBDesigner, but it has a few bugs that are really annoying.
View Replies !
MySQL: Spam Free (Send/Receive) Emails. HOW?
I would like to create a MySQL to protect my subscribers and clients from receiving a spam emails. I can create a new table for MySQL and write new script for PHP MySQL: mysql_query("CREATE TABLE members( members_id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), email_address VARCHAR(50)") or die(mysql_error()); mysql_query("CREATE TABLE spam_free( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), members_id (INT), fake_email VARCHAR(50)") or die(mysql_error()); ?> PHP: After my client / subscriber sign up as a member of my organization, php autmatically creates a new fake email address with my domain name i.e. doe @ mydomain DOT com in it. PROBLEM: I couldn't find a code or syntax that make mysql to redirect email to my subscriber from my client's email client and vice versa. Once our database matches sender's fake email address, MySQL would redirect sender's email to our member with a real email otherwise die. Is any one of you know the code that can get mysql to work and redirect email without go through php? (not use webmail).
View Replies !
InnoDB Tables And MyISAM Tables In ONE Database?
My application demands some advantages from InnoDB and some from MyISAM. Is it attainable to have both InnoDB tables and MyISAM tables in ONE database? Or else, getting views from two databases, one from InnoDB and the other from MyISAM? If not possible, any other approaches will do the job?
View Replies !
100 Databases, 4 Tables Each, Or 1 Database, 400 Tables
I was able to build, tweak and do whatever necessary to establish a rather different project but am worried that it may sooner or later crash due to idiotic programming / database usage. In essense I took 1 database with 4 tables and duplicate it 100 times BUT because I need to connect to the different tables within the php script and am not experienced enough to created nested database connections, I duplicate the 400 tables within the same database. What I want to know from a MySql perspective, would it make any difference if the script "play around" with 1 database connection and 400 tables or would 100 databases with 4 tables each be better? (Maximum database queries to only 17 tables at a time)
View Replies !
How To Look The Tables In A Database
Can I look at the tables in a database on my hosts server? Like most hosts, the only access they give me is through DirectAdmin, but in the absense of a DirectAdmin forum, I guess the MySQL forum is the logical place for this post. I guess a MySQL command line would allow me to do this, unless there's a different way. How is this done?
View Replies !
Value In All The Database Tables
Is it possible to search for a value in all the database tables using a query ? I assume that a simple query won't do the trick, and a UNION on all tables isn't possible because I wish to keep it as much dynamic as possible (i.e. scheme changes at will). So what I'm actually asking is this : Someone possible knows or heard of a utility that can search the whole database for some value and return the output in some human readable format ?
View Replies !
Database Tables
Use the PHP admin interface with the SQL database. I would like to populate tables of the database from an Excel text file. I keep getting error messages. Does anyone out there have any experience with this? I appologize if this has already been addressed. I searched the forums and did not find this info.
View Replies !
Database With 100.000 Tables
How can I dump a database with 100.000 tables? Right now I got this error: mysqldump: Got error: 1105: File './usr_web20_4/hilarypics_usergroups.MYD' not found (Errcode: 24) when using LOCK TABLES the amazing thing is that the table exists and that the error occures one with this, another time with anohter table. I read something that solves the problem by increasing the max amout of tables to be opend set to default to 1024 in the mysql-config file
View Replies !
Truncating All Tables In A Particular Database.
Is it possible to empty all data in a database containing >300 tables? What is the best solution to truncate all the tables in a database? As I know one way is to export the database structure, drop the database, recreate the database and reimport the database structure. Is there any other way to do it ?
View Replies !
My Tables Back Into A Database
how I can get the backup ( just a file copy of the directory with .frm, .MYI and .MYD files) back into a newly created database. I am failry new to MySQL. Due to a crash of my Windows 2003 server I was in a hurry creating a very quick backup so I didn't tokk the time to find out what a correct backup mechanisme shoul be. Now I have a new server and installed the latest MYSQL (I think I had an earlier version before) I just copied the files into the "mysql datafiles" folder. It doesn't pick them up automaticaly. Can anybody tell me how to get them back in.
View Replies !
XML Specs For Database Tables
Is there any program that takes database schema in some decent format like XML (or html or plain-text) and generates the following: 1. C++ classes that represent each table. 2. C++ methods that let me get/set database records of each table.
View Replies !
|
TRACKER
