Daten Entnahme

Seite 4 - Genres

Direkt SQL Befehle an der Eingabeaufforderung

					
				C:\Users\J. Tavares>c:\xampp\mysql\bin\mysql.exe videothek -u root -X -e "SELECT
				 * FROM filmen WHERE genres LIKE '%Comedy%'" » c:\xampp\htdocs\dsql\videothek\comedy.xml

				C:\Users\J. Tavares>c:\xampp\mysql\bin\mysql.exe videothek -u root --html -e "SE
				LECT * FROM filmen WHERE genres LIKE '%Comedy%'" » c:\xampp\htdocs\dsql\videothek\comedy.html

				C:\Users\J. Tavares>c:\xampp\mysql\bin\mysql.exe videothek -u root -X -e "SELECT
				 * FROM filmen WHERE genres LIKE '%Drama%'" » c:\xampp\htdocs\dsql\videothek\drama.xml

				C:\Users\J. Tavares>c:\xampp\mysql\bin\mysql.exe videothek -u root --html -e "SE
				LECT * FROM filmen WHERE genres LIKE '%Drama%'" » c:\xampp\htdocs\dsql\videothek\drama.html

				C:\Users\J. Tavares>c:\xampp\mysql\bin\mysql.exe videothek -u root -X -e "SELECT
				 * FROM filmen WHERE genres LIKE '%Action%'" » c:\xampp\htdocs\dsql\videothek\action.xml

				C:\Users\J. Tavares>c:\xampp\mysql\bin\mysql.exe videothek -u root --html -e "SE
				LECT * FROM filmen WHERE genres LIKE '%Action%'" » c:\xampp\htdocs\dsql\videothek\action.html

				C:\Users\J. Tavares>c:\xampp\mysql\bin\mysql.exe videothek -u root -X -e "SELECT
				 * FROM filmen WHERE genres LIKE '%Adventure%'" » c:\xampp\htdocs\dsql\videothek\adventure.xml

				C:\Users\J. Tavares>c:\xampp\mysql\bin\mysql.exe videothek -u root --html -e "SE
				LECT * FROM filmen WHERE genres LIKE '%Adventure%'" » c:\xampp\htdocs\dsql\videothek\adventure.html

				C:\Users\J. Tavares>c:\xampp\mysql\bin\mysql.exe videothek -u root -X -e "SELECT
				 * FROM filmen WHERE genres LIKE '%War%'" » c:\xampp\htdocs\dsql\videothek\war.xml

				C:\Users\J. Tavares>c:\xampp\mysql\bin\mysql.exe videothek -u root --html -e "SE
				LECT * FROM filmen WHERE genres LIKE '%War%'" » c:\xampp\htdocs\dsql\videothek\war.html

				C:\Users\J. Tavares>c:\xampp\mysql\bin\mysql.exe videothek -u root -X -e "SELECT
				 * FROM filmen WHERE genres LIKE '%Crime%'" » c:\xampp\htdocs\dsql\videothek\crime.xml

				C:\Users\J. Tavares>c:\xampp\mysql\bin\mysql.exe videothek -u root --html -e "SE
				LECT * FROM filmen WHERE genres LIKE '%Crime%'" » c:\xampp\htdocs\dsql\videothek\crime.html

				C:\Users\J. Tavares>