Jump to content

yrstruly

Members
  • Content Count

    169
  • Joined

  • Last visited

Everything posted by yrstruly

  1. yrstruly

    Stored Procedure

    I have a table: Named HighScores "INSERT HighScores VALUES ('Bob', 2500, '2 Jan 2013 13:13'), ('Jon', 1500, '2 Jan 2013 13:15'), ('Amy', 3500, '2 Jan 2013 13:18')" I want to create a stored procedure that would: The score must show the TOP 5 or so people. Show your position on the high score board Show the person in front and below you on the high score board. If the scores are tied, the person who got it the most recent is shown higher. Can anybody assist me please?
  2. Im am trying to do this SQL code; CREATE DATABASE AdventureWorks2012 ON (FILENAME = '{drive}:\ {file path}\AdventureWorks2012_Data.mdf') I am getting the following error when i run it: Msg 1036, Level 16, State 2, Line 1 File option NAME is required in this CREATE/ALTER DATABASE statement. My file location is: '{c}:/AAPOLLIS-M/Users/aapollis/Downloads/AdventureWorks2012_Data.mdf') What am i doing wrong? Running on SQL Server 2014(free or trial version).
  3. yrstruly

    TERADATA TEO 141

    Hi Any of you on here Teradata 14 Certified? Im trying to get certified. Have all the prescribed study material and also purchased the app. Failed the exam twice as its very difficult to pass and also including questions which are not in the study metrial, but are in the exam. Anybody point me in the right direction,tips etc?
  4. Have tried the phpadmin, how do i import @Q3? Pls provide me with examples or links also API @Q4?
  5. Repeat schedule
  6. Pls assist with last question of task?
  7. Pls see my last Questions and correct me if that link are suitable to search for answers on single query and index?
  8. will this www.w3schools.com/sql/sql_create_index.asp be sufficient to apply index and single query statement, also point 3 i dont understand or know where to search for?
  9. This for a different non academic assigment, text book explains differntly.
  10. Have no clue how to even start this...
  11. I dont know how to design the tables and combine as it is required?
  12. Does Anybody have a SQL code that does the following ones of or is it done in parts?1. DB Schema Design - Design a basic database to store the following information + A fleet of Vehicles - Include details such as mileage, vin numbers etc + A pool of drivers - Include relevant documentation, e.g. Drivesr license, ID Book + A group of routes - Marking out GPS coords for directions etc. is not necessary, just include a start & end address as well as any other info you believe to be pertinent + A drivers schedule, tying the above 3 tables together
  13. Does Anybody knows how to do the following,API's and Indexes etc?CREATE TABLE ¿tUSER¿ ( ¿id¿ bigint(20) NOT NULL AUTO§INCREMENT, ¿id§number¿ varchar(20) NOT NULL, ¿first§names¿ varchar(100) NOT NULL, ¿last§name¿ varchar(100) NOT NULL PRIMARY KEY (¿id¿), <<INDEXES>>)CREATE TABLE ¿tPROFILE¿ ( ¿id¿ bigint(20) NOT NULL AUTO§INCREMENT, ¿tUSER§id¿ bigint(20) DEFAULT NULL, ¿tTYPES§id¿ bigint(20) DEFAULT NULL, ¿value¿ varchar(100) NOT NULL, PRIMARY KEY (¿id¿), <<INDEXES>>)CREATE TABLE ¿tTYPES¿ ( ¿id¿ bigint(20) NOT NULL AUTO§INCREMENT, ¿type¿ varchar(100) NOT NULL
  14. Hi Im having trouble creating a database via php and selecting it.Can anybody help me? <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>Create the Database</title></head><body><?php // Script 12.3 - create_db.php/* This script connects to the MySQL server. It also creates and selects the database. */$connection = mysql_conn
  15. I have included all of the codes and password in the previous posting.
  16. This is what i get when i go the cpanel and select databases or phpmyadmin Current Databases MySQL DB Name b12_12422275_20423 MySQL User Name b12_12422275 MySQL Host Name sql103.byethost12.comMySQL Password musica
  17. yes... I gave u the login details can u pls try.
  18. I am doing everyting like said, nothing works! Anybody who know how to do this pls help, password: musica for login etc.
  19. Can somebody pls help me connect to my online host pls? <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>Connect to MySQL</title></head><body><?php // Script 12.1 - mysql_connect.php/* This script connects to the MySQL server. */ // Attempt to connect to MySQL and print out messages:if ($dbc = mysql_connect('http://yrstruly3
  20. Can anybody tell me how do i start this task, have never used photoshop? HTML Assessment1.doc
  21. I have the following code and i cant connect. usually i can if i leave out the username and password or type it in, but some how i just cant get this one right now. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>Connect to MySQL</title></head><body><?php // Script 12.1 - mysql_connect.php/* This script connects to
  22. Did you have a look at my link @ the bottom?Its the machine im working on, then its working n then not...
  23. Im getting these erros with the register and login codes:<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>Register</title> <style type="text/css" media="screen"> .error { color: red; } </style></head><body><h1>Register</h1><?php // Script 11.6 - register.php/* This script registers a user by storing
  24. When i run the code, it gives the following output: Hello, $name!"; ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <title>Greetings!</title></head><body><?php // Script 3.7 - hello.phpini_set ('display_errors', 1); // Let me learn from my mistakes!error_reporting (E_ALL | E_STRICT); // Show all possible problems!/
  25. yrstruly

    Add A Blog Entry

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR...ransitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>Add a Blog Entry</title></head><body><h1>Add a Blog Entry</h1><?php // Script 12.5 - add_entry.php/* This script adds a blog entry to the database. */if ($_SERVER['REQUEST_METHOD'] == 'POST') { // Handle the form. // Connect and select: $dbc = mysql_connect('localhos
×
×
  • Create New...