Forum to discuss the sample database included with MySQL http://forums.mysql.com/list.php?121 Thu, 23 May 2013 11:01:19 +0000 Phorum 5.2.19 http://forums.mysql.com/read.php?121,587120,587120#msg-587120 http://forums.mysql.com/read.php?121,587120,587120#msg-587120
https://www.gameinformer.com/blogs/members/b/watchheatvspacerslive_blog/archive/2013/05/22/mhvsipg1.aspx]]> rob smith Sample Database (Sakila) Wed, 22 May 2013 23:38:22 +0000 http://forums.mysql.com/read.php?121,585451,585451#msg-585451 http://forums.mysql.com/read.php?121,585451,585451#msg-585451
mysql -u root --password=root

My best guess is that the database itself (within Windows 7) has somehow been corrupted. Is there a way of wiping out the old local host database, and downloading a new one, without having to re-install the mysql community server application?]]> Steve Schooler Sample Database (Sakila) Fri, 03 May 2013 23:26:53 +0000 http://forums.mysql.com/read.php?121,580182,580182#msg-580182 http://forums.mysql.com/read.php?121,580182,580182#msg-580182 i don't see any specific setting in the workbench.]]> shri amin Sample Database (Sakila) Thu, 28 Feb 2013 01:21:47 +0000 http://forums.mysql.com/read.php?121,578255,578255#msg-578255 http://forums.mysql.com/read.php?121,578255,578255#msg-578255 When i import my database to phpmyadmin this comes.

Error

SQL query:

--
-- Database: `information_schema`
--
CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

MySQL said: Documentation
#1044 - Access denied for user 'a3317965_smf'@'localhost' to database 'information_schema']]> Nadeem Ahmad Sample Database (Sakila) Mon, 04 Mar 2013 06:30:23 +0000 http://forums.mysql.com/read.php?121,578176,578176#msg-578176 http://forums.mysql.com/read.php?121,578176,578176#msg-578176 Does a user simply register and get added to the table?
That table can be modified by admins?

Please explain the operation of an SQL Database in a website and how it is different from a mySQL database.]]> news int Sample Database (Sakila) Wed, 30 Jan 2013 10:12:29 +0000 http://forums.mysql.com/read.php?121,577129,577129#msg-577129 http://forums.mysql.com/read.php?121,577129,577129#msg-577129
Player:
player_id
mlb_id
name
last
middle
jersey_number
weight
height
birth_date
birth_city = foreignkey (City)
birth_country= foreignKey(Country)
pro_debut_date
primary_position = foreignkey(Position)
team_name = foreignKey (team)
throws_arm = foreignKey(Throws)
bats_arm = Foreying Key(Bats)

City:
name:
Country:
name:
Position:
name:
team:
name:
shortname:
city:
state:

Throws:
arm:
Bats:
arm:

Now about the player stat,

stat:
year:
hits:
doubles:
homeruns:
rbi:
average:
total:

Thanks in advance]]> David Gomez Sample Database (Sakila) Thu, 10 Jan 2013 05:14:34 +0000 http://forums.mysql.com/read.php?121,574925,574925#msg-574925 http://forums.mysql.com/read.php?121,574925,574925#msg-574925
I have table having two column tid,parent
data is mapped as chiled, parent like (tid, parent) (800,0)(810,800)(820,800)(811,810)(811,6457)(808,0)(830,808)(840,808)(5524,830) so on

i want to get data all tid of 807 or 808 etc

this list i need to use in other query's where condition
i try to write function using Group Concat it is fetching records if function directly run but in where codition it is not working

Please help it is urgen]]> vishnu patil Sample Database (Sakila) Thu, 29 Nov 2012 18:46:24 +0000 http://forums.mysql.com/read.php?121,572149,572149#msg-572149 http://forums.mysql.com/read.php?121,572149,572149#msg-572149
mysql> select LineString(AsBinary(GeomFromText('POINT(38.774929 -122.419415)')), AsBinary(GeomFromText('POINT(37.774929 -122.419415)'))) ;
+----------------------------------------------------------------------------------------------------------------------------+
| LineString(AsBinary(GeomFromText('POINT(38.774929 -122.419415)')), AsBinary(GeomFromText('POINT(37.774929 -122.419415)'))) |
+----------------------------------------------------------------------------------------------------------------------------+
| NULL |
+----------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)


