text:
Q: MySQL default order depends on WHERE
Possible Duplicate:
Default sort-ordering in MySQL (ALTER TABLE … ORDER BY …;)

I have a table like this:
CREATE TABLE IF NOT EXISTS `table_test` (
  `id` mediumint(8) unsigned NOT NULL,
  `country` enum('AF','AX','AL') DEFAULT NULL,
  `number` tinyint(3) unsigned DEFAULT NULL,
  `sort_order` double unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `country` (`country`),
  KEY `id` (`id`,`country`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1;

I have a table for which I changed the default ordering like:
ALTER TABLE test_table ORDER BY sort_order ASC;

This table is never updated and no records are removed or added during its life. This all seems to work so if I use the folowwing query:
SELECT * FROM test_table LIMIT 10

It returns the 10 records in the right order.
And even if I use:
SELECT * FROM test_table WHERE num=3

it returns the results in the right order.
But if I do
SELECT * FROM test_table WHERE country='AX'

It will return the results in reversed order.
Can someone tell me how this can happen?

A: Specifying the ORDER BY on a table is just a help for the engine to speed up queries with the same order. It will not force mysql to always return the result with the same ordering.
Described in this: http://dev.mysql.com/doc/refman/5.1/en/alter-table.html
"ORDER BY enables you to create the new table with the rows in a specific order. Note that the table does not remain in this order after inserts and deletes. This option is useful primarily when you know that you are mostly to query the rows in a certain order most of the time. By using this option after major changes to the table, you might be able to get higher performance. In some cases, it might make sorting easier for MySQL if the table is in order by the column that you want to order it by later. "
So you must use the ORDER BY expression in your queries too.

A: I guess the default order of your index on country is DESC. Because of this, if this one is used you get the "wrong" Order and in all other cases it is different. Not sure if or how it is possible to specify the order of the index in mysql, but i think it is.
But still im not sure if you can rely on the order if you dont specify one. Just add the ORDER BY statement to all your queries.

A: why not you try the query like this :
SELECT * FROM test_table  ORDER BY sort_order ASC LIMIT 10;
SELECT * FROM test_table  WHERE num=3 ORDER BY sort_order ASC;
SELECT * FROM test_table WHERE country='AX' ORDER BY sort_order ASC;

A: The reason why you see this behaviour is probably as follows: because the WHERE clause filters by country, MySQL uses the index on country to find the rows to be returned. Most likely the index rows are stored sorted by country, then by id (the primary key of the table). This means that the most efficient way for MySQL to retrieve the rows is by reading the rows referenced by the index, in the order they appear in the index. The order that the rows appear on disk is therefore irrelevant.
MySQL does provide syntax allowing you to specify the order of an index, but this is currently ignored:
An index_col_name specification can end with ASC or DESC. These keywords are permitted for future extensions for specifying ascending or descending index value storage. Currently, they are parsed but ignored; index values are always stored in ascending order.
You will have to add ORDER BY clauses to your queries in order to guarantee that the rows are returned in the desired order. Incidentally, this is always the case anyway; SQL makes no guarantee that rows will be returned in any particular order, regardless of how the rows are physically stored (unless an ORDER BY clause is present).


According to the phe gaskets profile, it can be divied into symmetrical and asymmetric.Usually symmetrical type is used for diagonal flow plate, the upper and lower sealing surface are flat, symmetrical along the horizontal plane,can be installed positive and negative; The asymmetric type with plane bottom surface and the upper sealing surface is divided into flat, curved and an inclined surface.
One thing that must be emphasized in the structure of the plate heat exchanger seal rubber pad is that there are 2 or 4 discharge holes for the medium to flow out on the two sealing gaskets beside the corner hole.
This structure makes the two heat exchange media not Mixing with each other, any leakage of any medium will leak from the discharge hole to the outside of the equipment, which can easily be discovered and repaired in time.


The Hub Hospice ⁄ NEWS ⁄ Events ⁄ Just One More Week To Get Your Tickets!
The "Tea in the Garden" event, sponsored by St. George's Anglican Church in support of Hub Hospice Palliative Care is only a week away! If you want to enjoy what promises to be a lovely afternoon in a park-like garden near Almonte, you need to get your tickets, which are by advance sales only.
This drop-in tea is being held between 2 and 4 p.m. on Saturday, June 23, 2018 (rain date is Sunday, June 24).
Wear your summer hat, or wear one of ours, while enjoying your tea and homemade goodies. Bring your grandmothers, mothers, daughters, in-laws, grandchildren, and friends for a fun girl's outing.
After you're finished your tea, you can stroll around the beautiful gardens at your leisure.
All proceeds will be donated Hub Hospice Palliative Care, to assist in furthering their important work. Hub Hospice Palliative Care is a "hospice without walls." Trained volunteers provide comfort, compassion and support to our patients, their family and caregivers in North Lanark. They cannot operate without the generous support of the community. There is a continuing need for this service and the need is growing as our population ages.
So, come, enjoy a lovely afternoon and help support this worthwhile cause.
For further information, please check the Hub Hospice Palliative Care website (www.hubhospice.com), and/or St. George's Anglican Church Clayton website (stgeorgechurchclayton.webs.com).
To get your tickets, please call Cathy Cochran, at 613 256-1029, or Lynn Guthrie at 613 256-6453. Tickets are $20, and children under 10 are free.


This consists of a metal beaker with coated balls on its side. THe beaker is charged with the Van de Graaff generator. As the beaker gains charge, the balls rise. This is observed by transferring charge to the projection electroscope with a test ball on a string. Charge remains on the surface and not inside.


text:
Q: Entity Framework Core 6.03 .ToList() not available I'm working on my first .NET 6 project and I'm using EF to run an inline query and creating a list of objects. However, I don't have .ToList() as an option; I only have .ToListAsync(). From doing a little research is looks like .ToList should still be available so I'm not sure what I'm missing.
This is what I have installed:
<ItemGroup>
    <PackageReference Include="Microsoft.EntityFrameworkCore" Version="6.0.3" />
    <PackageReference Include="Microsoft.EntityFrameworkCore.Tools" Version="6.0.3">
      <PrivateAssets>all</PrivateAssets>
      <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
    </PackageReference>
    <PackageReference Include="Microsoft.Extensions.Hosting" Version="6.0.1" />
    <PackageReference Include="NLog.Web.AspNetCore" Version="4.14.0" />
    <PackageReference Include="Oracle.EntityFrameworkCore" Version="6.21.5" />
  </ItemGroup>

A: Add using System.Linq; to the top of the corresponding file.
ToListAsync is an extension method for IQueryable coming from Microsoft.EntityFrameworkCore namespace while ToList is a framework build in method from System.Linq.
Another option is to set ImplicitUsings to enable in the .csproj file to leverage automatic import for default namespaces based on the type of project SDK (read more here and here):
<PropertyGroup>
   ...
   <ImplicitUsings>enable</ImplicitUsings>
   ...
</PropertyGroup>

redpajama_set_name: RedPajamaStackExchange


This week is Science Week. In Ms. N Kelly's class, we've been learning about the process that engineers and designers go through when building bridges. We drew up blue prints and built prototypes in line with the criteria outlined in the design and make Building Bridges challenges. Check out some of our bridges and how we tested them below.
Welcome to our 4th Class Blog!


Drawing on the expertise of four internationally recognizedauthors, the book is packed with state-of-the-art informationwithin the framework of daily practice. Mit dem amazon-Kindle ist es aber nicht kompatibel. A complete physical examination, electrocardiography, systolic arterial blood pressure measurement, thoracic radiographs, and echocardiography were performed. Transdermal administration provided lower and inconsistent plasma atenolol concentrations. Cardiac Screening Programs Section Q: Which Drug forWhich Disease? The pathophysiology of sodium and water retention in heart failure is characterized by a complex interplay of hemodynamic and neurohumoral factors. Plasma volume increased by 13. The study was conducted as a repeated-measures design.
Cardiopulmonary Arrest and Resuscitation 19. Bruno Pypendop Section P: Cardiac Screening Programs Chapter 28. Six healthy Beagle dogs weighing 9. Urine volume and urine Na + and K + were measured. Doppler echocardiography allows measurement of early transmitral blood flow E and the velocity of the mitral valve annulus Ea. Designed for use in clinical practice, this reference combines cutting-edge information with practical applications, using a consistent format for ease of use.
Two polymorphisms did not change the amino acid produced and are unlikely to be clinically significant. Oral administration of atenolol at a median dose of 1. Moreover, it is positively correlated to 1 thrombocytosis due to the release of potassium from platelet granules during coagulation, 2 erythrocytosis due to the dilution of the released potassium in smaller volumes of serum, and 3 the presence of activated platelets, which have the capability of aggregation at a higher speed and release more potassium during degranulation. Additional studies in dogs with spontaneous disease are warranted. There are no reports on the effects of torasemide in cats and dogs. Feline Cardiology provides detailed, species-specific information that is absent from other texts, with an emphasis on the most commonly encountered feline cardiovascular diseases. Left atrial pressure was decreased similarly after the administration of carperitide 0.
Comorbidities: Managing Cats That Have Coexistent Cardiac Disease and Extracardiac Disorders Section M: Pulmonary Arterial Disorders Chapter 25. Am J Vet Res 2008;69:1034-1049. The R2 value for the linear regression equation containing E: Ea as the dependent variable 0. Feline Cardiology provides a comprehensive single resource to managing cardiovascular disease in cats and is a welcome addition to any small animal practice library. It was originally attributed to the release of potassium from platelets during platelet aggregation and degranulation, and a significant correlation between pseudohyperkalemia and platelet count was established.
Significantly revised Echocardiography chapter features the latest information on indications and the role of the electrocardiogram in clinical practice. Feline Cardiology provides detailed, species-specific information that is absent from other texts, with an emphasis on the most commonly encountered feline cardiovascular diseases. This invaluable, practical reference covers the full breadth of canine and feline cardiology diagnosis and management in a straightforward and clinically focused format. It provides easy-to-locate key information for quick reference by the busy or less experienced veterinarian, while incorporating in-depth and advanced material of interest to the more enthusiastic practitioner, referral clinician or those undertaking further study in small animal cardiology. Cardiovascular Disorders in Systemic Diseases 15. The four authors have done an amazing job getting this material together from distant sites and yet have managed a hard task in making the book into a unified and well organized text.
Drawing on the expertise of four internationally recognized authors, the book is packed with state-of-the-art information within the framework of daily practice. To describe the disposition of and pharmacodynamic response to atenolol when administered as a novel transdermal gel formulation to healthy cats. Comorbidities: Managing Cats That Have Coexistent Cardiac Disease and Extracardiac Disorders Section M: Pulmonary Arterial Disorders Chapter 25. Increased salt intake also attenuates the antihypertensive effects of most antihypertensive drugs. The most significant prognostic indicator is initial response to chemotherapy, with cats that survive the initial induction period generally achieving long-term remission. Arterial Thromboembolism Section I: Systemic Hypertension Chapter 21. In one case the stricture was definitively diagnosed at post mortem examination, in the three other cases, definitive diagnosis was by endoscopy.
Drawing on the expertise of four internationally recognized authors, the book is packed with state-of-the-art information within the framework of daily practice. Diagnosis of cardiomyopathy of cats is based on 2-dimensional 2D echocardiography. No other differences were found between the 2 groups. All cases were young to middle age median age 3 years; range 1-7 years , and either domestic shorthair or domestic longhair breed. However, systolic, mean, and diastolic arterial pressures as well as arterial pH, and oxygen and carbon dioxide tensions were not significantly different from baseline values.
The same volume of fluid was administered for both methods. Volumes of introduced and recovered fluid were recorded. Coverage ranges from basic and advanced treatment approaches for cardiomyopathies, arrhythmias, and many other disorders to the newest information on genetic testing, circulating markers of heart disease, and more. Thus, these salt-induced changes in both systemic blood pressure and the renal microcirculation create a favorable theoretical scenario for progressive renal injury. Experimental, randomized, cross-over, and interventional study. The attenuated response to diuretics in heart failure is both disease-specific and separately influenced by the rate and extent of diuretic absorption, the rapidity of diuretic tubular delivery, and diuretic-related hypertrophic structural changes that surface in the distal tubule.
Acquired Valvular Disease Chapter 16. Pulmonary Thromboembolism and Pulmonary Hypertension Section N: Endocrine DiseasesAffecting the Heart Chapter 26. Thus far, investigations into molecular markers and immunophenotyping have failed to identify useful prognostic indicators. During the last few years, several studies including six randomised, controlled trials reevaluating therapeutic paracentesis in the management of cirrhotic patients with tense ascites have been reported. Drawing on the expertise of four internationally recognized authors, the book is packed with state-of-the-art information within the framework of daily practice. The dorsal pedal artery was catheterized for measurement of arterial blood pressures and blood gas tensions.
Designed for use in clinical practice, this reference combines cutting-edge information with practical applications, using a consistent format for ease of use. Feline Cardiology provides a comprehensive single resource to managing cardiovascular disease in cats and is a welcome addition to any small animal practice library. This study compared the diuretic effects of furosemide and torasemide in cats and dogs. Endocrine Diseases Affecting the Heart Section O: Anesthesia in the Patientwith Cardiac Disease Chapter 27. Miscellaneous Myocardial and Other Structural Heart Diseases Section F: Arrhythmias and OtherElectrocardiographic Abnormalities Chapter 18. No differences between the 2 groups were found for changes in either magnesium status or echocardiographic parameters. Feline Cardiology provides a comprehensive single resource to managing cardiovascular disease in cats and is a welcome addition to any small animal practice library.


"I am both perfectly willing and able to decide the best course of action based on the wants and needs of everybody." "No, I want to argue pointlessly and accomplish nothing." "You're hired!"
The Electoral College was a mistake. Underpopulated areas full of wing-nuts shouldn't get to decide policy for a whole country.
And what happens when those "Underpopulated areas full of wing-nuts" secede or revolt because we let the city folk decide everything for them? They can live without the cities, but the cities can't live without them. Ultimately the system was designed with the knowledge that what the people in urban areas would want would be wildly different than what those in rural areas would want, and so to prevent a "tyranny of the majority" the power between the two demographics was equalized.
Not that it matters either way. The system of democracy itself is designed to select the worst possible candidates. Regular people are too easily manipulated, the surest way to earn their vote is to be as corrupt as possible, lie at every opportunity and use money from special interests to buy advertisements. At least with monarchies there was a random chance that a good ruler would be born, with democracy you are guaranteed a corrupt one will be selected every time.
Oohh . . . Petey fights dirty!
B) We needed some sane method of reliably producing a fair and obvious result out of that, while minimizing the potential for state-sponsored lies and cheats.
C) Anyone trying to run an actual, coordinated, popular-majority, nationwide, direct democracy presidential campaign was insane at best, and a filthy dangerous evil demagogue at worst.
And most of those concerns are still perfectly valid today.
You think it's bad NOW, when Texas or California use Block Voting to cast all their electoral votes for one candidate?
And Texas or California replied by saying "Voting is still a State Matter, handled by the Secretary of State, in accordance with Local Laws.... We're just required to file a popular vote total now, instead of an Electoral Vote total. Therefore, it remains the official policy of our state to continue Block Voting. Whichever Candidate gets a plurality in our state election for president, the Secretary of State will then inform Congress that, for purposes of State Vote Totals, EVERY LEGAL RESIDENT in the state is "reported" as having "voted" for the winner. Regardless of who they actually voted for, or whether they even showed up at the polls at all.
And that's just ONE of the many, many shenanigans and unintended consequences which would immediately crop up if we tried to switch to direct popular voting.
There's a good reason why every other major western democracy either doesn't have a direct vote for Head of Government as such, or else has a voting system for picking one which is much, much worse than ours currently is.
And what happens when those "Underpopulated areas full of wing-nuts" secede or revolt because we let the city folk decide everything for them?
You let them and then take bets on how long it takes to see them crawling back.
I mean, when you think about it, Peter is everybody's *Landlord*. These habitats wouldn't exist without him and him alone, and he has no reason to actually SELL and of the "land" he created.
Him letting people "help run the city" is a completely unnecessary bone that he throws the most vocal of his tenants to make them feel important.
The "Dominion" is less government than it is an enormous company town. One presumes that to live there you need to sign contracts and rental agreements.
You ignored his second line, but to answer your question, when the mantle of our planet can be measured in the single digits on the Kelvin scale.
I can grow my own, thank you.
Got enough for your neighbors?
And do you have enough to get through to harvest time?
Most major cities have three to five days of food . . . then it's Solyent Green and long pig.
That's all true, but to be fair the rural people who would be seceding are not the ones who feed the cities. The ones who feed the cities are the massive mega farms run by cold heartless corporations who are just fine with the way things are run already since it makes them so much profit.
"It's all well and good to let the perfect man run the government, but what happens when the perfect man gets a stomachache?"
That's the normal point brought up here.
Sadly, when the perfect man is literally running the life support systems and fighting to keep you all alive from intergalactic intangible entities, what happens is probably "everyone dies horribly".
Given Petey HAS shown he intends to do the right thing for everyone, and has shown to be reasonable when there's a better way of doing things, AND tries to ask permission first if doing so would provide a voluntary denial in time, signing up to help really isn't a bad deal.
If all else fails, there's trade negotiations. Or I get murdered, which is also perfectly fine, least saves me the headache of listening to their screeching and incredibly rude offspring. Or we could skip right to the part where I get called some sort of a "liberal bleeding heart city snowflake" or something, and be done with it, because it has nothing to do with the issue at hand.
Actually it's weird, in this context, Petey would be "that guy in the city deciding everything for the country boys, so what when they get fed up or secede"? My answer would likely be "he gets saved by his powers of Plot Device", but who knows.
No, no. You accept that murder is on the table, clearly you aren't a snowflake.
In this context, Petey would be clearly in the "not a democracy" category. There's no room for a Tyranny of the Majority when the government is fully autocratic. He also personally operates all of the essential systems, from maintenance to food production, so if anyone were to try to "secede" the most valuable thing they could take with them would be a scientific mind.
The US department of agriculture reports that 90% of US agricultural production is by family farms.
The remaining 10% is not what feeds our cities (it is what produces much of the seed/feedstock used by the family farms, but that's a problem that can be dealt with much more easily than lack of farms).
Edited to add: You are not Monsanto's customer, nor is the grocery chain down the street from you, the family farms are Monsanto's customers. As a cold and heartless corporation, in the event of a rift between people who are their workers and their customers, and people they do not do business with at all, guess which way they'll go.
Family farms classified as SMALL are over half of production, and I've known a number of large farm owners, they still work the farm.
You will starve if you depend on the corporate owned farms, especially if their workers secede without them.
Your ignorance of where your food comes from does not make your claim that you can produce your own, or your belief that the agricultural states need the urban ones as much as the reverse case particularly credible.
Last edited by Doug Lampert on Wed Apr 17, 2019 2:17 pm, edited 4 times in total.
If anybody tried to secede, he'd probably just dump them on some inhabited planet or station where they could find their own way somewhere. Like I said, he *built* everything in his territory, he's under no obligation to let people stay on them. He does so because he doesn't WANT to keep everybody out.
Exiling the really annoying ones is a better alternative.
The remaining 10% is not what feeds our cities (it is what produces much of the feedstock used by the family farms, but that's a problem that can be dealt with much more easily than lack of farms).
I think you misread the pie charts. Farms classified as "small" are about 22.6% of production by value. "Large Scale" family farms make up 45.2% by value. However, small scale farms take up 50.6% of the land operated, which means they are extremely inefficient, with Large-scale family farms producing about 5.85 times as much value per acre of land.
Of course, I have absolutely no idea how a "large scale family farm" is even a thing.
If you ask an average urban/suburban resident where food comes from, there is a 50% chance the answer will be "the grocery store."
People also vastly underestimate what it takes to feed yourself. My family has a vegetable garden, a small apple orchard, a pair of lemon trees, chickens, ducks, cows, and pigs (we also have quite a few horses, but my aunt would kill me if I ate one of them). All of that merely supplements what we get from the local Walmart and I'm not sure we could reliably feed just 10 people solely with what we produce. I have a hard time believing a rooftop garden on an apartment complex or a half-acre suburban lawn will meet the needs of a family of four.
Large farms can be independently owned and operated, which would make them large family-owned farms.
I used to know a man who owned nearly two and a half sections and leased most of two more for a total of a bit more than four sections . . .
For those that don't know, a section is one square mile or 640 acres. In metric measure, that's approximately 258.9988110336 hectares.
So Jack owned and operated about 1115 hectares as a family operation.
The people that work in the processing plant will be locals, however.
My mother's side of the family used to all be farmers. I don't have the exact numbers, but my great uncle owns and still operates a huge wheat farm that goes for literally farther than you can see. Along with a dairy farm as a side operation. So yes, family farms are still a thing and can be quite large.
But my great uncle is the only farmer left and he's getting old. People are getting bought out by companies. My understanding, and I admit I have not researched this in depth, is that the big companies operate on a contract basis. They lease the seed and equipment to the small farms and then pay them some value for their crop at the end of the harvest. And the contracts are not in favor of the family farmers. So technically it's family farms growing the food, but they aren't the ones controlling production.
Anyway my point was that your individual farmer is not where the individual city dweller gets their food. There is a whole long supply chain through a variety of corporations that keeps things running. If the agricultural areas of the nation secede, then the corporations will continue to operate. And they will sell their goods where it is most profitable. Which is probably not grocery stores, but industrial applications or other countries, but grocery stores are on the balance sheet somewhere. Except now all their workers will be in much smaller less powerful countries that probably can't give them as much regulatory protection against unfair corporate contracts.
And they need those contracts because farmers produce far far more food than they need, but they don't produce the manufactured goods they need to keep their farms going. And in most cases don't produce the variety of foods either. So except for some tiny minority of survivalists who take self sufficiency to an extreme the farmers are dependent on trade too. Shoot when I was growing up we lived out in the middle of the boonies surrounded by cow and chicken farms and everyone still went to the grocery store.
Saying the farms can survive without the cities is just as narrow a view as saying the opposite. Sure farms grow their own food. But there's a reason cities exist, and it's not because they are parasites on the backs of the farmers. Cities are where things are manufactured. If suddenly trade gets cut off, then things will just get chaotic. I can't predict what would happen. The farmers would likely have a higher percentage of their population survive, but they would still suffer.
Which is beside the point, because if the rural areas do secede then the urban regions aren't going to just take that lying down and let the economic fallout hit by itself. There would be another civil war. And frankly the complexities of who would be seceding and who ends up with what parts of the army. And who gets the WMD stockpiles. And who can get international aid, or if the global community has been sent into a death spiral by the collapse of the United States, and many many other things are far beyond the scope of this discussion.
The end result is probably most of the cities being destroyed by rioting. The best farmland being bombed out wastelands, this is a war over agriculture after all so farms are targets, and millions dead on all sides. And that's being optimistic about no WMDs being deployed.
While many city dwellers are stupid enough to bomb the thing they're fighting for, it's unlikely to actually work . . . We couldn't make it work in WWII Germany.
As far as cities being where thing are manufactured . . . that is no longer true. Between the NIMBYs driving out manufacturing and the high costs of operating in cities, many manufacturing plants are now in rural or semi-rural locations.
No, the rural areas cannot do completely without cities, but they can hold out a lot longer than the cities can. Cities would have severe riots in days.
And the corporations might want to keep up business as usual, but it's unlikely they could. They would be unable to harvest, process or ship the food without a lot of rural people . . . who already hate the corporations.
Nobody would really win, but some would lose worse than others.
I can't find statistics on manufacturing jobs broken down any further than the state level. Do you know where I can find data on rural manufacturing.
That's what I'm saying. Though frankly I feel this whole discussion is a little vague. It doesn't lay out any sort of basis for division other than rural and urban with no clarification for what that means. Where do small towns fall into this? Especially ones that aren't farming focused. Plus there seems to be an assumption that all rural dwellers will abandon the cities rather than things splitting up by region, which I think is far more likely.
The cities over that line run the rest of the state and the rest of the state hates them.
And people like that idiot Democrat that seems to think that the appropriate response is to nuke the rural areas into submission are not helping.


Royal wall hangings can complete medieval party decor.
A medieval party gives your guests the chance to feel like kings, queens, knights and courtiers for an evening. As you plan the decorations to go along with your medieval party theme, consider the ways you can use the party space's surfaces to turn the room into a banquet hall or a room in a royal castle.
To give your guests the impression that they are walking into a throne room or a banqueting hall, use simple flag garlands. Make a dramatic, colorful statement without spending a great deal of money by making individual flags out of colored paper. Take tabloid-sized (11 by 17 inches) sheets of paper and cut an inverted triangle into the bottom edges to make banners; decorate each banner with a different medieval image or theme. You might use a family crest, the silhouette of a lion's head, a shield, a cross or a crown, or you can simply add a white outline near the edge for a textured look. String the individual banners on rope or twine and drape the finished garlands in diagonal patterns across the room.
At the entrance to your party, create a walkway suitable for knights and ladies by using wooden dowels and paper flags. Make large triangles out of construction paper; on the shortest side, punch two holes in either corner. Put the dowel through the holes and push the other end into the ground. The paper flag should stand straight out from the pole. Line the walkway to the party with a multitude of colored flags for a festive entrance.
Make the party space feel like a room in a castle by using rich, textured wall hangings. Buy long pieces of material in deep purple, green, blue, gold, maroon and silver colors; look for velvet, brocade, satin and metallic finishes. Cut long rectangles that are just shorter than the height of the room, and cut the bottom so the banner ends in a point. On top of the base, add layers of material, crests or medieval designs such as crowns or fleurs de lis. Fold the top edge over and sew to form a tube. Insert a wooden dowel and tie the ends of a piece of golden cord to each end to form a hanging device. Hang the banners around the room to create a rich, royal feeling.
Make your guests feel like royalty by using over-the-top table settings. Place a banquet table at the head of the room for the feast, and fill it with decorative platters of food. Fill the spaces in between the platters with trailing vines, bunches of flowers or low jugs of wine. For a dramatic touch, use large candelabras filled with taper candles to add a medieval atmosphere. On individual tables, create centerpieces out of low vases of flowers and candles; for additional ambiance, set standing candelabras around the edges of the room.