mysql> SHOW VARIABLES LIKE "%version%";
+-------------------------+-------------------------------------------------------------+
| Variable_name | Value |
+-------------------------+-------------------------------------------------------------+
| protocol_version | 10 |
| version | 5.0.95 |
| version_bdb | Sleepycat Software: Berkeley DB 4.1.24: (December 16, 2011) |
| version_comment | Source distribution |
| version_compile_machine | x86_64 |
| version_compile_os | redhat-linux-gnu |
+-------------------------+-------------------------------------------------------------+
6 rows in set (0.00 sec)]]> JQ L Sample Database (Sakila) Fri, 26 Oct 2012 00:09:38 +0000 http://forums.mysql.com/read.php?121,568624,568624#msg-568624 http://forums.mysql.com/read.php?121,568624,568624#msg-568624 chandra kumar Sample Database (Sakila) Thu, 11 Oct 2012 19:20:11 +0000 http://forums.mysql.com/read.php?121,565589,565589#msg-565589 http://forums.mysql.com/read.php?121,565589,565589#msg-565589 Error code 1452, SQL state 23000: Cannot add or update a child row: a foreign key constraint fails (`affablebean/prodct`, CONSTRAINT `fk_prodct_category1` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION)
Line 1, column 1
i have changed what was originally part of the tutorial

INSERT INTO `product` (`name`, price, description, category_id) VALUES ('milk', 1.70, 'semi skimmed (1L)', 1);

to INSERT INTO prodct values ('1','milk', 1.70, 'semi skimmed (1L)','2012,07,19',1);
to get this far as i could not get the tutorial to run correctly maybe i have created this problem and you can put me right

pete]]> peter hayward Sample Database (Sakila) Sun, 19 Aug 2012 21:50:06 +0000 http://forums.mysql.com/read.php?121,564376,564376#msg-564376 http://forums.mysql.com/read.php?121,564376,564376#msg-564376 I'm working on soccer league website.
I have a table for matches structured like this:
id
league_id
h_id
g_id
h_goals
g_goals
h_point
g_point

(h means host and g means guest)
point can be 0,1 or 3 depends on match result.

Now, I want to show the ranking league table.

what query(or queries) can I get to do that?

Is there anybody who guide me?]]> Mojtaba G Sample Database (Sakila) Wed, 08 Aug 2012 10:06:16 +0000 http://forums.mysql.com/read.php?121,563336,563336#msg-563336 http://forums.mysql.com/read.php?121,563336,563336#msg-563336 sethumathi N Sample Database (Sakila) Mon, 30 Jul 2012 11:47:22 +0000 http://forums.mysql.com/read.php?121,563045,563045#msg-563045 http://forums.mysql.com/read.php?121,563045,563045#msg-563045
CREATE TRIGGER somatotal AFTER INSERT ON transicao
FOR EACH ROW

UPDATE conta
SET total = new.valor
WHERE idConta = new.idConta

But when I put a block with begin end it does not work:

CREATE TRIGGER somatotal AFTER INSERT ON transicao
FOR EACH ROW

BEGIN

UPDATE conta
SET total = new.valor
WHERE idConta = new.idConta;

END;

I recently downloaded MySQL Workbench 5.2.40.

Thanks.]]> Fernando Bona Sample Database (Sakila) Fri, 27 Jul 2012 15:48:50 +0000 http://forums.mysql.com/read.php?121,560101,560101#msg-560101 http://forums.mysql.com/read.php?121,560101,560101#msg-560101 Eden Bisdee Sample Database (Sakila) Fri, 06 Jul 2012 10:41:41 +0000 http://forums.mysql.com/read.php?121,537027,537027#msg-537027 http://forums.mysql.com/read.php?121,537027,537027#msg-537027
i have created a table called student (stid ,stname,stmarks) where stid is primary key and auto increment. But after deleting some records i want to re arrange my stid but i am unable to do so .

Can anybody please tell me how can i re initialize my Auto increment field.




thanks]]> harishanker srivastava Sample Database (Sakila) Sat, 19 May 2012 11:56:36 +0000 http://forums.mysql.com/read.php?121,522140,522140#msg-522140 http://forums.mysql.com/read.php?121,522140,522140#msg-522140 In my stored procedure/View am using some hard-code values like 'C','D'. Instead of using hard-coded value, i have to get it from Mysql Server like in-built system varibles like @TASK_STATUS...

Is there any way to upload my constant instead of creating new table? I can see some of the system varibles. Like system varible, i need to create my own custom varibles.


Thanks...]]> shiva raaj Sample Database (Sakila) Wed, 28 Mar 2012 07:05:38 +0000 http://forums.mysql.com/read.php?121,521939,521939#msg-521939 http://forums.mysql.com/read.php?121,521939,521939#msg-521939
Can anyone tel me how to create a Mysql database which can be used in Windows OS.

Thanks,
Venkat]]> venkatesh waran Sample Database (Sakila) Mon, 23 Apr 2012 05:18:31 +0000 http://forums.mysql.com/read.php?121,517937,517937#msg-517937 http://forums.mysql.com/read.php?121,517937,517937#msg-517937 Tatenda Muzuwa Sample Database (Sakila) Wed, 29 Feb 2012 09:29:53 +0000 http://forums.mysql.com/read.php?121,516762,516762#msg-516762 http://forums.mysql.com/read.php?121,516762,516762#msg-516762
i am trying to delete 3 rows of data from phpmyadmin and the 3 lines of delete query takes ages to execute.the page just keeps loading even though there is no other sql services running on the server..

the database and table structure really simple.

what might be the issue help please]]> ujj bjl Sample Database (Sakila) Wed, 22 Feb 2012 15:17:26 +0000 http://forums.mysql.com/read.php?121,515932,515932#msg-515932 http://forums.mysql.com/read.php?121,515932,515932#msg-515932
I keep getting an error when trying to creat the sakila database from the command line. I've set up the example directory structure exactly as (apparently) the only de-facto instruction guied for doing so (http://dev.mysql.com/doc/sakila/en/sakila.html).

I simply get the error:

--------------
mysql Ver 14.14 Distrib 5.5.20, for Win64 (x86)

Connection id: 15
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.5.20 MySQL Community Server (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
TCP port: 3306
Uptime: 3 days 1 hour 5 min 7 sec

Threads: 1 Questions: 73 Slow queries: 0 Opens: 43 Flush
les: 0 Queries per second avg: 0.000
--------------

ERROR:
Failed to open file 'c:empakila-schema.sql', error: 2
mysql>

Like some other posts I read by someone having the same trouble, I've tried all kinds of things to get this to work. I beginning to think it doesn't work at all on windows.

Can anyone provide assistance?

Thanks,

Michael.]]> Michael Dealey Sample Database (Sakila) Thu, 01 Mar 2012 02:28:58 +0000 http://forums.mysql.com/read.php?121,514365,514365#msg-514365 http://forums.mysql.com/read.php?121,514365,514365#msg-514365
I'm trying to establish a database of persons on PHP-MySQL.
So I have a first table "test" with three columns: "Nom", "Prénom" and the unique identifier for each entry.
A second table "language" contains the name of the language (FRENCH, ENGLISH ...), and the id of the language.
A last table "rel_lang_pers" is a link between the person id (from "test") and the language id "from"language".

My SQL query is:

SELECT
test.Nom,
test.`Prénom`,
`language`.Langue
FROM test
INNER JOIN rel_lang_pers ON test.`N°` = rel_lang_pers.IdPersons
INNER JOIN `language` ON rel_lang_pers.Idlanguage = `language`.`N°`

The result is then a table with names, first names of the persons and the language each one speaks.
as the same person can speak different languages, in such case i have different entries with the same person's name and first name, and a language for each line.

Is there a way to get the same line with the different languages for the person separated by a comma?]]> GuGu Dhia Sample Database (Sakila) Thu, 09 Feb 2012 07:05:10 +0000 http://forums.mysql.com/read.php?121,514230,514230#msg-514230 http://forums.mysql.com/read.php?121,514230,514230#msg-514230 my asp.net app is sending queries simililar to this one to my mysql database:
Select id,firstname,lastname where 'firstname' like '%john%'

The problem is the apostrophes around the firstname in the where clause, so the query does not return anything. unfortunately, I can't see a way how to get rid of the apostrophes in my asp.net app, because the value is taken from a dropDownlist, put into a predefined sql query and sent directly to the database. Can you think of a way, how to get rid of them using sql? I tried WHERE replace('firstname','\'','') but it didn't help.

Thanks

Dave]]> David Crhonek Sample Database (Sakila) Wed, 08 Feb 2012 11:21:58 +0000 http://forums.mysql.com/read.php?121,511834,511834#msg-511834 http://forums.mysql.com/read.php?121,511834,511834#msg-511834 I am unable to synchronize model to database. When i synchronize the model at first to create database it works successfully. But it won't synchronize after inserted any data in the database. It Shows some error report. Please help me.]]> Vaishnavi R.R Sample Database (Sakila) Fri, 27 Jan 2012 05:56:36 +0000 http://forums.mysql.com/read.php?121,511310,511310#msg-511310 http://forums.mysql.com/read.php?121,511310,511310#msg-511310 table:register
fields:id,username,password,employee_role(3radio button,values 1 for admin 2 for mnager and 3 for employee..

in the table for the employee_role(type:ENUM,values:'1','2','3'

now how to insert these filed datas from php to mysql database???
after successful registration..control shud come back to the login page..

there by giving username and password it shud check whether he is a admin?manager?or employee and then take to their corresponding 3 different pages like admin.php,manager.php and employee.php
how to implement this..


please help me]]> daniel bala Sample Database (Sakila) Thu, 14 Jun 2012 21:24:45 +0000 http://forums.mysql.com/read.php?121,505507,505507#msg-505507 http://forums.mysql.com/read.php?121,505507,505507#msg-505507


http://carpetrepairs.org.nz/]]> Graeme Stephens Sample Database (Sakila) Wed, 15 Feb 2012 06:07:05 +0000 http://forums.mysql.com/read.php?121,505380,505380#msg-505380 http://forums.mysql.com/read.php?121,505380,505380#msg-505380
Find the most rented film per district

(Note: It's possible to have more than 1 'most rented films' per district thus you can assume that a district can have 2 or more 'most rented films')

Please help me with query question. Thanks in advance. :)]]> Pat Atienza Sample Database (Sakila) Sun, 11 Dec 2011 02:37:43 +0000 http://forums.mysql.com/read.php?121,487954,487954#msg-487954 http://forums.mysql.com/read.php?121,487954,487954#msg-487954 I have to design a large db with 30+fields and more than 20 tables..
so it is good to make 2 or 3 db of each related tables.
or any suggestion ????

and what is the limit of MySQL db related to table and size and fields and db size..
waiting for suggestions..
and also data in fields will fill approx 300 records]]> naresh kumar Sample Database (Sakila) Sun, 23 Oct 2011 09:59:48 +0000 http://forums.mysql.com/read.php?121,444046,444046#msg-444046 http://forums.mysql.com/read.php?121,444046,444046#msg-444046
I have seen your post

http://antbits.blogspot.com/2009/01/table-functions-in-mysql.html

But unfortunately didn't understand much :-(


Thanks in advance.

Regards..
Salman.]]> Salman Toor Sample Database (Sakila) Wed, 05 Oct 2011 06:49:15 +0000 http://forums.mysql.com/read.php?121,444021,444021#msg-444021 http://forums.mysql.com/read.php?121,444021,444021#msg-444021
I triple checked everthing and Im sure there is no error in syntax. But one column in my MYiSAM table (named 'datecode') cannot be fetched using stored procedure when called in my php script. However, when I run the SQL query directly on my phpmyadmin client, it works.

Here is the stored procedure

Create PROCEDURE getdatecode (IN indatecode INT (11))
BEGIN
SELECT *
FROM customertable
WHERE 'datecode' = indatecode;
END$$

The procedure was successfully created. But it wont work in php script. However when I run
SELECT *
FROM customertable
WHERE 'datecode' = 101;
directly on the phpmyadmin client, I get results:


What could be wrong? I checked that the PDO script and stored procedure have the same data type. There is nothing wrong with my php script since I get no error message when I load it.


Other stored procedures work when I use other columns from the same table.

Example:


Create PROCEDURE getproduct (IN inproduct VARCHAR (50))
BEGIN
SELECT *
FROM customertable
WHERE 'product' = inproduct;
END$$

The getproduct stored procedure works in my php script, but not getdatecode. Other columns also work fine. Only 'datecode'is problematic.


Please help]]> Ed Villamin Sample Database (Sakila) Tue, 04 Oct 2011 21:16:53 +0000 http://forums.mysql.com/read.php?121,434876,434876#msg-434876 http://forums.mysql.com/read.php?121,434876,434876#msg-434876
I want to use the world DB, and I have successfully created it locally.

http://dev.mysql.com/doc/world-setup/en/world-setup.html

Database can be downloaded from here:
http://dev.mysql.com/doc/index-other.html

My only concern is that a lot (or all) names with special characters are not displaying properly.

For example
Santafé de Bogotá

shows up like

SantafÈ de Bogot·

and

San José

is

San JosÈ

I'm not sure what can be done to get the correct character encoding.

Any help is appreciated

Thank you.]]> Juan Torres Sample Database (Sakila) Tue, 18 Oct 2011 17:47:51 +0000